Visual Basic for Apps projects — HireLancer archive

ID / Date Listing

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

Automated QuickBooks to Quicken Conversion Tool

I need to move everything from QuickBooks 2024 Desktop for Mac into Quicken Business & Personal for Mac in a single, clean sweep. The conversion has to capture...

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

Automate Photo Integration in Word

I need to automate the process of integrating photos from Microsoft Forms submissions into a Word document. The photos should be placed floating in specific loc...

HL-39797173

Access Sorting and Deleting Certain Rows

I already have an Access (.accdb) file that pulls in a CSV flawlessly; what’s missing is a bit of post-import housekeeping. First, every time the import complet...

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

VBA Macro for Report Automationvba

I'm seeking a skilled VBA developer to create a macro that automates report generation. The reports need to be compiled into PowerPoint format using the Vermili...

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

Word VBA 64-Bit Conversion

I have an existing Word document whose VBA macros were written years ago for 32-bit Word on Windows. The code pulls in local photographs that sit in C:\Photos....

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

Excel-Kite Real-Time Trading

I want a single Excel workbook that talks directly to the Zerodha Kite Connect API. From inside the sheet I should be able to log in with my own API key, watch...

HL-39790932

Excel Macro: Auto-Sort Sheet

I need a Excel workbook that automatically keeps every new row alphabetically ordered the moment data is entered. I’ll send you a sample file so you can mirror...

HL-39789349

Office Task Automation Expert Needed

I'm seeking an expert to help automate my office tasks using Microsoft Office. I'm currently managing email and data entry manually, and I'm looking for advance...

HL-39787988

Word Report Formatting & Templates

I have a draft report that needs to look publication-ready and I also want a reusable framework for future documents. I’m looking for someone who can combine pr...

HL-39787104

Avaliar fotos de comidas

Analisar imagens de boa qualidade tiradas de comida feita na hora. Qualquer categoria desde bolacha a uma boa refeição .

HL-39786801

Excel Payroll & Audit Automation

I want to consolidate three recurring finance tasks—salary preparation, monthly revenue audits, and stock control—into one smart Excel-based workflow. All data...

HL-39786790

Excel Tool: API 650 Settlement

I need a self-contained Excel workbook that evaluates above-ground storage-tank settlement strictly in line with API 650 / API 653 requirements. The focus is se...

HL-39786338

Barcode-Driven Excel Search Setup

I’m working in Excel 365 and keep a large inventory table on a single worksheet. Each product already has a 12-character alphanumeric serial number stored in on...

HL-39784057

Automate Excel Customer Data Reports

I have a growing set of customer data that I need transformed into a clean, reliable Excel workbook that can produce professional-looking reports at the click o...

HL-39783262

Duplicate Finder in Excel

I want a reusable, push-button way to scan any Excel file and surface duplicates without manually filtering or scrolling. The workbook size can vary from a sing...

HL-39776810

Password removed from Excel Workbook

I have a single workbook built in Excel 2019 that is password-protected at the workbook/worksheet level, but not fully encrypted. Unfortunately, I no longer rem...

HL-39775945

Student Intervention Data Spreadsheet

I need an Excel workbook that lets me collect and organise everything related to student interventions in one place. The file should give me easy-to-use entry s...

HL-39762497

Excel VBA Automation Script

I need a VBA script for Excel to automate repetitive tasks. The primary focus is on automating data entry and Short Interval Control processes. The script shoul...

HL-39760523

Excel VBA Report Automation

I need an experienced VBA developer to automate the comparison of multiple Excel reports. Requirements: - Open 7 or more Excel reports simultaneously. - Cross-c...

HL-39759064

Automate MRP System with VBA

I'm seeking an experienced VBA programmer with Microsoft Access (SQL) skills to enhance our existing MRP Plus software. Ideally, you should have a background in...

HL-39757377

“Data Entry & Cleaning with Excel, Formulas

I need a skilled freelancer to create automated reports and dashboards using Excel (especially Power Query, and also with formulas, VBA, Macros) and Power BI. K...

HL-39756594

Excel Data Cleaning Automation

I have several raw spreadsheets that need to be transformed into a clean, consistently formatted dataset and then wired for hands-free data entry. The first pha...

HL-39756121

“Data Entry & Cleaning with Excel, Formulas & AI Tools”

I need a skilled freelancer to create automated reports and dashboards using Excel (especially Power Query, and also with formulas, VBA, Macros) and Power BI. K...

HL-39754290

Visual Basics and Advanced Excel Tutor in Bangalore

I need an expert tutor in Bangalore to teach Visual Basics at an expert level. I also want to focus on advanced Excel, particularly advanced formulas and functi...

HL-39749696

Excel Report Automation Specialist

I need my recurring reports to build themselves. Right now all of the source data already lives in several Excel spreadsheets; what’s missing is a robust routin...

HL-39749429

Excel VBA Automation Expert Needed

I need a local VBA programmer to automate various tasks in Excel. The project involves automating data entry and import, report generation, and chart creation a...

HL-39746694

Excel VBA Pivot Report Automation

I want a single-click VBA routine that takes raw data already sitting in one worksheet, refreshes it, and then builds a cleanly formatted PivotTable report on a...

HL-39746351

SAP MM & Excel Processing

I have raw SAP MM exports covering inventory management, procurement and invoice verification, delivered as standard SAP download files (.xls or .csv). These fi...

HL-39743866

Excel Automation Specialist Needed

I'm seeking an Excel expert with strong VBA skills to help automate tasks. I need both modification of existing scripts and creation of new ones. Ideal skills a...

HL-39736118

SMM Supplier Margin Monitoring Excel Tool

Development of an Excel workbook (.xlsm) – SupplierMarginMonitor_v3.0 Objective: Create a comprehensive Excel tool to capture, evaluate and transparently presen...

HL-39732157

Excel VB Code Debugging

I need help correcting VB code for an Excel file. The code is supposed to perform data processing but encounters runtime errors. It has never worked since it wa...

HL-39730722

Excel Automation for Hose Assembly order & production Management

I need to automate several Excel workbooks related to hose assemblies. We will provide basic templates, and your task will involve creating links and buttons fo...