Excel Macros projects — HireLancer archive

ID / Date Listing

ZKTeco uFace 800 Excel Report

Our uFace 800 (ZKTeco) records every punch reliably, but I need a clean, monthly Excel report that managers can read at a glance and payroll can import without...

HL-39893374

Excel Text Entry Consolidation

I have a collection of Excel spreadsheets that contain text-only records and I need every line moved into a single master sheet that follows my exact column ord...

HL-39893162

Excel Macro Automation for Training Calendars

I'm seeking an Excel expert to automate the scheduling of basketball training sessions. The automation should create an organized calendar for our training sess...

HL-39893168

Automated Sand Cone Test Spreadsheet

I have a ready-to-use Sand Cone Test Excel sheet with all formulas built-in. The sheet is designed to streamline your field calculations—just enter the basic da...

HL-39892676

Excel Data Reshaping Automation

I have an Excel workbook that currently holds 8 rows, each row containing 20 bundled data sets. I need every embedded set split out so the file ends up with 160...

HL-39892477

Excel Macro Formatting Spreadsheet

I have two separate .csv exports that I work with every day, and I’m tired of manually cleaning them up. I need a single, macro-enabled Microsoft Excel workbook...

HL-39892297

Excel Data Reshaping Automation

I have an Excel workbook that currently holds 8 rows, each row containing 20 bundled data sets. I need every embedded set split out so the file ends up with 160...

HL-39892321

Excel Accounting for small shop

Daily transactions in my small shop require precise, same-day entry in a well-structured Excel workbook. Each evening’s figures for both Sales and Expenses must...

HL-39890224

Necesito automatizar un archivo Excel

Necesito automatizar un archivo en Excel (adjunto referencia), con algunas condiciones como, por ejemplo: 1. Vinculación de campos: cargo, carga horaria, etc 2....

HL-39889977

Macros Excel para PDFs Comisiones

Tengo un archivo Excel que concentra las comisiones de más de 50 vendedores. Necesito una macro (o conjunto de macros) que, con un solo clic, recorra la hoja, f...

HL-39889393

Dental Lab Excel Form must be convertable to pdf and or HTML in the 2nd fase

I need an Excel workbook that lets our dentists fill out a simple, structured form so we can pass clear “patient teeth requirements” on to the dental lab. Scope...

HL-39888332

PDF Syllabus to Excel - P1

I have a university syllabus, roughly 100 readable-PDF pages, that needs to live in a clean, well-structured Excel file by tomorrow. The document mixes text and...

HL-39888457

Amazon Feed Converter VBA

I keep my full product catalogue in a standard .xlsx workbook, but Amazon wants their own inventory template. I’m looking for a clean, one-click VBA routine tha...

HL-39887874

Accurate Excel Data Entry Needed

I need help transferring a sizeable batch of information into a clean, well-structured Microsoft Excel workbook. I’ll provide the raw data, and I’m looking for...

HL-39887922

Excel Reconciliation Automation

I export two Excel workbooks every cycle—one “old” file and one “new.” I need a reusable automation that: • Imports both files and matches rows by Company + Acc...

HL-39887423

Balanced 8-Team Hockey Schedule

I run an 8-team hockey league that plays all its games in a single arena. The ice slots for the entire season are already fixed; what I need is a well-structure...

HL-39886698

Otel Gelir-Gider Excel Şablonu

Otelimdeki günlük nakit akışını hızlıca takip edebilmek için sade fakat işlevsel bir Excel dosyasına ihtiyacım var. Dosya yalnızca gelir-gider analizi yapacak;...

HL-39886711

Restore XLSX Workbook to XLS

I have a sizeable Excel workbook currently saved as XLSX and I need it rolled back to the older XLS format so colleagues on legacy software can open it. Key poi...

HL-39886622

Advanced Excel & Power BI Tutoring

I’m an intermediate Excel user ready to master the next level—Power Query, DAX, and Pivot Tables—while also building solid skills in Power BI. My goal is to cre...

HL-39886501

Sales Data Pivot Analysis Setup -- 2

I need an Excel expert who can transform raw sales figures into clear, interactive insights. The data is already collected but lives in several worksheets; I wa...

HL-39886504

Excel Medical Data Summary

I’m working with an anonymized spreadsheet of patient records and need a tidy, reader-friendly snapshot of what the data is telling us—nothing predictive, stric...

HL-39886422

ملف إكسل ذكي للعملاء

أحتاج إلى تصميم ملف Excel تفاعلي يجمع بيانات العملاء ويحلّلها داخل المصنف نفسه. الإدخال سيكون حصرياً عبر حقول نص مفتوحة حتى أتمكّن من تسجيل المعلومات بسهولة ومن...

HL-39885979

Cross-Sheet Excel Summation Formula

I have an Excel workbook made up of several custom-named sheets. Each sheet holds the same type of numeric data in a consistent cell range, and I need a single...

HL-39884630

Excel Overhaul & Timeline Integration

I have an existing workbook that needs a tidy-up and a few smart upgrades. Here’s what I’m aiming for: • Formulas: Some of the current calculations are misfirin...

HL-39884362

Excel UC/LC Capture & Kite Order Automation

I need a two-step automation process for stock trading. Step 1: Create an Excel utility that captures Upper Circuit (UC) and Lower Circuit (LC) data for specifi...

HL-39882883

Urgent Excel Model Repair

My multi-sheet Excel workbook is riddled with formula errors and the balance sheet stubbornly refuses to balance. I need someone who can jump in immediately, tr...

HL-39882743

Workload Matrix Excel Enhancement

I need a quick refresh of my existing Workload Matrix spreadsheet so it’s easier to read, harder to break, and ready for day-to-day use. You’ll work directly in...

HL-39882583

Custom Excel Conditional Formula

I’m looking for a concise, easy-to-maintain conditional formula that handles clear if-else scenarios in Excel. I’ll provide the worksheet, the specific cells in...

HL-39880637

Excel Dashboard Development for Projects & Ops

I'm looking for an experienced Excel developer to create an interactive monthly dashboard for the Projects & Operations Department. This dashboard will replace...

HL-39880365

Comprehensive CNG Pump Ledger

I need a single Excel workbook that becomes the financial nerve-centre for my CNG pump. Each day my staff will key data in manually, and from that one action I...

HL-39880035

Excel VBA Automation Script

I need a lightweight VBA macro that sits inside an Excel workbook and automates a repetitive reporting task. Each time I open or refresh the file, the script sh...

HL-39880077

Excel CBM Calculator for Logistics

I need a lightweight Excel file that lets me enter weight and volume figures for each shipment and instantly returns the corresponding CBM totals for shipping a...

HL-39878832

Excel Financial Data Specialist

I have a collection of Excel files with raw financial figures that I need turned into a clean, usable dataset and a brief insights snapshot. The work is straigh...

HL-39878267

Data extract then Automated Excel CFSI Dashboard with automations and word/outlook template outputs Reports

Project title Automated Excel CFSI Dashboard and word/outlook template outputs Objective Build Excel workbook that runs the entire CFSI pipeline. Data entry, tr...

HL-39877674

Help Preparing Financial Statements and answering two theories

I’m working through a basic financial-accounting project and need a hand finishing it quickly. The assignment has two parts: 1. Brief, easy-to-follow write-ups...

HL-39877276

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

Excel SUMIFS Donation Tracker

I have an Excel spreadsheet that lists individual monetary donations, and I need a straightforward way to track and summarize these contributions by month. A cl...

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