Vba exel project jobs

I am looking for a skilled Excel/VBA developer to build a tool that replicates the core functionality of an old program I use. This tool should primarily focus on data analysis and calculations, specifically comparison analysis. Key Requirements: - Proficient in Excel and VBA - Experience in building automated tools for data analysis - Ability to understand and replicate the functions of existing software The tool should facilitate: - Data analysis and calculations - Comparison of different sets of data Please note, we will not be comparing different datasets from the same period or data from different departments. Instead, the primary focus will be on comparing historical data vs. current data. I am open to suggestions on how to best implement this tool, and I am looki...

I'm in need of an experienced Excel macro coder who can help me automate some of my repetitive tasks, specifically around data analysis. Key Responsibilities: - Develop a macro in Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Ex...Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Excel. - Strong understanding of data analysis techniques. - Ability to work independently and deliver high-quality work on time. - Deep understanding of Visual Basic for Application...

I'm in need of an experienced Excel macro coder who can help me automate some of my repetitive tasks, specifically around data analysis. Key Responsibilities: - Develop a macro in Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Ex...Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Excel. - Strong understanding of data analysis techniques. - Ability to work independently and deliver high-quality work on time. - Deep understanding of Visual Basic for Application...

I'm in need of an Excel template designed to handle traffic flow data, specifically tracking various types of vehicles. I require a skilled coder who can create a VBA/Excel macro to automate the creation of this template based on my specifications. Key Requirements: - Crafting a macro/VB code to create the Excel template - Working with traffic flow data pertaining to different vehicle types - Implementing functionality for data summarization - Presenting summarized data in tables Ideal Skills & Experience: - Proficient in Excel and VBA programming - Previous experience with data-heavy Excel templates - Understanding of traffic flow data is a plus - Excellent attention to detail and ability to follow specific requirements

...player to think and engage with the subject matter. Dynamic Interaction Feature: The wheel should be able to spin and stop randomly, displaying specific content (question or activity) for each section. Special Feature: Once a section is selected and completed, it should be hidden or disabled to prevent repetition in subsequent spins. This can be achieved using PowerPoint’s interactive animations or VBA coding (for designers experienced in PowerPoint programming). Full Customization: The game should be designed so that users can easily edit the questions or tasks for each section directly within PowerPoint without requiring advanced technical skills. Provide a simple and flexible interface, allowing users to tailor the wheel’s content to fit different lesson ...

I'm seeking an Excel VBA expert to automate my data entry tasks. This project primarily involves compiling data from multiple files into a single spreadsheet. The data source is strictly Excel, and the destination is also Excel. A TEST TASK MAY BE GIVEN TO YOU. Only bid if you have work in excel VBA. Key Requirements: - Proficient in Excel and VBA - Experienced in automating data entry tasks - Able to compile data from different files - Familiar with Excel to Excel data manipulation Ideal Skills and Experience: - Strong understanding of Excel’s functionalities - Previous experience with similar data compilation tasks - Excellent attention to detail - Ability to meet deadlines

I'm in need of a diligent professional to assist with data cleaning and validation. The data in question is a mix of text and numbers, so attention to detail and accuracy is paramount. Ideal Skills and Experience: - Proven experience in data cleaning and validation - Proficient in handling mixed data (text and numbers) - Exceptional attention to detail - Strong manual typing skills - Previous experience in data entry

I'm looking for a skilled Excel professional, particularly proficient in VBA, to help me link two Excel sheets. These sheets have the same structure and contain mixed data (text and numbers). The task involves counting entries marked "Completed" in the first sheet to update the second sheet. Key responsibilities include: - Developing a VBA script to automate the counting and updating process. - Ensuring the script runs efficiently and correctly across the entire data set. The ideal freelancer for this job should have: - Extensive experience with Excel and VBA. - Strong attention to detail to ensure accurate data linkage. - Ability to deliver the project in a timely manner.

I need help modifying an existing Skyline Chart in VBA. The main task involves changing data ranges in the chart. Ideal Skills: - Advanced knowledge of VBA - Proficiency in handling Skyline Charts - Experience in modifying charts based on changing data Please only bid if you have the relevant experience and can demonstrate your ability to deliver quickly and efficiently.

I'm looking for a skilled Excel professional, particularly proficient in VBA, to help me link two Excel sheets. These sheets have the same structure and contain mixed data (text and numbers). The task involves counting entries marked "Completed" in the first sheet to update the second sheet. Key responsibilities include: - Developing a VBA script to automate the counting and updating process. - Ensuring the script runs efficiently and correctly across the entire data set. The ideal freelancer for this job should have: - Extensive experience with Excel and VBA. - Strong attention to detail to ensure accurate data linkage. - Ability to deliver the project in a timely manner.

