Home > Freelance Excel Jobs Share

Freelance Excel VBA Jobs

Find the latest Excel and VBA related work for data science and business analytics

Assistance Needed With Microsoft List Form Fields Not Hiding With Conditional Formula (Tue, 19 Mar 2024)
=if([$Hasaconsentformbeencompleted_x00] == Yes , true , false
This works on all but three columns. It just seems to get stuck on this when I try to do it?
One hour min will be charged for resolution of this issue.
Skills: Data Processing, Microsoft SharePoint
Skills: Data Processing, Microsoft SharePoint

Compare Two Excel Spreadsheets (Tue, 19 Mar 2024)
We imported credit card transactions into Quickbooks and Quickbooks import skipped some transactions. It also imported duplicates. So the QB file does not match the bank balance.
I exported the transactions from QB into Excel. I also exported the bank records into a second sheet. The task is to compare the QB records with the new export and report the missing records as well as the duplicates.
Skills: Data Processing, Microsoft Excel
Skills: Data Processing, Microsoft Excel

Macro Development (Mon, 18 Mar 2024)
Hello,
We are looking for someone with UiPath Macro experience.
You will help us build macros to fill out fields in forms in a Electronic Medical Record app. We would like to automate the process, which is repeated multiple times per day in the same exact way. We are not pulling data from anywhere else. Each time we do this, we enter exactly the same information for each patient.
You will tie into my computer and we will work together. I will need you to speak English well, so that I can understand you and you can instruct me.
This may grow into other work.
Thank you.
Regards,
Ted Bender
Skills: UiPath, Macros
Skills: UiPath, Macros

Script To Upload Excel Numbers To A Portal (Mon, 18 Mar 2024)
I need to transport rows from an excel sheet to a portal with multiple pages after authentication to sign in to upload prices of tenders in one shot precisely
Skills: Spreadsheet Automation, Microsoft Excel, Python, Scripting, Visual Basic for Applications, JavaScript, Automation
Skills: Spreadsheet Automation, Microsoft Excel, Python, Scripting, Visual Basic for Applications, JavaScript, Automation

Excel Macro Expert (Mon, 18 Mar 2024)
- Excel Macros
- Pivot Tables
- Data manipulation
- Attention to detail
- Time management
- Following instructions
The size of the project is small and can be completed in under 1 month. We are looking for an expert-level professional with extensive experience in Excel macros.
Skills: Microsoft Excel, Visual Basic for Applications, Macro Programming
Skills: Microsoft Excel, Visual Basic for Applications, Macro Programming

Transpose Multiple Lines In Excel Spreadsheet (Mon, 18 Mar 2024)
I need lines in column B with values of quot;1 quot; or quot;2 quot; to be added to columns in final spreadsheet. Qualifier Values in column BK corresponding to AppSeqID (column B) of quot;1 quot; or quot;2 quot; get moved to QualifierText2 (column BL) and QualifierText3 (column BM).
As an example, the highlighted data in column BK gets moved to row 7 and then rows 8 and 9 get deleted.
I need a macro coded for this so I can apply it to multiple spreadsheets.
Look at the difference between Tabs quot;Raw Data quot; and quot;Transposed Qualifiers quot;
Skills: Data Processing, Microsoft Excel, Visual Basic for Applications
Skills: Data Processing, Microsoft Excel, Visual Basic for Applications

Help With Remodelling / Recreating A Weekly Cash Flow Forecast Tool In Excel (Mon, 18 Mar 2024)
Hi. We are using QBO and other production systems and need to create a mostly automated Cash Flow forecast tool in Excel that we can use weekly.
Need someone who is experienced with Excel formulas / VBA.
Skills: Microsoft Excel, Financial Modeling, Forecasting, Visual Basic for Applications, Financial Projection, Financial Analysis
Skills: Microsoft Excel, Financial Modeling, Forecasting, Visual Basic for Applications, Financial Projection, Financial Analysis

Looking For Ms Access/excel/vba Developer (Mon, 18 Mar 2024)
YittBox is looking for an MS Access/Excel/VBA Developer to join our agency!
--------------------------------------------------------------------------------------------------
?? IF YOU CONTACT US OUTSIDE OF UPWORK, YOU WILL BE AUTOMATICALLY DISQUALIFIED! PERIOD, NO EXCEPTIONS.??
------------------------------------------------------------------------------------------
Looking for a workaholic, with a great personality. We have a strong team and looking to add to it, but need someone who can communicate and fits in well!
Must be doing the work yourself, NO BACK OFFICE SETUPS
Must have at least 2 years experience in MS Access/MS Excel/VBA
Must be able to work from 3 PM to 11 PM EST
Thank you,
Team Yittbox
Skills: Microsoft Access Programming, Microsoft Access, Visual Basic, Visual Basic for Applications, Microsoft Excel, Data Analysis, Microsoft Power BI, Data Extraction
Skills: Microsoft Access Programming, Microsoft Access, Visual Basic, Visual Basic for Applications, Microsoft Excel, Data Analysis, Microsoft Power BI, Data Extraction

Excel Specialist To Build An Automatic Calendar (Mon, 18 Mar 2024)
Need a specialist who can help to setup an automatic calendar in Excel based on the data entry. I.e. On calendar we need to fill in with color certain dates and dates would be entered in certain cells. Willing to show what I mean during the call to a choosen candidates.
Best,
Mike
Skills: Microsoft Excel, Excel Macros, Excel Formula, Visual Basic for Applications
Skills: Microsoft Excel, Excel Macros, Excel Formula, Visual Basic for Applications

Macro (Mon, 18 Mar 2024)
Creating a Macro pull to re-visualize a RPT file into a excel template. The data pulls from a notepad .RPT file. I would like a macro VBA template created to rework the data to something similar to the template example I have attached.
Budget: $50
Skills: Microsoft Excel, Macro Programming, Automation
Skills: Microsoft Excel, Macro Programming, Automation

Excel Edits To Template (Mon, 18 Mar 2024)
I need to create a checkbook ledger. I have the basic template, but need edits
I want the graphs on a separate worksheet that pulls info from the register
Budget: $15
Skills: Microsoft Excel
Skills: Microsoft Excel

Create An (excel?) Program To Output Financial Metrics (Mon, 18 Mar 2024)
Hi, I m looking for someone to create a program, presumably in Excel but open to all suggestions, where financial transaction information can be inputted in and there will be an output of data analysis on the transactions. The financial transactions will mostly come from brokerage and investment accounts.
See attached for a model that I want to replicate. I would like something exactly like this. In the attached document, pages 2 to 4 (lines 1-70) represent the financial transactions/activity that are put in and the remaining document is all data analysis and insights on those transactions.
If this is something you can do confidently, please let me know. I m looking to get started asap.
Skills: Scripting, Financial Modeling, Financial Analysis, Data Analysis, Microsoft Excel, Data Visualization
Skills: Scripting, Financial Modeling, Financial Analysis, Data Analysis, Microsoft Excel, Data Visualization

Excel Office Script Writing (Mon, 18 Mar 2024)
Columns not named in the Column Order file should be removed.
Then the script should assemble the 4 tables into a single table.
Budget: $100
Skills: Business Process Automation, Automation, Spreadsheet Automation, Microsoft Power Automate, TypeScript, Microsoft Excel, Scripting
Skills: Business Process Automation, Automation, Spreadsheet Automation, Microsoft Power Automate, TypeScript, Microsoft Excel, Scripting

Need Custom Ribbon Expert For Excel Vba (Mon, 18 Mar 2024)
I have a particularly problematic Custom Ribbon in Excel. Whenever I change some code unrelated to the Ribbon then the input text box on the ribbon becomes disabled and cannot receive inputs.
This job requires an Expert in Custom Ribbons for Excel using VBA. Please do not apply unless you can demonstrate ability to code and understand ribbon techniques such as GetPressed and GetEnabled.
Screenshot of ribbon attached.
I will share the workbook with selected freelancers at interview.
Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming, Automation, Spreadsheet Software
Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming, Automation, Spreadsheet Software

Build Excel Tables Which Gets Inputs Form Various Places And Run Automations (Mon, 18 Mar 2024)
Need to organize and create a more rational process form data input. Organize and automatize the process and outcomes of data that will be uses to prepare offers and also inputs for an intern system.
Nees to calculate all derivated data form the process
Skills: Microsoft Excel, Automation, Data Entry, Visual Basic for Applications, Administrative Support
Skills: Microsoft Excel, Automation, Data Entry, Visual Basic for Applications, Administrative Support

Excel Expert Needed For Ft/in Formulas (Mon, 18 Mar 2024)
We are seeking an Excel expert to join our team either as a full-time employee or intern. The ideal candidate should have a deep understanding of Excel formulas, functions, and data manipulation. Responsibilities include creating complex formulas, analyzing data, and generating reports. Strong attention to detail and the ability to work with large datasets are essential. If you are passionate about Excel and enjoy working with data, we would love to hear from you.
Budget: $5
Skills: Microsoft Excel, Visual Basic for Applications, Data Entry, Spreadsheet Software, Data Analysis, Google Docs, Data Mining, Accounting
Skills: Microsoft Excel, Visual Basic for Applications, Data Entry, Spreadsheet Software, Data Analysis, Google Docs, Data Mining, Accounting

Excel Expert For Customized Sheet (Mon, 18 Mar 2024)
Seeking a proficient Excel expert well-versed in navigating numbers and formulas. The task involves automating sheets and workbooks. While not overly intricate for experienced individuals, guidance through meetings will be necessary to align with specific requirements.
Please note, that it s a concise task but requires step-by-step collaboration.
Thank you
Budget: $10
Skills: Accounting Basics, Numeric Fluency, Balance Sheet, Bookkeeping, Cash Flow Statement, Transaction Data Entry, Microsoft Excel, Google Sheets, Spreadsheet Software
Skills: Accounting Basics, Numeric Fluency, Balance Sheet, Bookkeeping, Cash Flow Statement, Transaction Data Entry, Microsoft Excel, Google Sheets, Spreadsheet Software

Vba Expert For Excel Add-in Development (Mon, 18 Mar 2024)
- Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts.
- These charts should be formatted according to our specific design requirements, including our house style and measurements.
The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations.
Please only apply if you are confident you can deliver these tasks to a high level of detail. Previous portfolio examples of similar work would be greatly appreciated.
Skills: Visual Basic for Applications
Skills: Visual Basic for Applications

Advanced Excel Timeline Scheduler (Mon, 18 Mar 2024)
- Variable work hours per day,
- Weekends,
- Overtime hours.
It s crucial that the dynamic schedule intelligently adjusts to these factors, providing an accurate timetable for my team s workflows. Column M should focus on quot;Estimated Completion Time quot;.
- Excellent knowledge and experience with Excel functions and dynamic formulas,
- Attention to detail,
- Adherence to specified conditions,
- Familiarity with corporate scheduling norms will be a plus.
Your insightful input to perfect this timeline tool would be highly appreciated.
Skills: Visual Basic for Applications, Microsoft Excel
Skills: Visual Basic for Applications, Microsoft Excel

Inventory Report (Mon, 18 Mar 2024)
We have a POS system where the inventory analysis reports are totally inexistant.
From those reports, we need to get visual information that can show very quickly slow moving stock, overstock, and stock shortages.
Ideally, I would like the reports to include a thumbnail of the product.
Budget: $100
Skills: Microsoft Excel, Microsoft Access
Skills: Microsoft Excel, Microsoft Access

Excel Vba/ Macros Writer (Mon, 18 Mar 2024)
Create VBA script code that will reference RGB color code numbers listed in columns C, D E and fill the cell color in the corresponding row in column A with that exact color referenced in the RGB code.
I have attached a file where the first worksheet is an example of what I am looking for (showing the color filled in column A). The second worksheet in the file titled quot;Color Swatches quot; is where I need the code preformed in.
Provide back the Excel sheet where the cells in column A within the worksheet quot;Color Swatches quot; are filled with the correct color referencing the RGB numbers from columns C, D and E of the same worksheet.
Please review the attached file and reply with a quote to perform this task.
Thanks,
Steven
Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming
Skills: Visual Basic for Applications, Microsoft Excel, Macro Programming

Looking For Excel Mac User To Test My File On Mac Environment (Mon, 18 Mar 2024)
Just have 5 minutes meeting to test a VBA Excel code to make sure it is functioning on Mac environment, If it is not, I want you to fix it
Budget: $30
Skills: macOS, Microsoft Excel, Visual Basic for Applications
Skills: macOS, Microsoft Excel, Visual Basic for Applications

Build Chatgpt Script To Compare And Analyze Inventory Excel Files (Mon, 18 Mar 2024)
- Dead Inventory report
- Reorder Point report
- Inventory Transfer report
I will provide the parameters for each report in the next few days, as well as an attachment of some actual data. Thanks!
Budget: $250
Skills: Microsoft Excel, Data Analysis, ChatGPT
Skills: Microsoft Excel, Data Analysis, ChatGPT

Vba Writing To Populate The Powerpoint From Data In An Excel Sheet (Mon, 18 Mar 2024)
Need help writing the VBA script to automatically populate the data in quot;Input Excel quot; file to the quot;Destination ppt quot;.
Files are attached to this job posting.
All instructions are included in the excel file.
Budget: $30
Skills: Visual Basic for Applications, Microsoft Excel
Skills: Visual Basic for Applications, Microsoft Excel

Excel Sheet With Alert Functionality (Mon, 18 Mar 2024)
- Proficiency in Excel functions and formulas
- Experience in creating automated alerts
- Strong attention to detail
- Excellent communication skills
- Problem-solving abilities
Budget: $200
Skills: Visual Basic for Applications, Microsoft Excel, Google Sheets, Spreadsheet Software
Skills: Visual Basic for Applications, Microsoft Excel, Google Sheets, Spreadsheet Software

Automate The Annotation Of Scripture References (Sun, 17 Mar 2024)
I would like computer code to automate a process for me.
It would be nice if this could start with Google App Script via a menu. On any sheet in the spreadsheet (I will have multiple sheets), the app will mark each of the scripture references as desired. The sheet will provide the URL as shown (and desired Tag name, Color, and Type).
I d prefer this be done in Google App Script and Excel 2007 VBA. If not possible, please advise.
Thanks.
Skills: Google Apps Script, Data Scraping, Google Sheets, Microsoft Excel, Automation
Skills: Google Apps Script, Data Scraping, Google Sheets, Microsoft Excel, Automation

Pdf Forms Filled Based On Excel Data (Sun, 17 Mar 2024)
I have to fill out many PDF forms and word documents as part of my job. Much of the information is repeated from form to form and document to document and I would like the data in the PDF form/word docs to be automatically generated from data that exists in a separate excel spreadsheet that I control and update.
I would like to be able to select from a drop down list in Excel quot;generate X form quot; next to each matter, and a PDF will be created with the appropriate data.
Below is a an example of one of the forms I need to fill out, and my sample excel spreadsheet with the required information.
Skills: Python, Microsoft Excel, PDF, Adobe Acrobat, Microsoft Word, Visual Basic for Applications
Skills: Python, Microsoft Excel, PDF, Adobe Acrobat, Microsoft Word, Visual Basic for Applications

Macros Expert In Excel Workbook (Sun, 17 Mar 2024)
Hi,
I have a workbook of financial statements containing trial balance sheet in it. I want to get macros added in that workbook in a way that if I change anything in the trial balance, or add any row in it, the changes get highlighted in financial statements as well. I need someone who is expert in using Macros in Microsoft Excel for this purpose. Also attach the relevant file if you have done related work before.
Please find the attached file for example.
Budget: $35
Skills: Microsoft Excel, Macro Programming, IMacros
Skills: Microsoft Excel, Macro Programming, IMacros

Microsoft Access 2016 Project (Sun, 17 Mar 2024)
I have made a database with all the fields that I need. Also some relationships
The database is attached with the project
I have also made a pdf where the basic instructions is.
The work needed should be mostly clear from that.
I do not want any dependencies like extra add-ons to access. It should be in native Microsoft Access code. I do not have the rights to install extra software or elevate from user on the computer that this Access database will run.
In my opinion it is a very small project. However I don t exactly know how it will look and feel. That will have to be changed and worked on during the project.
The basic idea is that the database will work as a work diary where I can follow up work on several different actions. It is not a project database. It is more like a todo-list with some special things.
Theres is a import function from excel that will need some VBA programming I think.
My timezone is CET.
I want it delivered as soon as possible. However I only have time to interact in the evenings, my timezone.
Best Regards!
Budget: $100
Skills: Microsoft Access Programming, Microsoft Access, Visual Basic for Applications
Skills: Microsoft Access Programming, Microsoft Access, Visual Basic for Applications

Microsoft Access Data Developer (Sun, 17 Mar 2024)
We are on the lookout for a highly skilled Microsoft Access developer with a strong background in VBA programming to join our project on a freelance basis. The successful candidate will be tasked with troubleshooting and refining VBA code that interfaces between Excel and MS Access, with the primary goal of enhancing our database management processes.
- A brief cover letter explaining your suitability for the role and your experience with similar projects.
- Examples of previous work or case studies that demonstrate your expertise in MS Access and VBA.
- Your availability and preferred working hours.
Skills: SQL, Microsoft Access, Microsoft Access Programming, Visual Basic for Applications, Microsoft SQL Server, Microsoft Excel, MySQL, Database Programming, Database Design
Skills: SQL, Microsoft Access, Microsoft Access Programming, Visual Basic for Applications, Microsoft SQL Server, Microsoft Excel, MySQL, Database Programming, Database Design