Excel VBA projects — HireLancer archive

ID / Date Listing

Excel Formula Correction Specialist

I need an Excel expert to help correct formula errors in my spreadsheets. Key Tasks: - Fix circular references and other formula errors - Resolve incorrect resu...

HL-39964037

Medical Records Excel Statistics

I will share an Excel file that holds individual patient records, and I need a concise descriptive-statistics report built directly inside the workbook. The foc...

HL-39964080

Automated Excel Gradebook & Dashboards

I need a single Microsoft Excel workbook that I can drop into any new semester, enter the basic course details, paste in a fresh student roster, and watch the e...

HL-39963844

Automated Excel Sales Dashboard

I need a self-refreshing sales dashboard built in Excel that can cope with the large files my system produces—about 8 million rows every year covering salespers...

HL-39963872

VBA Macro: Auto CSV Upload

I need a VBA macro that pulls inventory data from my Excel workbook, generates a clean CSV, and then saves that file in both my OneDrive and the connected Share...

HL-39963296

Automate Excel Order Summary

I keep a master workbook of pre-orders and need a simple way to see, at a glance, how many units of each item and which flavours have been booked. Here is what...

HL-39962302

Excel Macro for Team Reports

I need a lightweight Excel macro that turns raw worksheet data into a polished team report focused solely on performance metrics (which I can share how I want i...

HL-39962334

Excel Customer Data Report

I have a set of customer data that needs to be turned into clear, insightful reports and visualizations. The task itself is simply “excel”—I’m looking for someo...

HL-39961899

Excel Data Analysis Assistance

I have an existing Excel workbook that I need analyzed so I can quickly extract meaningful insights from the raw numbers. Everything is already in .xlsx format,...

HL-39961559

Excel Product Dropdown with Thumbnails

I need a single Excel workbook that lets users pick a product from a drop-down list and instantly see its name, price, description, and a thumbnail image. All p...

HL-39961346

Employee Leave Tracker Excel Template

I need a clean, easy-to-update Excel sheet that lets me record day-to-day employee attendance and, most importantly, capture every instance of unpaid leave. The...

HL-39961187

Spreadsheet Customer Data Update

I have an existing Excel workbook that holds our customer records. A fresh CSV file containing the latest information is ready, and I need the data merged into...

HL-39961266

Spreadsheet Customer Data Update

I have an existing Excel workbook that holds our customer records. A fresh CSV file containing the latest information is ready, and I need the data merged into...

HL-39961035

Captive vs Grid Power Analysis

I need a thorough comparison of running our refinery on an in-house (captive) power plant versus relying on the national grid. The goal is to decide which optio...

HL-39960548

Excel VLOOKUP Test Price Comparison

I have two price lists—each from a different company—that cover identical medical test names. I need one clean Excel workbook that instantly shows which company...

HL-39960445

Dealership Finance Tracker

Build a dedicated SPREADSHEET OR POWER BI TOOL that gives me a clear, branch-wise picture of daily performance across our six two-wheeler dealerships and the sp...

HL-39959880

B2B Healthcare Lead Generation VA

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain a...

HL-39959562

Dynamic Excel Project Dashboard

I have four active projects today and expect that number to grow steadily to roughly eighteen over the next three-to-five years. To keep everything on track I w...

HL-39959633

Automated Excel Worksheet Organizer VBA Macro

I have a worksheet that I update frequently and I’d like a single, easy-to-run VBA macro that tidies everything up for me in one click. Here’s what the macro mu...

HL-39959236

Excel Macro Automation

I need an Excel macro to automate email follow ups generation tasks. Ideal skills and experience: - Proficiency in Excel VBA - Experience with automating report...

HL-39958219

Custom Excel Schedule Workbook

I’m looking for an Excel specialist who can build a user-friendly scheduling workbook in Excel for Microsoft 365. The goal is to plan a 6-day workweek for rough...

HL-39958279

Excel Footer Page-Count Macro -- 2

I need a small yet reliable VBA routine that will insert and keep updated the footer “Page X of Y” across every sheet in my Excel 365 workbook. The macro must c...

HL-39957979

Auto-Highlight On-Hold Orders

I maintain an Excel workbook with two worksheets: • “All Orders” – holds every order we process. • “On Hold Order Numbers” – a simple list of order numbers that...

HL-39957217

Optimize Nested IF Formulas

Hello, I have read your project details carefully and fully understand what you need. You want to fix and simplify complex nested IF formulas in Excel so that t...

HL-39957220

Optimize Nested IF Formulas - 05/11/2025 23:27 EST

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain a...

HL-39957091

Excel Progress Tracker Automation

I need a single, rock-solid Excel solution that pulls live data from roughly 45–50 existing worksheets and rolls it into three summary blocks on each sheet: TAS...

HL-39956768

Excel Row Reconciliation Task

I have two Excel workbooks that must be compared row-by-row. The rule is simple: for example pick the value in Column E along with Amount from column G of the f...

HL-39956596

B2B Healthcare Lead Generation VA -- 2

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain a...

HL-39956036

Simple excel ledger- need it to be reviewed and corrected

I’m looking for a sharp eye to go through one straightforward Excel workbook that tracks all Accounts Payable entries from 2023 up to the present. The goal is s...

HL-39956021

Excel Sales Tracking Matrix Development

I'm looking for a robust Excel matrix to track daily sales for my Dripbar company. The matrix should allow me to compare total sales amounts on a weekly, monthl...

HL-39955885

Simple excel ledger- need it to be reviewed and corrected

I’m looking for a sharp eye to go through one straightforward Excel workbook that tracks all Accounts Payable entries from 2023 up to the present. The goal is s...

HL-39955215

Excel formula writing

We have 2 reports one from the payment provider and one from the in house system we need to match and find differences. The only unique identifier is the amount...

HL-39954880

Excel formula writing -- 2

We have 2 reports one from the payment provider and one from the in house system we need to match and find differences. The only unique identifier is the amount...

HL-39953313

Optimize Nested IF Formulas - 05/11/2025 23:27 EST

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain a...

HL-39953277

Optimize Nested IF Formulas

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain a...

HL-39953139

Automated Property Valuation Spreadsheet

I’m looking for a streamlined upgrade of my existing Excel file so I can produce land-and-building valuation reports quickly, accurately, and in a banker-ready...

HL-39952990

Excel CI & Hypothesis Testing

I have an Excel workbook containing survey responses on iPhone satisfaction broken down by several demographic segments. I need the statistical work polished an...

HL-39952907

Excel Bookkeeping Template Suite

I need an Excel workbook that lets me keep every core bookkeeping task in one place. The file should allow me to record income and expenses, reconcile each line...

HL-39952721

Dashboard Excel de Finanzas GBL -- 2

Perfil del Archivo: Herramienta Integral de Control Financiero – GBL Nombre del archivo: GBL – Financial Control & Analytics Dashboard Propósito General: Desarr...

HL-39952691

Excel Zip-to-City Formula

I’m working with sales data and need to translate each customer zip code into its corresponding city. The sheet already has separate columns for zip and city; t...