Excel VBA projects — HireLancer archive

ID / Date Listing

Urgent Excel Directory Mission List

I have a raw doc list of pastors and churches that needs to be turned into a polished, corporate-looking directory within the next 10 hours. Here is exactly wha...

HL-40005360

Elite Branded Excel Fitness Dashboard

I’m looking for an expert Excel designer to upgrade my existing fitness performance testing spreadsheet into a premium, client-ready system with elite branding...

HL-40005048

Excel Mixed-Data Entry & Analysis

I have a collection of records that combines free-text fields with numerical figures, and I want everything organised, validated, and summarised in Microsoft Ex...

HL-40004900

Excel Sheet Transformation

I need an existing Excel sheet with recipes, ingredients, and quantities converted into a new format. The new sheet should have rearranged column order, added n...

HL-40004734

Microsoft & Google Role Prep

I want a dedicated trainer who can guide me all the way from my current intermediate Excel skills to the level required for top-tier Microsoft and Google roles....

HL-40003315

Multi-Sheet Excel Tracker Build

Create Excel Project Tracker of Multi-sheet. It should have various features such as conditional color formattings, VBA for email generator, Dashboard to check...

HL-40002897

Speed Up Excel Macro for Data Analysis

In short, this is the task I need help with: I have an Excel workbook with a macro developed for me which I need to be able to process my data much faster. A ty...

HL-40003068

Multi-Sheet Excel Tracker Build (We will pay for Freelancer fee as well)

Create Excel Project Tracker of Multi-sheet. It should have various features such as conditional color formattings, VBA for email generator, Dashboard to check...

HL-40002667

Service-Based Billing Excel Sheet

I need an Excel sheet for service-based billing. The sheet should include: - Client name and contact - Service description and hours - Cost per service and tota...

HL-40002738

Excel Ledgers Formula Overhaul

I maintain several ledgers in a single Excel workbook, but the underlying logic has drifted: journal entries no longer flow cleanly into each ledger, the trial...

HL-40002632

Excel Data Analysis Formula

I am building a reporting dash board There are two tabs in the dashboard workbook - one for data input and one for dashboard presentation. I am having trouble d...

HL-40002392

Excel Automation for Accounting Tasks

I'm looking for an expert in Excel automation to streamline some of my accounting processes. The primary focus will be on automating data entry and reconciliati...

HL-40001526

Excel Dashboard & Data Cleanup

I have a large, messy workbook that needs to be transformed into clear, decision-ready dashboards as quickly as possible. The raw data contains duplicate record...

HL-39998787

Excel Search Bar with Hyperlink

I need an Excel search bar that returns a clickable URL link. Currently, I'm using the =Hyperlink formula, but it's not functioning as needed. Requirements: - S...

HL-39998182

Automated Stock Management Excel Tool

I need a comprehensive stock management Excel sheet that operates automatically for stock updates and dispatch tracking. Key Features: - Automatic stock level u...

HL-39997181

Excel Formulas Academic Assignment Help

I need assistance completing an academic assignment that revolves around an Excel spreadsheet. The core of the task is to set up the necessary formulas and calc...

HL-39993503

Excel Formulas Academic Assignment Help

I need assistance completing an academic assignment that revolves around an Excel spreadsheet. The core of the task is to set up the necessary formulas and calc...

HL-39996515

Excel Data Consolidation Expert Needed

As an expert in data entry and processing, I have the competence needed to speedily consolidate your text-only records from multiple Excel spreadsheets into a s...

HL-39993735

Data Entry for Sales Records

I need a skilled data entry executive to input hard copy sales records into an Excel sheet. The data is organized date-wise and requires conditional formatting...

HL-39992954

VBA Automation for University Project

I’m wrapping up a university course and my final assignment is to build a fully-functional Excel solution that handles data entry and processing through VBA. I...

HL-39992792

Interactive Excel Cost Calculator

All source data currently sits in a PDF that contains several tables, each describing a different cost component of my product. I need every one of those tables...

HL-39992691

Remote Excel Data Entry Assistant

I need a dependable remote assistant who can keep my Excel work up-to-date and error-free. The core of the role is data entry, but it goes beyond simple typing:...

HL-39992576

Excel Data Analysis Expert

I need an Excel expert to help with data analysis using pivot tables and conditional formatting. The goal is to streamline data entry. Ideal Skills and Experien...

HL-39991869

Excel Database Numbering Formula

I need help with an Excel formula to number items within 6-10 defined categories. The numbering format should be [sequential order]/[total in category]. The seq...

HL-39991951

MyBillBook-Bank Reconciliation Spreadsheet

I have twelve months of activity that must line up perfectly between my bank and MyBillBook. You will receive both the bank statement (PDF + Excel download) and...

HL-39991573

Sales Data Excel Entry

I need my current sales data copied from our online database into an existing Excel template I will provide. The structure of the workbook—tabs, column headers,...

HL-39990802

Xây Dashboard Báo Cáo

Tôi cần xây dựng một hệ thống báo cáo dữ liệu “một chạm” trên Excel để đội ngũ của chúng tôi theo dõi mọi chỉ số quan trọng mà không phụ thuộc vào bên ngoài sau...

HL-39990877

Xây Dashboard Báo Cáo -- 2

HL-39990623

Repair Excel Photo Macro

I already have an Excel workbook with a VBA routine that pulls photos from a fokder into a sheet with perforated boxes, two per page. The code has an error that...

HL-39990279

Excel VBA Support for WH Reports

I need support to fix some issues with our Excel VBA macros used for warehouse data entry and reporting. Requirements: - Debugging existing VBA macros - Fix for...

HL-39990150

Automated Excel Comparison Macro

I need an Excel-based macro template that can sit inside a single workbook and, at the click of a button, compare two sheets (or two separately loaded files) th...

HL-39989512

Excel File Updates Needed

I have a personal Excel workbook that must be updated exactly according to a separate instruction document I’ll supply. Once you receive both files, your task i...

HL-39988426

Dynamic Cashflow Dashboard Spreadsheet

I need a single Excel workbook that lets me drop in each day’s figures and immediately see how my business is travelling. The heart of the file is a clean data-...

HL-39988225

Excel Report Generation Assistance

I have data sitting in Excel that I need turned into polished, ready-to-share reports. The core objective is simple: transform the raw sheets into clear summari...

HL-39987914

Excel Text Data Cleaner Needed

I have a text-heavy Excel workbook that must be cleaned before it feeds our reporting dashboards. Your job is to open the file, remove every duplicate entry, fi...

HL-39987713

Excel Data Cleaning & Deduplication

I have an Excel file that needs a thorough spring-clean. The goal is to deliver a fresh workbook with every duplicate row removed, obvious spelling mistakes fix...

HL-39987795

Urgent Excel-Sheets Data Update in Gsheet

I have several Excel workbooks that carry my latest sales and purchase records. I now need those figures reflected in a single Google Sheet, and I need it fast....

HL-39987377

Excel Inventory Mapping Specialist

I need help with mapping and inputting inventory data for a project. The data is currently in several Excel spreadsheets, and I need it consolidated into a more...

HL-39987156

Excel Database Numbering Formula

I need help with an Excel formula to number items within 6-10 defined categories. The numbering format should be [sequential order]/[total in category]. The seq...

HL-39987167

Excel Database Numbering Formula -- 2

I need help with an Excel formula to number items within 6-10 defined categories. The numbering format should be [sequential order]/[total in category]. The seq...