I'm looking for a skilled Excel professional, particularly proficient in VBA, to help me link two Excel sheets. These sheets have the same structure and contain mixed data (text and numbers). The task involves counting entries marked "Completed" in the first sheet to update the second sheet. Key responsibilities include: - Developing a VBA script to automate the counting and updating process. - Ensuring the script runs efficiently and correctly across the entire data set. The ideal freelancer for this job should have: - Extensive experience with Excel and VBA. - Strong attention to detail to ensure accurate data linkage. - Ability to deliver the project in a timely manner.

...have a to-do list PowerApp created which has the following functionality. I think this could be pretty widely useful, so feel free to utilize it as you see fit afterward. Reasons for a PowerApp: while still intended for personal use (no broad deployment), it still needs to to function on both desktop and mobile devices within a work environment that exclusively uses the Microsoft suite. While a VBA macro enabled Excel file could achieve much of this functionality for desktop use, the macros would not be compatible with the iOS version of Excel. **Main Function** * The main screen of the PowerApp should display a Microsoft list which contains to-do items. * The user should be able to decide which columns of the list are displayed. * I’m thinking this would be a combo b...

Hi Gaurav, I need your support in fixing an issue I have caused in the solution you completed last week. I have removed one of the columns in the "Combined Calc" and added a new column...... Now all the tables "BCDIJ" have no rows as the column names / position have changed.

I'm seeking an Excel expert to enhance my salon shop's revenue and shares calculation sheet. The focus is on correcting formula inaccuracies and upgrading data visualization components. Key tasks include: - Improving accuracy of formulas to ensure reliable calculations. - Enhancing data visualization with more intuitive charts, graphs, and Pivot tables. - Utilizing conditional f...transparency and fairness. The ideal freelancer would be someone with: - Strong expertise in Excel, particularly in using and creating complex formulas. - Proven experience in data visualization, making use of charts, graphs, and Pivot tables. - Skills in conditional formatting to highlight significant data points. I look forward to your proposals. No need for automation features such as macros or...

I'm seeking an Excel programmer who can create a tool for me to download 5 years of historical data from Y...ASX stocks. Key Requirements: - The data should be downloaded in daily increments. - Whenever new data is being fetched, the old data should be erased and overwritten. - All data should be saved in a worksheet labelled "rawdata" within the workbook. - The tool should allow for manual input of stock codes in a designated cell. Ideal Skills and Experience: - Proficient in Excel programming and VBA. - Familiarity with Yahoo Finance's data structure. - Previous experience in creating similar data extraction tools will be highly regarded. Please note, I do not require any additional data processing or calculations post download. The primary focus is on the...

I need an experienced VBA developer to update my web scraper. The project involves extracting specific match details from a soccer fixtures website and enhancing the overall performance of the scraper. Key Requirements: - Update data extraction methods to capture important match details such as dates and times - Optimize the performance of the web scraper to ensure it runs smoothly and efficiently Ideal Skills: - Extensive experience with VBA coding - Proven track record in web scraping - Strong understanding of soccer fixtures and match details

Review and fix the VBA code in existing Excel file

Excel VBA Macro to extract data from the website dynamically

I'm looking for a proficient Excel VBA expert to help me automate some tasks. This project primarily involves: - Automating the generation of financial reports on a monthly basis. - Setting up email notifications to be sent out with these reports. Ideal candidates will have significant experience in automating tasks, particularly in Excel VBA, and have a good understanding of financial report generation. Please provide examples of similar tasks you have completed in the past.

...the table mentioned above by assuming that the hypergeometric distribution represents the observed values and the binomial distribution represents the expected values. Show that the result strongly depends on the sample size used for the test. Interpret these results, also with reference to the bar charts. To submit: A written report on the topic, including graphics and tables. An Excel program (VBA is welcome) covering all the steps mentioned above. A Mathematica program for all the steps mentioned above....

We're looking for a developer to automate our shipping label creation using EasyPost API from Excel and update tracking information in Shopify. We manage orders in Excel and want a streamlined way to generate labels and send tracking data back to Shopify without manual steps. Project Requirements: Shipping Label Creation via EasyPost API: Develop a macro/function in Excel to create shipping labels using EasyPost API based on order data in the spreadsheet. Customizable label fields: order number, recipient, address, package type, and quantity. Labels should ideally open in the same tab or print directly without additional tabs. Validate data to avoid formatting errors. Shopify API Integration for Tracking Updates: Automatically update tracking info in Shopify by using the Sh...

