Excel VBA projects — HireLancer archive

ID / Date Listing

HL-40431977

Excel Data Cleaning & Formatting

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working dir...

HL-40431790

Excel Daily Task & Attendance Tracker

Hi, I’m looking for a simple Excel attendance and daily task tracker that works completely offline using Excel VBA/macros. This is meant to be a small and simpl...

HL-40430314

Excel Financial Dashboard Optimization for Dance Studio

Looking for someone to rework/refine an existing Excel financial and budgeting workbook for a startup competitive dance studio. This is NOT a full build from sc...

HL-40429588

Advanced Excel Formula Specialist

I need an expert in Microsoft Excel to assist with advanced formulas and calculations. The ideal candidate will have: - Proficiency in array formulas and nested...

HL-40429235

Export Business Automation

I need to automate my export business processes currently managed in Microsoft Excel. I'm looking for a solution that can streamline and automate the following...

HL-40428847

Excel UPC Barcode Macros

I have an existing workbook filled with raw, internally-maintained data. Each time I need to distribute product information I spend far too long copying, filter...

HL-40428883

Comprehensive Excel Data for stock market values

I need an excel sheet with data of tickets (100+ I will provide with name list) from 1995 to 2025 Data required is Closing prices (daily, weekly, monthly & year...

HL-40427678

Sync Excel Column Across Languages

I have one master text column in an Excel workbook that feeds about twenty-five different language versions spread through the same file. Right now, every langu...

HL-40427787

Automated Excel CRM & Projects Management & timeline

I need a set of tightly linked Excel workbooks that take sales leads from first contact through close, flag every key project milestone along the way, and—with...

HL-40427259

TallyPrime BOM Query TDL -- 2

I need a custom TDL that lets me pick several stock items—quickly, through a search-type selector—and immediately see every finished product whose Bill of Mater...

HL-40426683

Excel Homework: Sales VLOOKUP Sheets

I’m wrapping up my semester and must submit an Excel assignment built around sales data. The professor expects multiple linked worksheets that work together, wi...

HL-40425763

Bulk Phone Data Cleanup

I have an Excel file of roughly 10,000 phone records. The numbers are randomly spread across several columns and appear in mixed formats—some already include th...

HL-40425584

Excel Data Formatting Template

My dataset mixes text fields—such as product descriptions and notes—with numerical figures like prices and quantities. I need an Excel file that brings all this...

HL-40425473

Accounts Excel Data Entry

I have several job-account spreadsheets and CSV exports that need to be consolidated into one clean Microsoft Excel workbook. Each record contains a mix of text...

HL-40425545

Excel Data Formatting Template

My dataset mixes text fields—such as product descriptions and notes—with numerical figures like prices and quantities. I need an Excel file that brings all this...

HL-40424360

Excel Award Tracker Printing Fix

I need help organizing my Excel award tracker so I can print the whole sheet without any data being cut off. Currently, both rows and columns are getting cut of...

HL-40423540

Sofortige Datenextrahierung und CRM-Pflege

Ich suche einen sofort verfügbaren Freelancer, der Erfahrung mit Datenextrahierung, Datenaufbereitung, Kategorisierung und CRM-Datenpflege hat und innerhalb von...

HL-40422739

Convert Canva Sheets into Editable Excel

Canva Sheet to Editable Excel I have an Excel file that was originally put together in Canva and then exported in a non-standard Excel format. It opens, but a l...

HL-40421831

Automate Sunday Rotation Calendar

I already have a Sunday-rotation calendar in place, but it needs smarter logic. Using a checklist, I manually choose crew members' availability, so the calendar...

HL-40421765

Excel VBA Gestión Veterinaria Integral

Necesito transformar mi actual hoja de Excel en una solución VBA que agilice toda la operación de mi clínica veterinaria. El archivo debe registrar tres tipos d...

HL-40420615

Excel Inventory Analysis Sheet Setup

I have a raw list of inventory items - pens & cartridges that currently lives in several messy rows/columns. I need a single, well-structured Excel workbook tha...

HL-40419929

Excel Quote Automation Tool

I need a single Excel file that can turn my raw inputs into polished, client-ready price quotations in a click or two. The core job is straightforward: automate...

HL-40419094

Mortgage Refi Tool & Letter Revamp

I have a working Excel refinance-comparison workbook that does its math well enough, but the client-facing sheet—the sales letter I export from it—needs to look...

HL-40418518

Excel VBA Deepl Translation Macro

I have a bespoke Excel workbook that already contains several macros. I now need one additional routine that calls the Deepl API directly from VBA, so I can gen...

HL-40418357

Hoja Excel Cotizador Dinámico

Necesito que construyas una hoja de cálculo en Excel que sirva como lista de precios dinámica y cotizador automático. Mi prioridad es que los precios se actuali...

HL-40418165

Excel Workbook for Performance Analysis

I need an Excel workbook designed for data analysis, specifically for performance data. The main focus will be on analyzing operational efficiency metrics. Requ...

HL-40418209

Excel Data Analysis & Reporting -- 2

Several large, raw Excel files need to be transformed into clear, actionable information. The core of this engagement is thorough cleaning and organizing of eac...

HL-40418125

Automazione File Excel VBA

Sto cercando uno sviluppatore VBA che trasformi un nostro file Excel in uno strumento completamente automatizzato. L’obiettivo principale è l’automatizzazione d...

HL-40416551

Two Excel 2003 Cleaning Macros

I have an XLS file ready for you; the first two worksheets outline exactly what each macro must do and every subsequent sheet already holds the sample data you...

HL-40415601

Excel Billing Cost & Error Analysis

I have a set of medical billing data that needs a thorough review in Excel. The goal is two-fold: first, break down costs so I can see where money is going acro...

HL-40414851

Excel Program for Food & Beverage Inventory

I need help with my google sheets program designed for comprehensive food and beverage inventory data management. The tool is to facilitate complex data import/...

HL-40414998

Excel Formatting & VLOOKUP Automation

I have two existing Excel workbooks that hold mixed text-and-number datasets. I need them cleaned up, laid out consistently, and linked together so I can pull s...

HL-40415095

Custom Web-Based Trading Ledger

I need a custom web application to manage sales and purchases for my trading office. Essential features include: - Sales and purchase entry forms - Individual l...

HL-40413865

Excel Invoicing Automation

I'm looking for an Excel expert to enhance my existing spreadsheet for my small business. Currently, I use it to calculate labor and tax for each job, but I nee...

HL-40413375

Medical Survey Descriptive Statistics

I have a set of medical survey results exported to Excel and need a clear, well-structured statistical summary. The focus is strictly on descriptive statistics—...

HL-40412872

Excel Program for Food & Beverage Inventory

I need help with my google sheets program designed for comprehensive food and beverage inventory data management. The tool is to facilitate complex data import/...

HL-40412877

Fix Crew Management VBA Macro

My Excel-based crew-management workbook relies on a fairly large VBA macro to prepare the final roster sheets. Everything runs smoothly until the very last step...

HL-40411877

Excel to TV Sync via Smart Apps

I need a solution to sync dynamic data from an Excel sheet to my TV via smart TV apps or cloud server The data should update instantly as changes occur. Key Req...

HL-40411270

Excel Supplier Cost Dashboard

Every month I receive dozens of Excel credit-note files from different suppliers. From those sheets I have to work out two things: • the exact net landing cost...

HL-40411155

Excel Automation & Dashboard Overhaul

I’m handing over our current Excel workbook so it can become a polished, brand-aligned tool the whole team can rely on. My first priority is tightening up every...