Excel VBA projects — HireLancer archive

ID / Date Listing

Excel Formula Automation Upgrade

I have a tracking spreadsheet that is ready for its next step: reliable, automatic calculations. Right now the data just sits there; I need it to come alive. Sp...

HL-39835405

Excel Calculator Modification

I need an experienced Excel developer to help modify my existing Excel calculator. Requirements: - Fix errors in data input fields - Simplify existing formulas...

HL-39834600

PDF Reports Transcribed into Excel

I have a batch of reports in PDF format that combine text narratives, tables, and embedded images. I need each file converted into a fully editable Excel workbo...

HL-39833401

Reusable Excel Payment Calculator

I need a small, tidy Excel model that lets me drop in a few client-specific numbers, instantly shows the payments that fall due over time, and can then be copie...

HL-39832784

Harden Excel VBA Protection

I have a mature Excel 365 workbook whose business logic lives entirely in VBA. Before I distribute the next release I need the VBA project locked down so the so...

HL-39832444

Excel Dashboard for Warehouse KPIs

I need an Excel dashboard to monitor key performance parameters for our warehouse operations. The dashboard should provide a clear and concise overview of the f...

HL-39832163

NFL Outcome Excel Algorithm Development

Need assistance in developing an Excel or Algorithm that can produce a combinations/ permutation of the total win outcome for each NFL game chosen. Not sure I'm...

HL-39831396

GST Reconciliation Report in Excel

I need a comprehensive reconciliation between GSTR-1 and GSTR-3B prepared in Microsoft Excel for 3–5 business units and up to five individual projects. The work...

HL-39830739

Excel Mini Accounting App Build

I need a compact, Excel-based accounting application that fits seamlessly into our existing business workflow. The workbook has to capture daily transactions—sa...

HL-39830665

Excel-Based Financial Analysis Report

I need a complete financial analysis distilled into a single, well-structured Excel workbook. I will supply the raw financial statements; your job is to transfo...

HL-39830293

Excel Spreadsheet Formatting and Printing

I need an Excel spreadsheet containing customer information formatted for printing. The spreadsheet has multiple sheets and should be provided in both PDF and h...

HL-39829094

Pricing Workbook Formula Revision

I need a skilled Excel expert to add new formulas to my pricing workbook. The current setup involves complex financial calculations, but I'm facing issues with...

HL-39828445

Excel Formula Update Support

My current workbook has grown over time and the formulas that once worked smoothly are now throwing errors, slowing calculations, or producing inconsistent resu...

HL-39827693

Excel Contract Budget Monitoring Report

I manage several contracts and need a single Excel workbook that lets me see, at a glance, each contract’s total value, its payment milestones, and the remainin...

HL-39825895

Roth Conversion Worksheet in Excel / Exact tax math / Fix Logic / Create Graph / Create Heatmap

I already have a semi working workbook that models annual balances, tax liability, and cumulative after-tax wealth for my Roth conversion plan, but several piec...

HL-39825894

Excel SUMIFS Dynamic Range

I’m looking for a clean, reusable way to make the SUM range inside a SUMIFS formula shift automatically in Microsoft Excel whenever my start-date or end-date ce...

HL-39825743

Automate Weekly Sales Report Macros

I have an Excel workbook that gets updated every week and I’m tired of spending time on the same clicks and tweaks. I need a set of VBA macros that will: • Gene...

HL-39825607

Excel Sales Data Cleanup & Insights

I have several Excel workbooks filled with raw sales transactions that first need to be cleaned and organized—duplicates removed, dates standardized, product co...

HL-39825326

Dynamic Excel Gantt Schedule

I need a single-sheet Excel file that lets me manage a 30-day project in a clear Gantt-style view. The sheet has to accommodate up to 10 companies and 50 indivi...

HL-39824919

Navisworks Surface Area MTO

I already have the Navisworks Manage model on my laptop and I need the surface areas of all walls and floors extracted so I can order the right amount of materi...