Adjust VBA code in existing Excel workbook

I'm looking for a proficient Excel VBA expert to help me automate some tasks. This project primarily involves: - Automating the generation of financial reports on a monthly basis. - Setting up email notifications to be sent out with these reports. Ideal candidates will have significant experience in automating tasks, particularly in Excel VBA, and have a good understanding of financial report generation. Please provide examples of similar tasks you have completed in the past.

I need an automation solution for sampling from a mixed-data Excel file. The sample size should be random, based on specific conditional criteria. Ideal freelancer should have: - Strong proficiency in Excel and Macros - Experience with data sampling - Ability to create automation scripts in Excel (VBA or similar)

We are seeking a proficient developer with expertise in Excel and VBA/Macro development to create an automated system capable of fetching ISIN and SEDOL codes for investment funds directly within Excel. The system should handle partial fund names and manage variations due to different share classes, ensuring that all possible ISIN/SEDOL codes for each fund name are retrieved and populated in the spreadsheet. The goal is to automate the retrieval process to enhance our investment operations while eliminating the need for external platforms and maintenance fees.

I'm in need of a Google Sheets and App Script expert or VBA who can assist me in automating some tasks. Specifically, this project involves automating the generation of reports and sending out email notifications on a monthly basis. Ideal Skills: - Proficiency in Google Sheets and App Script/ Excel VBA - Experience in task automation - Knowledge in report generation and email notifications setup. Please provide examples of similar tasks you have completed in the past.

I'm looking for an expert in Excel, particularly skilled in using macros and VBA scripting, to create an automated Excel sheet for tracking room occupancy at an event. Key Requirements: - The sheet should calculate the per day room nights occupied from the total inventory and a retention list. - When I enter a guest's name, check-in and check-out dates, it should automatically calculate and show the occupied rooms and the pending rooms available. - It should generate a daily room occupancy report. - No email notifications are needed. Ideal Skills and Experience: - Advanced Excel skills, particularly in using macros and VBA scripting. - Experience in creating similar automated Excel sheets. - Ability to create clear and concise daily reports from the data.

Hi Gaurav, I have some additional enhancement work for the VBA table manipulation solution you completed for me a few months ago. The existing Power Query needs to be updated to have multiple select criteria from the main data sheet and an additional Power Query created to also filter on a 3rd parameter. This is explained in design doc provided. Thanks, Steve.

I'm looking for an experienced VBA programmer to write a query that checks whether values of parameter2 are within a specific range, in relation to parameter1. The query should apply an outlier removal technique (either Z-score, IQR, or Modified Z-score) that is easiest to handle the data. Key Requirements: - Write a VBA query to assess parameter2 values against parameter1. - Use one of the outlier removal techniques: Z-score, IQR, or Modified Z-score. - The output data must match the data present in the "Data sheet". - Deliver the results in an Excel sheet. In this project, you do not have to consider missing or incomplete data; it can be assumed that all data is complete. Ideal candidates should: - Be proficient in VBA programming. - Have ex...

I'm looking for an expert in Excel VBA who can help me automate my price comparison Excel sheet. This will be used for comparing prices from PDF quotes we receive from suppliers, which contain tables. Key tasks include: - Automating the process of extracting data from PDF quotes and aligning it in Excel for comparison - Implementing a system for price comparison that reflects my current manual process Ideal skills and experience: - Proficient in Excel VBA - Experience with data extraction from PDF - Able to understand and replicate manual comparison process in an automated system This project should significantly reduce the time I spend on price comparison while increasing accuracy.

Looking for Excel VBA expert to construct easy to use Excel spreadsheet that automates engineering calculations. The ideal freelancer for this project should very proficient in Excel VBA, macros with experience in automating mathematical calculations/formulas in Excel. Key Requirements: - Proficient in Excel VBA - Strong understanding of intermediate mathematics - Experience in automating mathematical calculations & formulas in Excel

I need assistance to convert 3 Excel documents (two are attached and third to follow) that are currently functional on a Windows laptop to be compatible ...are currently functional on a Windows laptop to be compatible with a Mac. These documents are essential for data entry and processing, and they contain VBA coding. The primary requirements of this project include: - Ensuring all existing VBA coding continues to operate seamlessly on Mac Excel - Retaining all functionalities associated with data entry and processing The Excel documents do not use any external data sources or connections, simplifying the task. The ideal freelancer for this project should have: - Expertise in Excel and VBA - Experience with cross-platform Excel compatibility - A Mac av...

