Excel VBA projects — HireLancer archive

ID / Date Listing

Bookkeeping & Financial Reports

I’m looking for a detail-oriented bookkeeper who can keep my day-to-day transactions up to date and compile clear, timely financial summaries. The immediate foc...

HL-39876512

Excel Numerical Data Cleaning Specialist

I have several Excel workbooks packed with numerical data that now need a thorough clean-up before they can be trusted for reporting. The sheets contain duplica...

HL-39875369

Standardize Shift Schedules

I need assistance in reformatting and standardizing the shift schedules for 21 cafe branches into a structured and consistent format. The final deliverable shou...

HL-39875377

Excel Workbook with VBA Search

I need an Excel workbook tailored to find records from data sheets based on specific search criteria with a VBA-scripted, single-click solution. The data in my...

HL-39874778

Organize Excel Data with Dropdowns Macro’s

I need assistance in organizing text data within an Excel sheet. The data is already present in the sheet, and I require sorting and structuring it effectively....

HL-39874117

Excel Inventory and Dashboard Creation

I am looking for someone to create a comprehensive inventory management Excel sheet tailored for managing office supplies. The sheet should include functionalit...

HL-39873530

Spreadsheet Formulas and Dashboard Enhancement

I need an expert to refine an existing spreadsheet by adding necessary formulas and a functional dashboard. The formulas should enable calculations like countin...

HL-39872986

Excel Sales Dashboard Creation

I will analyze your product sales data, provided in an Excel format, and create a clean, interactive Power BI dashboard. This dashboard will highlight key trend...

HL-39872571

Modify VBA in Excel Macro to concat

I need modifications made to the VBA code in an existing Excel macro. The current output generates multiple lines of formatted data. The task is to adjust the m...

HL-39871843

Excel Tool for Consultant Management

I need a customized Excel tool that enables me to efficiently manage consultants in a structured manner. The tool should allow me to add and remove consultants...

HL-39871331

Recover Overwritten Excel File

I accidentally overwrote an Excel file on Microsoft Excel for Windows and need assistance recovering the original version. Since the file has been saved again a...

HL-39871119

Excel Inventory and Dashboard Creation

I am looking for someone to create a comprehensive inventory management Excel sheet tailored for managing office supplies. The sheet should include functionalit...

HL-39870753

Generate Filterable Soccer League Table

I need help creating a fully functional soccer league table generator using historical soccer results stored in a MySQL database. The table should include filte...

HL-39870142

Excel-Based GST Tracker Development

I am looking for an experienced Excel/VBA expert to create a smart and automated GST Advance Management Tracker. The goal is to maintain all data in a single Ex...

HL-39866681

Excel Column Alignment Task

I need help aligning columns on 6-10 Excel sheets. All sheets are structured similarly and contain mixed data (text and numbers). Ideal skills and experience: -...

HL-39869686

Format Laporan dan Rapi Data Excel

Saya membutuhkan bantuan untuk membuat tabel atau format laporan di Excel dengan hasil yang jelas dan profesional. Dalam prosesnya, saya juga memerlukan penanga...

HL-39869533

MS Word and Excel Specialist

I am looking for an expert in Microsoft Word and Excel to assist with creating and editing reports or proposals, as well as handling advanced formulas and data...

HL-39869106

Excel Data Entry Specialist -- 5

I am seeking an Excel specialist to assist with data entry tasks for launching a new enterprise. The job will require quick and accurate data input into spreads...

HL-39868416

Automated Staff Roster & Payroll System in VBA

VBA Development Requirements for Staff Roster and Payment Sheet System 1. Project Overview This project aims to develop a robust and automated Excel-based syste...

HL-39868472

Automate PDF to Excel Conversion

I am looking to create an application for my business that can automate the conversion of PDF files into Excel. This tool is specifically aimed at handling file...

HL-39867555

Automate MYOB Duplicate Invoice Detection

I rely on MYOB AccountRight Plus and export each entity's (14 entities) Purchases [Supplier Statement] report to Excel, and using conditional formating highligh...

HL-39867600

Excel XLOOKUP Data Consolidation

I have 2-3 Excel worksheets that hold related information, and I need them merged into one clean, consolidated table. A straightforward XLOOKUP-based solution i...

HL-39867121

Microsoft Office Data Processing

I need support across several Microsoft Office tasks that have been piling up on my desk. Most of the work happens in Word and Excel and covers three areas: ent...

HL-39866947

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-39866382

Excel Data Sheets Entry Assistance

I have a set of existing Excel workbooks and need all of their contents entered into a new, clean worksheet. This is a straightforward data-entry job—no formula...

HL-39866396

Microsoft Office Data Processing

I need support across several Microsoft Office tasks that have been piling up on my desk. Most of the work happens in Word and Excel and covers three areas: ent...

HL-39866125

Excel Student Handwriting Dashboard

I need a straightforward Excel solution that lets me record handwriting scores from several subject-specific sheets and see—at a glance—how each student’s handw...

HL-39866032

Excel One-Click Cell Update

I already have the core formula written, but right now it only updates a single cell at a time. What I need is a simple, elegant way to make that same calculati...

HL-39865744

Excel Macro for Data Tasks

I need a lightweight VBA macro that runs smoothly in Excel 2013. The goal is to speed up my daily spreadsheet work without changing the file layout I already us...

HL-39865542

Custom Excel Price List Design

I need a clean, well-structured Excel workbook that will serve as the official price list for my limousine services. The sheet must look polished enough to shar...

HL-39864991

Excel Wage & Rent Automation Dashboard

I have a basic Excel file that tracks wages and rent payments, but it still relies on manual updates. I’m looking for someone to turn it into a streamlined work...

HL-39864654

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-39864679

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-39863826

Excel Macro: Organize Two Sheets

I work with two separate raw Excel worksheets every cycle and need a repeatable way to pull only the fields I care about, place them side-by-side, and have the...

HL-39863747

Excel Add-in for AccountsIQ

I need an Excel add-in designed to import expenses data into AccountsIQ. The add-in should perform basic data validation before importing. Requirements: - Impor...

HL-39863670

Excel Add-in for AccountsIQ

I need an Excel add-in designed to import expenses data into AccountsIQ. The add-in should perform basic data validation before importing. Requirements: - Impor...

HL-39862338

Automate Multi-Tab Expense Workbook

I’m working with a multi-tab expense workbook and I need a fresh set of expert eyes to tighten things up. Most of the work is separating exps into two The formu...

HL-39862107

Customer Data Entry & Cleanup

I have a backlog of customer information that needs to be organised in Excel. Your job is straightforward but accuracy-critical: • Enter new customer records fr...

HL-39861888

Word & Excel VA Support

I have a steady flow of spreadsheets that need cleaning, organising, and presenting, together with documents that require quick touch-ups in Word. Most of the e...

HL-39861719

Excel VBA WhatsApp Sender

I want a single-click Excel workbook that lets me load a list of phone numbers, type a unique message beside each one, attach one common document, and then watc...