HL-39824437

Revise Excel Sum Formulas

I have an Excel workbook called “School Slices Label Form.” The sheet already contains formulas, but several of the sum and total calculations are no longer ret...

HL-39823927

Prevent changing vbaProject.bin variables in an xlsm file

I need a robust way to stop anyone from renaming my macro-enabled Excel file to .zip, extracting vbaProject.bin, tweaking the CMG / DPB / GC keys (they become C...

HL-39822570

Excel Sales Trend Analysis

I have an existing Excel workbook containing raw sales records and I need a descriptive analysis that highlights how our numbers move over time. Your task is to...

HL-39822084

Programación de Macro de Validación SolidWorks

Descripción del Proyecto Somos una empresa de manufactura metálica que se especializa en proyectos a la medida (custom made). Utilizamos SolidWorks para nuest...

HL-39821616

Excel Multi-Series Line Graph

I have an existing Excel file that already contains all of the numerical columns I need to visualise. I’d like you to build a single, well-formatted line graph...

HL-39820739

Urgent- Accounting for 300 entries

Two bank accounts must be entered and fully reconciled in tally within the next 48 hours. I’ll supply clean Excel statements for each account plus the existing...

HL-39820785

Automated Excel Workbook for Data Consolidation

I have two spreadsheets that I export from my work order management system: 1. Clients sheet – contains client details. 2. Properties sheet – contains property...

HL-39820640

Contractor Payment Tracking Spreadsheet

I need an Excel file that lets me stay on top of the money flowing between my business and the contract employees who serve our clients. The sheet has to handle...

HL-39820302

Accurate Sales Data Entry & Reports -- 2

Over the next two weeks I will be delivering batches of raw sales figures that must end up in an error-free, well-structured Excel workbook. Every number needs...

HL-39820045

Accurate Sales Data Entry & Reports - 24/09/2025 11:57 EDT

Over the next two weeks I will be delivering batches of raw sales figures that must end up in an error-free, well-structured Excel workbook. Every number needs...

HL-39819581

Optimize Logistics via Excel Spreadsheet

Excel Optimization Spreadsheet for Logistics Company I need a professional Excel-based solution to optimize and manage my logistics operations. Key requirements...

HL-39819561

Accurate Sales Data Entry & Reports - 24/09/2025 08:56 EDT

Over the next two weeks I will be delivering batches of raw sales figures that must end up in an error-free, well-structured Excel workbook. Every number needs...

HL-39819381

Matrix Price List Conversion

I have roughly 4,000 SKUs sitting in a matrix-style spreadsheet (one part number spread across many columns and rows). I need everything reshaped into a clean,...

HL-39818986

Online Product Data Verification

I have a spreadsheet filled with product details gathered from several online sources, but I need a fresh set of eyes to confirm every line before the informati...

HL-39818579

Excel Image Filename Updater

I have an Excel workbook that lists hundreds of product names next to an alphanumeric code that matches the current filenames of their images (e.g., “A17BX.jpg”...

HL-39818574

Custom Advanced Excel Formulas

I need a power-user to transform several workbooks by replacing my patchwork of manual entries with robust, well-documented formulas. Array logic, dynamic range...

HL-39818635

Excel Journal with ROI and Macros

I need an Excel journal that journals all my option trades and calculates monthly ROI automatically. This journal should include: - Monthly ROI calculations - A...

HL-39818330

Excel Overhaul & Automation Needed

My current Excel workbook has grown messy and unreliable, so I need it taken back to a clean, efficient state. Every sheet must be reviewed for three key areas:...

HL-39817388

Excel-Based Flash USDT Tool

I need a developer who can rebuild my flash USDT solution so it runs entirely inside Excel. The goal is to replicate the same fast-transfer logic I already use,...

HL-39816577

Advanced Excel Formula Development -- 2

I have an Excel workbook that is growing in size and complexity, and I’m hitting the limits of my own formula skills. I need a specialist who can design and imp...