I'm looking for a skilled VBA developer who can write a script for Excel that will copy cells from specific ranges based on their color. Requirements: - The script should identify and copy cells of custom colors that I will specify. - It should be able to copy cells from specific ranges, not entire rows or columns. Ideal skills for this project include: - Proficiency in Excel and VBA programming. - Experience with writing scripts for Excel. - Ability to understand and implement custom requirements. Please provide examples of similar projects you've completed in your proposal.

Project Description: I am seeking a co-author to collaborate on a research paper titled "Systematic CO-PO Mapping: Integrating Bloom's Taxonomy with Excel for Comprehensive Analysis.". The methodology included cataloging Bloom's Taxonomy keywords, aligning COs and POs, and creating a CO-PO matrix using VBA code. Responsibilities: - Insights and creative input on the project - Write and format the paper according to journal guidelines (guidelines attached in pdf). - Ensure the paper meets academic standards and is ready for submission. Requirements: - Affiliation with a reputable university or a strong academic profile and a native English speaker. - Experience in educational research, particularly in CO-PO mapping and Bloom's Taxonomy. - The...

I'm looking for a skilled professional with extensive experience in SAP scripting, specifically within the MM (Material Management) module, to assist in extracting data for me. Key Requirements: - Automating data extraction from SAP using Excel VBA - Delivering the data in an Excel spreadsheet Ideal Skills: - Proficiency in Excel VBA - In-depth knowledge of SAP MM module - Experience in SAP scripting

I need a VBA script that utilizes Selenium to automate filling out forms on Google Chrome. The script will need to interact with various form fields, inputting custom data that I will define. Ideal Skills: - VBA (Visual Basic for Applications) - Selenium - Google Chrome Automation - Form Automation - Scripting/Programming The project requires a good understanding of how to use VBA with Selenium, specifically for the purpose of automating form filling. The successful freelancer will have experience in writing scripts that can input custom data into specific fields. This is a small project, but if completed successfully, there may be potential for further work.

I'm seeking a skilled Excel VBA developer to automate some tasks on the Fasal RIN portal. The primary objective is to streamline data entry, specifically form filling. Key Requirements: - Automate data entry to save time and improve efficiency. - Handle form filling with varying formats and structures, as the fields are mostly but not always the same. - Ideal skills include advanced proficiency in Excel and VBA coding, experience with the Fasal RIN portal is a plus. - Attention to detail is crucial to ensure that data is accurately entered, even with minor changes in form fields. Please provide examples of similar projects you've completed in your proposal. Thank you!

I am seeking an expert virtual assistant to help manage my business. The role involves Leads generation, customer service, Data entry, Wordpress management and Excel VBA tasks. Key Responsibilities: - Data entry (This is the highest priority) - Customer Service (Specifically responding to customer inquiries) - Lead Generation - Wordpress management - Email marketing (This is the most crucial additional skill) Ideal Skills and Experience: - Extensive experience as a virtual assistant, preferably within IT industry. - Exceptional customer service skills. - Strong organizational and management abilities. Tools: - Experience with other tools like Confluence, CRM, HUBspot and Slack is a bonus.

I'm looking for a skilled VBA expert to help me create a loop that can process data in my Excel worksheets. Key Requirements: - The loop will primarily be used for data processing - It will operate on various Excel worksheets - The main focus will be on accounting-related tasks Ideal Skills and Experience: - Strong proficiency in VBA programming - Extensive experience with Excel data processing - Familiarity with accounting concepts and data Please only bid if you have the necessary skills and experience to meet these requirements.

Need a coder that can make custom export code, to export values from excel to txt file. I will profide a sample txt file and excel values

I'm seeking a skilled VBA programmer to automate the process of filling a Word template with Excel data on a weekly basis. This project is for personal use. Key Requirements: - Expertise in VBA programming - Proficient in Excel and Word - Experience with data manipulation and automation The task involves: - Transferring textual data from an Excel spreadsheet to specific bookmarks in a Word template. - Ensuring the process is efficient and user-friendly for weekly updates. Ideal Skills: - VBA Programming - Excel and Word Proficiency - Data Manipulation - Automation Experience I look forward to working with someone who can streamline this process for me.

