Visual Basic for Apps projects — HireLancer archive

ID / Date Listing

Mechanical Department Excel Reporting Tool

I need a single Excel workbook tailored for our mechanical department that can automatically turn raw operational data into clear summary reports. The main purp...

Finance management software

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open...

Microsoft Word VBA Automation Task

Product Description Complete an Existing Microsoft Word VBA Progress Note Manager This project involves completing an existing Microsoft Word VBA application us...

Excel Inventor Product Configurator Program

I need an Excel-driven product configurator that pushes parameters to Autodesk Inventor and automatically outputs the corresponding 3D model. The workbook will...

Microsoft Access Form Redesign

I want to give our in-house Microsoft Access application a cleaner, more intuitive interface without touching its underlying tables, queries, or core VBA logic....

Excel Data Entry Automation Tool

I keep a growing set of records in Excel and I want to stop typing everything straight into cells. Instead, I need a small automation tool—built directly inside...

Finance management software

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open...

Create Excel Mapping Tool for Financial Auditing

Excel Automation Tool – Map Trial Balance to Audit Notes Tab Project Overview: I need a simple software tool or macro/script that automates a repetitive data en...

Income & Expense Reporting Excel

My current bookkeeping is scattered and I want everything organised in one Excel file that lets me record every income and expense once and then shows me clear,...

Excel Entry & Stats Automation

I want to turn a workbook that currently relies on manual typing into a push-button process. The flow is simple in theory—data comes from people keying numbers...

Automate Daily Customer Reports

I have a growing customer-data workbook in Excel and I need it to produce clean, consistent reports every single day without manual intervention. The job is to...

Automated Excel Quotation Template -- 2

I need a single-file Excel workbook, powered by VBA macros, that produces fully formatted quotations without any manual intervention. When I open the file and s...

Add a Macro to an Existing Excel File

We have an existing Excel file with 10 macros already implemented. We need to add one more macro to the file. The task involves capturing data between two speci...

Excel VBA Data Entry Form Creation

I need an Excel VBA form designed specifically for entering Bill of Lading entries for ocean shipments. Key Requirements: - Data Entry: The primary purpose of t...

Excel Pivot Table Refresh Macro

I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected. Requirements: - Refresh the...

Excel Pivot Table Refresh Macro

I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected. Requirements: - Refresh the...

Excel Pivot Table Refresh Macro

I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected. Requirements: - Refresh the...

Excel Quiniela de Fútbol Automático

Necesito un archivo de Excel totalmente automatizado que gestione una quiniela deportiva de fútbol. Quiero introducir de forma sencilla los partidos de cada jor...

Excel Pivot Table Refresh Macro

I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected. Requirements: - Refresh the...

Excel VBA Customer Analytics

I need a multi-sheet Excel workbook that ingests raw customer data, cleans it behind the scenes with VBA, and then drives on-click dashboards that highlight key...

Excel Pivot Table Refresh Macro

I need a macro for Excel 365 to refresh a pivot table from a data input sheet. The macro should run while the workbook is protected. Requirements: - Refresh the...

Excel Macro Automation Specialist

I'm looking for an expert in Microsoft Excel to help automate tasks using macros. The main focus will be on data entry and manipulation, specifically updating o...

Custom Excel Data Entry Sheet

I need a purpose-built Excel workbook whose sole focus is smooth, accurate data entry. The sheet must comfortably accept mixed data—both numbers and text—while...

Comprehensive Excel Enhancement

I have an existing workbook that works, but it’s clunky. I’d like you to turn it into a clean, responsive tool that not only looks professional but also thinks...

Automated Excel Inventory Tracker

I need a clean, easy-to-use Excel workbook that will act as the single source of truth for my inventory. The core sheet should update stock levels automatically...

Excel Customer Data Cleaning Automation

I have several large customer-data workbooks that need to be cleaned, de-duplicated, and consistently formatted so they are ready for analysis and reporting. Th...

Advanced Excel Inventory Tracker Build

I need a robust Excel-based system that lets our engineering store stay on top of more than a thousand stock items without the file slowing to a crawl. At its h...

Urgent Advanced Excel VBA Automation

URGENTE: Especialista en Excel Avanzado y Macros (VBA) Qué certificaciones debe tener Certificación oficial Microsoft Office Specialist (MOS) Expert en Excel o...

Excel to Universal Payment file format

Every month I export roughly 150 payment-voucher rows from QuickBooks Desktop into a single Excel sheet. Instead of keying each voucher into Maybank 2E by hand,...

Automated School Fees Tracker and accouting

I need a polished Excel workbook that lets me keep on top of every fee payment the moment it happens. The file must: • Calculate balances automatically the inst...

Especialista Excel VBA Avanzado CDMX

Entrego en CDMX los planos de lo que debe construirse y necesito a alguien que domine Excel de forma avanzada para llevarlo a la realidad sin pérdida de tiempo....

Interactive Personal Finance Tracker

I need an Excel workbook that pulls my entire financial picture into one place. The front-page dashboard should feel like a small budgeting app: a clean, colour...

Excel VBA code update

I already have a partial VBA solution that pulls data from an Excel workbook and produces a quote in Word, however it needs a complete refresh. The goal is to e...

Plantillas Médicas Automatizadas Word

Necesito que transformes mis formularios clínicos en plantillas de Microsoft Word totalmente funcionales y fáciles de usar. Alcance principal 1. Crear cuatro ar...

Grade tracking database

A grade monitoring system was implemented with updated assessments for a number of students.

Fix Excel Macro Compatibility

I have an older-version .xlsm workbook whose VBA macros no longer behave as expected in the current release of Microsoft 365. The odd behaviour appears only whe...

Excel VBA Rule Engine

I would like an Excel macro (VBA) that works as a rule engine. The user will enter different values such as: * Blood pressure * eGFR * LDL * Diabetes (Yes/No) *...

Switchyard Excel Bar Bending Schedule

I need a complete Bar Bending Schedule prepared in Microsoft Excel for a sub-station switchyard. The sheet must list every bar with its diameter, shape code, an...

Balance Sheet Automation Expert

My finance team relies on a monthly balance-sheet pack, and I want it generated at the click of a button. The core file will live in Excel (Power Query/VBA are...

Desarrollo de Macros de PowerPoint VBA

Necesito un desarrollador de macros experto en VBA para PowerPoint. La macro debe generar explicaciones paso a paso desde una presentación de PowerPoint. Requis...