Excel Macros projects — HireLancer archive

ID / Date Listing

Excel Data Analysis Enhancement

I need help refining my Excel spreadsheet for data analysis. Currently, I use it primarily for data analysis, and I need assistance specifically with pivot tabl...

HL-39811082

Interactive Sales Dashboard in Excel

I need a single-file Excel dashboard that lets me track sales and revenue at a glance. The focus is on three core metrics—monthly sales growth, product performa...

HL-39810944

FlightRadar24 / FlightAware API Integration to Flight Schedule Board .xlsm

I have a macro-enabled workbook, Flight Schedule Board.xlsm, that currently relies on manual entry. I want it to pull live flight information directly through a...

HL-39810149

Legacy Excel VBA Code Audit

I have a large, business-critical Excel workbook that relies on old-school VBA macros. The original author is long gone, so before I touch anything I need a cle...

HL-39809564

Automate Excel Lookup Formulas

The task is to populate an Excel workbook with robust VLOOKUP or HLOOKUP formulas that draw live data from an online database I provide. All raw figures sit in...

HL-39809444

Excel Purchase Data Analysis

I have a collection of purchase-related records stored in Excel and need a clear, actionable analysis of that data. The raw sheets are already compiled; what I’...

HL-39809361

Develop an Excel Plug-in to create Member Verification / Paid Account Access to Workbook

I'm creating Excel files that I want to distribute but have really good control over access. Is that possible beyond just simple Excel password protection. Exce...

HL-39809171

Excel Macros & Hyperlink Fixes

I have two Excel workbooks that need quick, precise VBA work. In the first workbook you’ll revisit the hyperlink-editing macro you built for me earlier. It curr...

HL-39808230

Corporate One-Page Excel Template

We are in need of a one page excel template. Please see the attached one page sample. We already have a excel workbook with data, so we need this one-page excel...

HL-39807675

Excel Multi-User Inventory System

I need a robust Excel-based solution that lets several team members work simultaneously with our inventory data. The core of the workbook must handle complete o...

HL-39807453

Invoice Receipt Excel Entry

I have a stack of physical invoices and receipts that need to be converted into a clean, well-structured Excel spreadsheet. I will supply high-resolution scans...

HL-39806402

Excel Expert Needed for Various Tasks -- 2

I'm seeking a skilled Excel expert to assist with a variety of tasks. While I haven't specified the exact nature of the work, it may involve data entry, organiz...

HL-39806291

Excel Financial Report Automation

I need a streamlined Excel solution that turns raw accounting data into polished financial reports—specifically income statements and balance sheets—at the clic...

HL-39805657

Educational Outreach & Record Reformatting

I have two parallel tasks that need to move forward together. First, a series of requests have already been submitted to various educational institutions. I nee...

HL-39805257

Excel expert who can create Live Planner, Gantt charts, tracking systems

I need an excel expert who can create a live planner, Gantt charts, tracking reports, project management, etc in excel. Please apply if you already have experie...

HL-39804062

Unbreakable VBA Code Protection Required

I'm looking to protect my VBA codes with a method or software that makes them completely unbreakable against piracy. I want the code to remain in the same VBA t...

HL-39803420

Excel Automation & Data Management

I’m looking to turn my day-to-day Excel workload into a streamlined, largely automated system. The priority is to remove the manual effort from complex calculat...

HL-39803277

Convert Word Document Into Interactive Excel Tool with Auto-Calculations

Job Title Convert Word Document Into Interactive Excel Tool with Auto-Calculations Project Description I have a Word document (Preventative Maintenance Agreemen...

HL-39802240

Configurare - excel / google sheet - integrare date conexe

Am nevoie de o persoana care sa faca integrarea mai multor fisiere excel. E vorba de functii vlookup / xlookup - adica excel la nivel superior. Am anumite rapoa...

HL-39800392

Excel VBA and MySQL Table Creation

I am currently looking for a fully seasoned VBA and MySQL coder to build VBA codes and MySQL codes to generate a new table in MySQL and then the ability to be e...

HL-39800401

Excel Sales Insights Repor

I have a raw sales data set that needs to be transformed into a clear, executive-ready report produced entirely in Excel. The end product should highlight custo...

HL-39800231

Convert Text Docs to Excel

I have several text-based documents that need to be reproduced faithfully in Microsoft Excel. Every word, line break, header, and footer must appear just as it...

HL-39800247

Excel Travel Ticket Template

I have a set of travel ticket samples that need to be rebuilt from scratch in Microsoft Excel. The goal is to mirror their current layout and styling so that I...

HL-39799978

Excel Formula Wiz who knows Performance Optimization and good English for

I'm creating a large-scale Excel model and need to avoid nested IFs, volatile functions, and array formulas to analyze commercial real-estate cash flows. Delive...

HL-39799680

Excel Automation Macros

I need Excel macros to automate repetitive tasks, primarily calculations. The main task involves creating rankings in order. Requirements: - Expertise in Excel...

HL-39799501

Shopify Product File Preparation

I need existing Excel product files adapted for our Shopify pages. Requirements: - Modify Excel files for product uploads - Tasks include: - Formatting - Data e...

HL-39797846

Automated Excel Sheet Backup

I need a small, reliable routine that will back up specific sheets from my main workbook at the click of a button (or another simple trigger) without breaking a...

HL-39797497

Advanced Business Budget Template

I need an advanced business budget template created in Microsoft Excel. Essential functionalities include: - Income and expense tracking - Cash flow forecasting...

HL-39797247

Enhanced Excel Form Design and Functionality

Excel Data Entry Form Instructions Objective Create a visually appealing Excel-based data entry form for daily entries, designed to look like a professional for...

HL-39796688

Batch Mix Combination Optimizer

I want a web-based application that takes my existing product list and, much like a flight-search engine, explores every feasible permutation and combination to...

HL-39796750

Color-Coded Roster Excel Sheet

I want a single, easy-to-use Excel workbook that lets my team build our roster simply by typing the numbers 1-7. As soon as a number is entered, it must automat...

HL-39796549

Organize Raw Data into Excel

I have a collection of unorganized raw data sitting in assorted text files and PDFs that I need transformed into a single, clean Excel workbook. The task is str...

HL-39796598

Manual Online Product Entry

A catalogue of products hosted on several web-stores has to be copied, field-by-field, into my master spreadsheet. This is a purely manual task: no web-scraping...

HL-39794787

Excel VBA Automation Expert Needed

I'm looking for an experienced Excel VBA programmer to help automate data processing tasks, specifically data transformation. I would like to Questions and Answ...

HL-39793804

Excel Weekly Results Consolidation

I have two worksheets—“Week 1” and “Week 2”—that list participant names with their respective results. The name lists don’t perfectly overlap, so I need a clean...

HL-39792959

Excel Football Stats Dashboard

I have several raw Excel sheets filled with football-related numbers and I need them turned into a clean, living dashboard today. All the data revolves around g...

HL-39792988

work sheet

I’m currently juggling several Microsoft Excel files and need a reliable Excel-savvy professional to handle the worksheet work for me. Everything will be done i...

HL-39792868

Advanced Excel VBA Automation for Pricing List

Job Title: Excel Expert Needed for Advanced Price List with VBA Automation Project Overview: We are looking for an experienced Excel VBA developer to implement...

HL-39792623

Excel Flight Data API Integration

I maintain a live flight schedule in Excel and want to remove every bit of manual updating. Your job is to connect that workbook to the AviationStack API or bet...

HL-39792690

Sales & Expense Dashboard Templates

I need update/finetune my excel spreadsheet to streamline solution that lets me capture and analyse sales, expenses and salaries across several locations and ti...