I'm looking for a developer who can create a dynamic map of the island of Aruba with all its districts. This map should be able to pull data in real time from an SQL database containing voting statistics. This map must be touch-enabled as it will be used in a large touch screen TV. when the user presses on the district it will show the details of the votes, inside...Proficiency in SQL and experience with SQL databases. - Expertise in creating Choropleth maps and understanding of color-coding for different districts. - Experience in developing interactive, user-friendly interfaces. - Prior experience with election data visualization will be a plus. note: a total of 59 locations to vote and a total of 17 districts locations and districts are all ready (all in exel with past ele...

...then can add another line to add another food). selection for one time form or multiple use form (one time form disappears from users list when completed, unless re-assigned) The form app on the phone or tablet (Samsung to start, then apple) must be able to complete the forms while offline, and once connected to internet, automatically sync the forms. option to send the form via email in ms exel format, .pdf and send to dropbox or sharepoint in both formats. notification area for when the user has a new form assigned to them. forms can be completed more than once. (intent is to use multiple forms multiple times per day), must eb able to create drafts of forms, and add the the form throughout teh day prior to submitting. must have a document tab to download and store do...

...representatives to input data via Excel while storing the data in a centralized database. We require the development of interactive dashboards using a Business Intelligence (BI) tool like Microsoft Power BI or similar. Project Scope: Develop Excel templates/forms for data entry by sales reps. Set up a centralized database to store all sales data. Implement a process to import data from Excel to the database efficiently. Create interactive dashboards and reports using a BI tool. Ensure data integrity, security, and scalability of the system. Requirements: Proficient in Microsoft Excel and VBA for creating advanced forms. Experience with database systems (e.g., SQL Server, MySQL). Skilled in using BI tools (e.g., Power BI, Tableau) for dashboard creation. Strong understan...

...maintain historical records, and provide insightful visualizations for informed decision-making. Project Scope: Create an Excel workbook with individual data entry sheets for each sales representative. Implement user access controls to ensure reps can only access and edit their own data. Develop a main dashboard that consolidates data from all reps and provides visual insights. Incorporate historical data tracking while preventing edits to past entries. Include specific features for tracking maintenance quotes and project statuses. Ensure the solution is scalable, user-friendly, and optimized for performance. Requirements: Proficient in Microsoft Excel, including advanced features like VBA macros and data visualization tools. Experience in creating interactive da...

I need a skilled professional to create custom Word VBA macros for me. These macros should be able to: - Automate formatting - Generate reports - Manipulate text The macros need to be compatible with Word 2016 and later versions. Furthermore, these macros should have the capability to interact with external data sources, specifically Excel files.

I'm in need of a professional with solid expertise in VBA and Excel to help me fix a script that was previously working perfectly for sorting and filtering, but has recently stopped functioning. The project involves: - Troubleshooting and repairing a VBA script in Excel - The script is used for data manipulation, specifically sorting and filtering. Also for downloading and displaying images. Ideal skills for the job include: - Proficiency in VBA and Excel - Experience with simple data manipulation tasks - Problem-solving skills to diagnose and repair the script Please reach out if you can assist. Thank you!

I'm looking for a professional with strong VBA skills to assist with a project involving transaction data. The primary task will be writing code to generate a detailed report from the transactional data. Key Requirements: - Write VBA code to automate the report generation process. - Use provided logic and dummy data to produce the report. The detailed report should cover: - Transaction velocity against customer name , card name, payment methods, schemes Ideal candidates should have: - Extensive experience with VBA, particularly in relation to report generation. - Strong data analysis skills. - Ability to understand and implement provided logic. - Experience with transaction data preferred but not essential. Please note, logic and dummy data will be pro...

Project Title: Excel Expert Needed for Relay Bicycle Team Tracker Overview: I am working with an Excel file related to a race grid for a bicycle team (attached: "BLANK_ Race Grid_Coaches "). The file tracks race predictions with color-coded blocks across multiple rows and columns. The main task is to automate counting colored sets of blocks in even-numbered rows and place the results in specific cells, AND count the number of cell with in each block, this needs to be updated in real time. Key Tasks: Count Consecutive Colored Sets: For even-numbered rows (e.g., rows 4, 6, 8, etc.), count consecutive blocks of the same color. The range of cells being analyzed spans from columns D to BK. The color reference for each row is located in column B of that row. For example, if r...

The aim is to automate (with an app?) a currently manual procedure. Using the VBA codes in 1 Excel doc “A”, transpose the data from one or more cells of this Excel “A” into the indicated cell(s) of an another Excel doc “B”.