Vba open projects jobs

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Techni...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I have the source code for an open source tool that I need help compiling. It's crucial that the compiled tool is compatible with macOS. Additionally, I have a patch that needs to be applied. I would require concise documentation that outlines the key steps to apply the patch and compile the tool. Expertise in C, open source tools, compiling, and patch application is essential. The ability to provide clear and concise documentation is also a must.

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

As the project owner, I am urgently seeking experienced PHP developers to enhance the capabilities of multiple open source projects. The exact projects requiring development haven't been specified, but the key components will include: Brief description: Members can also upload items (only to designated columns set by administrators). Assumption: The administration will set up a category column—Card Trading. Members who log in can upload related items to sell, but only to that column; they cannot upload to other columns. Let's break it down step by step: User Column: Modify the administrator's product management template. The administrator will set up a category, such as the Card Trading Market. Then, all items uploaded by users will be catego...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm in need of a talented copywriter to create engaging and motivational content for a radio spot. The aim of this project is to promote a product or service to a young adult audience, aged between 18-35 years. Your primary goal will be to craft inspiring content that connects with this demographic, encouraging them to take action, or consider a new perspective. The overall tone should be upbeat, motivational and forward-thinking. Ideal skills and experience for this project include: - Proven experience in creating persuasive and engaging copy - An understanding of the young adult market - Ability to use language and tone to evoke emotions and drive action - Familiarity with radio advertising is a bonus, but not essential. I'm looking forward to working with someone who can ...

I'm looking for an expert specialized in Computer Science (CS), Electrical Engineering (EE) and Mechanical Engineering (ME) to assist me with academic projects particularly focused on Power Systems with emphasis on Renewable Energy Integration. This will require: - Profound knowledge of Computer Science, Electrical and Mechanical Engineering concepts - Expertise in dealing with Power Systems, specifically Renewable Energy Integration into Power Systems - Tools Matlab, Python - Algorithms development Expect your assistance to be comprehensive, covering all bases to ensure outstanding outcomes. Your bid should demonstrate your expertise in these areas.

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

We are a dev team and seeking a highly experienced individual dev with in-depth proficiency in Laravel, Vue, and ...in the morning in IST, so devs can join us after their regular working hours. We are seeking professional, only individual devs (no teams, no groups, no companies, as we are already a company), who can speak and understand English and Hindi. All devs who join our team will get recurring projects from us depending on time available with them. Timely delivery for projects is very important, and hence pls do not join if you are already overloaded with existing work, to just waste time of our projects. Mention the above pay amounts in your bid and that you are ready to work on codecanyon scripts so we can initiate chat and complete hiring. All payments...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

NEED A QUOTE FOR THIS GAME: *BABYCHICKEN Farm Game: Cultivating Connections and Crypto Knowledge* *Game Overview:* BABYCHICKEN Farm Game is an innovative farm simulation game that marries the charm of virtual farming with the cutting-edge world of cryptocurrency. Players are immersed in a vibrant world where they can cultivate crops, raise adorable animals, and engage in a dynamic economy using the game's native memecoin, BABYCHICKEN. Designed for global connectivity, the game offers an inclusive and educational experience, promoting financial literacy and sustainable practices through entertaining gameplay. *Key Features:* 1. *Community-Driven Gameplay:* - Players can work together to build flourishing farms, with options to visit, assist, and trade with each other in real-tim...

One excel file with macro as per the customer requirement

I urgently need a skillful architect or draftsman to draft an engineered floorplan for a 16x40ft open-concept 2-bedroom cottage. The concept incorporates a kitchen, living and dining areas combined into a free-flowing space. Skills and Requirements: • Expertise in architectural design • Proficiency in creating realistic and functional layouts • Prior experience in designing open-concept spaces is a plus Despite the lack of specific features for each section, your creativity will be crucial in developing a comfortable and modern open space. The timeline for this project is immediate, so your ability to work under tight deadlines will be essential. Please note that separate rooms are needed for the two bedrooms and the bathroom. The plan should adher...

I run a content agency(primarily short form content) that edits videos for coaches, hypnotherapists and other projects The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. For longer videos I of course expect the same, but that is not happening that often. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid at least 6usd for every video-edit from day one, and depending on the projects, the price will get higher. It is an easy project, and it is very sreamlined! Every video are tailored specifically by me, then yo...

I'm looking to revamp the Open-Realty Open source templated system significantly. This involves making the first page visited by a user within a session to be their home page. Key areas calling for improvement are: - Navigation: I want it simplified for ease of access and better user experience. - Referrer System: I'm also keen on integrating a rotating referrer system that will list out three referrers in a specific order. Ideal candidates for this task should have strong experience in website redesign, open-source template modifications and experience with referrer systems. Expertise in UI/UX and understanding of user navigation techniques are crucial. Understanding the workings of Open-Realty system would be a plus.

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and d...

I'm in search of a skilled graphic designer with a wide range of design capabilities. As this project is quite open-ended, I need someone who can go with the flow, adapt and create stunning visuals for different applications. Key assignments may include logo, banner and brochure design, but are not limited to these. Key Skills & Experience We're Looking for: • Logo Design • Banner Design • Brochure Design • Flexibility in Design Styles • Creativity and Innovation • Attention to Details Before bidding, kindly ensure that you: • Showcase your past work • Describe relevant experience • Present a detailed project proposal The deadline for this project isn't set yet, indicating the need for a dedicated, committed, and r...

I am a logo design expert. I can create logos as well as design other projects using CorelDRAW application

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool s...should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide ...

