Excel VBA projects — HireLancer archive

ID / Date Listing

Excel Data Cleansing Project

I have several raw data files that need to be transferred into a master Excel workbook and cleaned to match a template I will supply. The job involves three thi...

HL-39861137

Excel Macro Dashboard Upgrade

I have an existing Excel model with several macros that needs a quick Phase 1 refresh over the next three-to-four days (budget capped at US $100). Scope of work...

HL-39861076

Power BI Dashboard for Hospital Management System (Surgeons, Surgeries, Staff & OT Utilization)

I need a Power BI dashboard that provides a comprehensive overview of hospital operations, focusing on the following key areas: Surgeons and Surgeries: List of...

HL-39860735

Convert Vendor CSVs to Shopify

I run a Shopify-based furniture store and every manufacturer I carry sends a different price list in CSV format together with product images. Each file can run...

HL-39860731

Convert Vendor CSVs to Shopify

I run a Shopify-based furniture store and every manufacturer I carry sends a different price list in CSV format together with product images. Each file can run...

HL-39860301

User Statistics Dashboard Creation

I need a clean, reliable dashboard that focuses exclusively on user-related KPIs, with “active users” front and center. The data source is already available; wh...

HL-39859653

Excel Attendance Macro Development

I need an Excel macro to track my team's attendance using our point system. The macro should automatically calculate total points based on the following criteri...

HL-39859458

Google Sheets Sprint Timeline

I already have a Google Sheets file where one tab lists all project milestones. What I’m missing is a second tab that automatically turns those milestones into...

HL-39859345

Actualizar y automatizar Excel financiero

Trabajo a diario con un archivo de Excel que concentra mis finanzas personales y empresariales. Quiero darle un salto de calidad: • Modernizar la lógica interna...

HL-39859159

Financial Excel Automation & Analysis

I have a series of income statements and balance sheets that need to be turned into a clear-looking, fully automated workbook. Your main goals will be to clean...

HL-39858919

Daily Task Tracker Spreadsheet

I need an Excel spreadsheet to track daily tasks. Requirements: - Track task description, completion status, and assigned person. Ideal Skills: - Proficiency in...

HL-39858948

إنشاء تقارير مفصلة بإكسيل

لدي مجموعة بيانات تخص المستخدمين وأحتاج تحويلها إلى تقارير تفصيلية واضحة تُنفَّذ بالكامل عبر Excel. سأوفر لك ملف البيانات بصيغته الأصلية (غالبًا CSV أو XLSX) وأ...

HL-39858153

Excel Tracker for Grocery Finances

I need a single, well-structured Excel workbook that lets me keep my grocery shop’s day-to-day numbers in one place. The file should contain three linked sheets...

HL-39858253

VLOOKUP Formula Help Needed

I’m working in Microsoft 365 Excel and have a single, well-structured product table. I simply need an extra pair of expert hands for about an hour so the formul...

HL-39857786

Advanced Excel VBA Automation

The project centres on transforming a set of production spreadsheets into a streamlined, button-driven solution built entirely in native Excel and VBA. Every ca...

HL-39857524

AI-Powered Excel Automation -- 2

I need an intelligent workflow built directly in Excel that can: • pull numerical inputs into the sheet automatically, • run statistical analysis on those figur...

HL-39857001

Convert Vendor CSVs to Shopify

I run a Shopify-based furniture store and every manufacturer I carry sends a different price list in CSV format together with product images. Each file can run...

HL-39857039

Excel Expertise for MGMT 2400

I need assistance with Goal Seek and Pivot Tables in Excel for my MGMT 2400-x02 course. Ideal Skills and Experience: - Proficiency in Excel, specifically in Goa...

HL-39856877

Repair Excel Auto-Populate Formulas

The costing workbook I rely on has a front page where I enter item details and figures, and a second tab—“Material List”—that used to fill itself automatically....

HL-39856654

Google Sheet to Excel Conversion

I need a debt tracker converted from Google Sheets to Excel 365. The existing formulas break when saved as Excel. Requirements: - Ensure all formulas work exact...