We are seeking a talented illustrator to join our team on an ongoing basis. The ideal candidate will have experience creating simple, colorful, and expressive emblems that can be easily translated into embroidery designs. In addition to emblems, the illustrator should also be able to create icons when needed. Responsibilities: Create unique and eye-catching emblems that are suitable for embroidery. Develop icons that align with our brand and design requirements. Collaborate with our team to understand project goals and deliver designs that meet our needs. Revise designs based on feedback from team members and clients. Qualifications: Proficiency in illustration software such as Adobe Illustrator or Procreate. Strong portfolio showcasing emblem and icon design skills. Understanding...

Objective: To create an innovative and modern design for composing a slide that clearly conveys information about Quick Wins/Actions, Responsible Parties, and Expected Results for both the Process Improvement and Project Studies areas. Attached is an initial slide that serves only as a starting point. The team is encouraged to make necessary changes in mode and design to meet the project specifications. The development team should seek inspiration from current slide design trends. It is important that the slide is visually appealing and clearly conveys the necessary information for both areas. Slide Specifications: Division by Areas: The slide will be divided into two main areas, with Process Improvement occupying 2/3 of the slide and Project Studies occupying 1/3. Each area will have i...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I will explain my project details in the chat

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

Hi Sukri Yatman A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

As the client for this project, I urgently require an expert in VBA.

I'm currently knee-deep in the development of an exciting indie open-world survival craft game featuring a strong female protagonist, and I'm on the lookout for a skilled 2D game artist to help bring our vision to life! Project Overview: Our game is about a Forest Ranger who is stuck in a difficult part of the forest. Character, forest environment, and animals have already been done. This is a PC game demo that is set to launch on "Steam." We are planning to tell the game story using creative game art (ex: hand-drawn or sketched). We will try to finish the game introduction story in a maximum 8 creative slides, or it could be 5 pages of comic strips. We're open to various art styles, but we're particularly interested in a visually engaging...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...

I'm looking for a skilled freelancer to refurbish a house into four separate flats, each featuring an open-plan layout. The goal of this project is to create appealing, modern spaces suitable for rent on Airbnb. Key requirements include: - **Layout:** Every flat should be designed with an open-plan layout, ensuring a spacious and flexible living area. - **Amenities:** Each flat should be equipped with essential amenities for a comfortable stay, including Wi-Fi, air conditioning, and a Smart TV. - **Room Configuration:** Every flat should have a single bedroom, a bathroom with a toilet and shower, and a functional kitchen. Ideal skills and experience for this project include: - **Interior Design:** A strong background in modern interior design will be essential to en...

I urgently need an experienced web developer to build an innovative software-themed website. Your responsibilities will include designing and implementing aesthetic, responsive web pages, database management, testing for website functionality, and ensuring user-friendly interfaces. Expertise in JavaScript, CSS, HTML, and web protocol knowledge is required. Familiarity with software-related topics is a plus. Please note, the website's exact purpose remains to be specified - we'll develop this during our creative process. Let's work together to create something extraordinary!

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...

...developer to redesign the user interface of my Open Cart platform. The new UI should be crafted with a professional and corporate aesthetic in mind, combining style with functionality. Key Requirements: - Redesign the user interface of the Open Cart platform to provide a professional and corporate look - Ensure the new design is not only visually appealing but also enhances user experience and functionality The ideal candidate for this project should have: - Proven experience in UI/UX design within E-commerce platforms, specifically Open Cart - A strong portfolio demonstrating a professional and corporate design style - An understanding of user experience principles and best practices in E-commerce Please share your portfolio showcasing similar projects yo...

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

Current logo is good, but I want to upgrade it and maybe have a more party vibe look / setting. the logo should mainly stay the same, but maybe add some attributes. the surrounding circle/text should stay the same, or if you want to make some small changes on it, you are...setting. the logo should mainly stay the same, but maybe add some attributes. the surrounding circle/text should stay the same, or if you want to make some small changes on it, you are allowed to do it. I provide you the illustrator files, feel free to provide first a sketch before you want to continue and spend more time on it If I'm really satisfied, I will provide you with a lot more projects for a wide range of clients in Belgium. I'm trusted on freelancer and I try to work on a long term ba...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm in search of existing web projects that are unique and have potential for further development. Key Requirements: - I'm particularly interested in existing E-commerce websites, Blogging platforms, and Social networking sites. However, if you have a different type of web project that you believe is truly unique and has potential, feel free to reach out. - The projects should be distinct and not based on common templates or themes. - I'm looking for projects that have not been overused or replicated extensively by others. Ideal Freelancer: - You have a track record of creating original, unique web projects. - You have experience with redesigning and adding features to existing projects. - You understand the potential of a project a...

Development and Enhancement of Excel VBA Project Tracker.

I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experienc...

I am in need of a drawing engineer specialist to assist with my residential architectural projects. Your tasks will focus mainly on the structural elements and interior design. I need professional who can handle detailing of the interior space in terms of practical and production friendly 2d drawings, Design will be done on our end and would be shared in the form of sketches concept. One has to have knowledge about the construction of the following : 1. Fixed furniture 2. False ceiling 3. Plumbing 4. Electrical 5. Flooring • Software Proficiency: Proficiency in AutoCAD and SketchUp software is a must. Your advanced skills in these platforms will be leveraged to present architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to a...columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of T...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.

I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.

Dynamic content, on the other hand, gives marketers the power to personalize every step of the customer journey to an individual's preferences, behavior and real-time context. Each user sees timely, relevant content, which in turn encourages clicks and sales. One of the well-known dynamic content example is Amazon's recommendation engine.