HL-39855495

CFSI Investigation Log Automation and Dashboard And Reports

Project title CFSI Investigation Log Automation and Dashboard Objective Build Excel workbook that runs the entire CFSI pipeline. Data entry, tracking, reporting...

HL-39854166

Daily Production Excel Tracker

I need a clean, easy-to-use Excel workbook that lets me record the quantity produced each day and automatically totals it for the entire day—no shift breakdowns...

HL-39853892

Inventory Input Form Automation

I update our inventory workbook every day and would like to replace the purely manual typing with a clean, user-friendly input form inside Excel. The data itsel...

HL-39853679

Excel Project Tracker & Dashboard Creation

### Project Objective Develop a comprehensive project tracking and monitoring system in Microsoft Excel, including an interactive dashboard for real-time report...

HL-39853616

Recurring Financial Performance Reporting

I need an experienced analyst to take charge of our month-end, quarter-end and year-end financial performance packs. Every cycle you will pull data from the acc...

HL-39853042

Automated Excel CFSI Dashboard

I need a single-file Excel solution that lets me monitor CFSI investigation cases end-to-end without ever touching raw formulas again. The workbook must accept...

HL-39852748

Advanced Excel Finance Dashboard - 05/10/2025 14:28 EDT

I have weekly finance data that needs to be turned into a clear, interactive Excel dashboard focusing on two core metrics—revenue vs expenses and overall profit...

HL-39852199

Excel CPQ Tool Development

I need an Excel-based Configure, Price, and Quote (CPQ) tool tailored for my EPC project business. The tool should automate pricing calculations and allow for c...

HL-39851948

Recurring Financial Performance Reporting

I need an experienced analyst to take charge of our month-end, quarter-end and year-end financial performance packs. Every cycle you will pull data from the acc...

HL-39851398

Private Excel Data Formatting for Armaghan

As discussed, I need your help tidying up a set of financial spreadsheets. The raw sheets contain bank exports, revenue logs, and a few cost trackers that all n...

HL-39851266

Zerodha API Data to Excel Charts & Scans

I need an Excel-based workspace that talks directly to Zerodha’s Kite Connect API, pulls both FnO and cash market streams in real time or on-demand, and lays ev...

HL-39851343

création et mise en forme de documents Word et excel

J’ai besoin qu’une feuille Excel soit entièrement mise en forme et automatisée. Mon jeu de données arrive brut ; je souhaite qu’il soit nettoyé, réorganisé et p...

HL-39851371

Excel VBA Report Automation

I have several existing workbooks that still rely on time-consuming manual steps every week. I’d like you to replace those steps with clean, well-structured VBA...

HL-39850587

Private Excel Data Formatting for Armaghan

As discussed, I need your help tidying up a set of financial spreadsheets. The raw sheets contain bank exports, revenue logs, and a few cost trackers that all n...

HL-39850181

Revamp Purchase Order Spreadsheet

The workbook I’m using does the minimum, yet it feels clunky. I need a cleaner Excel structure that still keeps a separate record of every vendor’s purchase ord...

HL-39849699

Excel Tracker Upgrade for MEP Projects

Hi, I’m a Building Services Engineer working in London office fit-out projects (MEP consultancy / Cat A & Cat B fit-outs). I already have a base Excel workbook,...

HL-39849521

Recurring Financial Performance Reporting

I need an experienced analyst to take charge of our month-end, quarter-end and year-end financial performance packs. Every cycle you will pull data from the acc...

HL-39847640

Automated Incentive Excel Optimization - 03/10/2025 22:49 EDT

Need an Excel workbook that should calculate monthly commissions, bonuses and incentives for four roles—Sales representatives, Production, Drivers and Marketing...

HL-39849315

Excel Customer Data Entry & Cleanup

I have several batches of customer information that must be organised in a single Excel workbook. Each record needs to follow the exact column order: Name, Emai...

HL-39848806

Database built by chatgpt

I have a tight, 20-hour window to compile a clean, accurate database for 238 national and regional tourism boards around the globe. You’re welcome to lean on Ch...