Excel VBA Jobs

I have over ten existing price templates that all follow the same column structure, but each one serves a different customer tier and that data needs to be inputted into the most up to date price template. I need them merged into one clean, well-organized master workbook in Excel. Your task is straightforward: enter the current pricing data exactly as provided, consolidate every template into a single sheet, and add a clear tier reference so that I can filter or pivot by customer level later. Accuracy is critical—formulas, cell formats, and any hidden calculations from the originals must carry over without corruption. If a lookup table or a dynamic named range will keep things tidy, please set that up for me. Deliverables: • One master Excel file containing every price poi...

I maintain a master price sheet (the “source” workbook) and a client-facing quote sheet (the “destination” workbook). I need the destination file to pull prices automatically from the source file through standard Excel formulas rather than macros or Power Query, so the link remains transparent and easy to audit. Inside the destination sheet the user must be able to customise a quote through: • dropdown lists that drive item selection • checkbox selections that add or remove optional services As users make choices, the relevant rows—or whole quote sections—should appear via simple drag-and-drop or copy-down actions, with all pricing fields updating instantly from the source workbook. Future maintenance is also critical. New products or pr...

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

I'm seeking an expert to help me with Excel-related accounts issues. Key Areas of Assistance Needed: - Discuss accounts issues with an expert - Help with Excel formulas and functions, specifically VLOOKUP and HLOOKUP Ideal Skills and Experience: - Proficiency in Excel, especially in VLOOKUP and HLOOKUP - Experience in handling accounts-related tasks in Excel - Ability to explain complex concepts in a simple manner - Strong problem-solving skills Looking forward to your expertise!

I need an excel spreadsheet that contains a list of ads that I sell. Some are sold with a date range and some are sold by quantity. On a single booking sheet I need to enter the company name, select an ad type and enter either a date range or enter the quantity purchased depending on which type of ad is selected. An output sheet or summary will show me the following at a glance: Ads by Date Range Company Name, Ad type selected, start date, finish date, status. As ads approach 7 days until expiry the finish date text will turn orange, once it reaches the finish date it will go red. no two customers can have the same date range ad type Ads by Quantity Company Name, Ad type selected, Quantity purchased, Ads completed, Ads remaining. If 10 ads are purchased then 10 tick boxes or radio bu...

I am writing to express my interest in your project regarding the consolidation of multiple Excel files into a master spreadsheet. I understand that for your system, precision, naming conventions, and data integrity are non-negotiable. Why I Am the Right Fit for This Task: I don’t just "copy and paste." I treat data entry as a technical process to ensure your system receives clean, error-free uploads: Data Scrubbing: I will use functions like TRIM and CLEAN to remove stray spaces and hidden characters that often cause upload errors. Format Integrity: I will ensure that SKUs and Descriptions remain as text, while Quantities and Prices are strictly maintained in Number/Currency format without losing decimal precision. Attention to Detail: I will proactively fl...

I have several Excel files that contain a mix of text and numeric fields. I need every row transferred with precision into a new master spreadsheet that follows my column order and naming conventions. Key points • Source: digital Excel sheets I will supply. • Content: mixed data—product names, descriptions, SKUs, quantities, and prices. • Scope: copy + paste is not enough; please check for stray spaces, obvious typos, and ensure numbers remain in number format. • Deliverable: a clean, fully populated Excel workbook ready for immediate upload to my system. I will share a small sample first so you can demonstrate your approach to accuracy and consistency. Once confirmed, you’ll receive the full batch. Turnaround and clear communication are import...

I have a current excel spreadsheet that i record my options trades in. I didnt' design the spreadsheet. I want to recreate the current excel spreadsheet with a couple extra things. This should be a fairly easy job since I already have the excell workbook done and just need to recreate it with a couple changes. Please let me know if this is a project you could take on. Again, this should be fairly easy with the right designer.

My current inventory spreadsheet has thousands of rows that need to be turned into a concise, interactive view so anyone on the team can spot key patterns instantly. The core task is to build, inside Excel, a robust pivot table (or connected set of pivot tables) focused strictly on data summarization of this inventory data. What I need from you is a clean-structured pivot solution that: • Refreshes flawlessly when new inventory records are added • Lets users slice results by any existing field (SKUs, warehouse, date received, etc.) without breaking formulas • Keeps the raw data untouched, with the summary living on a separate, well-labeled sheet • Includes clear, in-sheet notes so someone with intermediate Excel skills can maintain it later Please hand ove...

I'm looking for someone to redesign multiple Excel worksheets we use for project management. Key Requirements: - Better organization: Restructure existing data for clarity. - Additional functionalities: Implement new features (e.g., automated calculations, dynamic charts). - Experience with Excel, particularly in project management contexts. - Ability to create user-friendly, efficient layouts. Ideal Skills: - Advanced Excel skills - Strong project management knowledge - Proficient in creating organized and functional spreadsheets Please provide samples of previous work.

I need an interactive Excel dashboard that turns my raw sales data into clear, weekly insights. The primary focus is tracking sales performance, so the layout must highlight both our overall sales volume and how that volume breaks down by region. Data will be refreshed every week. With that in mind, the file should be structured so I can drop in a new data dump and see the visuals update automatically—no manual re-linking or reformatting. Slicers or simple drop-down filters for date ranges and regions are welcome as long as they stay intuitive for non-technical users. Deliverables • One Excel workbook containing: – Dynamic tables feeding all charts – At least two visuals: a headline KPI card for total volume and a region-level comparison (bar, map, or s...

I have 150 pages of PDF files that contain mixed data—both text and numbers—that must be transferred manually into a single Excel workbook. Accuracy is critical and everything has to be finished no later than 25 February 2026. While you copy the information, I also need built-in data validation so the sheet is ready for immediate use. Specifically, the workbook must: • Flag any numeric value entered outside the ranges I will supply. • Restrict certain text fields to an allowed-values list I will provide. • Prevent duplicate entries across all rows. Please keep the structure of the PDF intact in the spreadsheet (one row per record), use clear column headings, and return the file in .xlsx format. I will be available to answer questions quickly and supply sam...

I have a growing set of customer records that must be brought into a single, reliable Microsoft Excel workbook. The work involves three clear steps: • Data entry – transfer raw customer details I provide (names, contact info, purchase history, notes) into a structured Excel template. • Data cleaning – de-duplicate, standardise phone and email formats, and flag any incomplete fields so our CRM import runs smoothly. • Basic analysis – add pivot tables and simple charts that highlight total customers by segment, recent purchase frequency, and any notable trends you spot. Everything has to stay inside Excel—no outside tools—so a solid command of formulas, data validation, conditional formatting, and pivot tables is essential. I will review the...

I'm looking for an Excel sheet to help plan projects by calculating and categorizing expenses. Requirements: - Track and categorize expenses: Products, Labor, Miscellaneous, Subtrades - Automatic calculations for totals - Expense categorization for better organization Ideal Skills: - Proficiency in Excel - Experience with automatic calculations and data organization

I have several months of raw sales transactions in Excel that need to be cleaned, organized, and transformed into formal financial reports. The source sheets include order dates, SKUs, unit prices, discounts, tax, and payment method details; nothing is yet summarized or categorised. Your job is to: • Tidy the data (remove duplicates, standardise date and currency formats, flag anomalies). • Build an Income Statement that automatically rolls up revenue, COGS, gross margin, operating expenses, and net profit. • Build a Balance Sheet driven by the same dataset, updating assets, liabilities, and equity as new rows are added. Both reports must stay fully formula-based—no hard-typed totals—so that I can paste next month’s sales and instantly refresh the f...

I’m sitting on a sizeable customer-data workbook and need a sharp pair of hands to turn it into something clean, consistent, and instantly insightful—all within Excel. Here’s what I’m looking for you to do: • Data cleaning and organizing: remove duplicates, fix inconsistent labels, standardise formats, and flag any obvious outliers. • Pivot tables and charts: build dynamic pivots that let me slice results by region, segment, and purchase date, then link them to clear, presentation-ready charts. • Advanced formula implementation: craft robust formulas (INDEX-MATCH, SUMIFS, array functions, whatever is best) so key metrics update automatically when I drop in fresh data. Everything should stay inside one well-structured workbook with named ranges, ...

I have several Excel workbooks that need to start running themselves today. The goal is simple: turn my manual, time-consuming routines into push-button macros. The focus is on two areas: • Generating polished, ready-to-send reports from raw sheets • Cleaning and transforming data so downstream formulas, pivots, and dashboards work flawlessly Everything sits in Microsoft Excel and must be handled entirely with VBA. No add-ins or external tools are required—just clean, well-commented VBA modules that I can maintain later. I will provide the current files and a quick walkthrough of the reporting logic and data issues. From there, I need: 1. A single workbook (or a small set, if separation makes sense) containing fully automated procedures. 2. Clear triggers&mda...

I’m consolidating a collection of product details that currently live in multiple Excel sheets. Before these records move into our live system, they must be entered accurately and made analytics-ready. Here’s what has to happen: • Data cleaning & verification – detect typos, duplicate SKUs, or incomplete attribute fields and correct them. • Formatting & organizing – structure columns uniformly, apply consistent naming conventions, and ensure every record aligns with our template so the import runs smoothly. • Analysis & reporting – once the file is clean, generate a brief summary (e.g., item counts per category, missing image percentages) so I can validate data health at a glance. The final hand-off will include the clean...

We are looking for an experienced Excel automation specialist to help connect two existing Excel workbooks used in a digital media workflow: Traffic Sheet Workbook (placement-level trafficking instructions) CMW (Creative Specs) Workbook (creative details: ad names, rotation %, flight dates, etc.) Currently, these documents are separate and require manual copy/paste of data (e.g., ad names, rotation values, creative flights). We would like to implement a reliable, maintainable way for the Traffic Sheet to automatically pull select fields from the CMW. This is not a redesign of the documents — it is a structured automation enhancement. Current State CMW workbook contains multiple tabs: Standard Display Custom Units Video Audio Traffic sheet is placement-based (one row per placement...

I run a labour‐contract business and need a single Excel file that lets me stay on top of three things every day: (1) how much advance each worker still owes me, (2) what we spend versus what we earn from client companies, and (3) the exact cash and bank position at any moment. Here is the workflow I want reflected in the workbook: • Daily I note every advance handed to a worker and any cash that comes back. • At month-end I record the company’s lump-sum payment and the salary we finally release to each worker, leaving any un-cleared advance to carry forward automatically. • Expenses—transport, materials, incidental costs—should feed straight into a running profit calculation so that, with one click, I can see a simple month-to-date profit figure. ...

I have a backlog of paper-based invoices and receipts that must be keyed into an existing Excel template. Every figure needs to be captured exactly as it appears, with correct dates, vendor names, GST fields and reference numbers, so manual data-entry accuracy is critical. Because these records ultimately feed our Tally ledger, you should understand basic accounting concepts—debits, credits, tax codes—and be comfortable cross-checking your work against Tally reports to be sure totals match. No automated scraping is possible here; it is straight keyboard entry followed by a brief reconciliation step. Deliverable • Completed Excel workbook, fully populated and auto-sum balances matching the physical documents and my Tally control totals. Acceptance criteria •...

I need a single, self-refreshing Excel solution that pulls every lawyer’s daily timesheet from our shared folder and rolls them into one master file. Power Query should pick up any new or updated workbook the moment I hit Refresh, clean the data, and store it in a structured table. From there I want totals by lawyer, by case, and by date, all available at a click. The management dashboard must offer both a quick high-level snapshot for partners and a drill-down view for finance, presented through pivot tables alongside clear charts and graphs. Think slicers that let us slice by matter number, lawyer, week, or month without waiting. Key items I expect: • Automated data import via Power Query • Data model that supports views by lawyer, case, and date simultaneously &bul...

I have seven divorce-case billing statements from my lawyer, and I need them consolidated into a single Microsoft Excel workbook that makes every inconsistency jump out at a glance. Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags: • Overcharged hours • Duplicate charges • Unusual expenses • Fraudulent billing Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time. Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work. Deliverables 1. One Excel file (.xlsx) containing: &nd...

I need a set of Excel sheets purpose-built for handling quotations. I’ll be typing in quotation details rather than running extensive analyses, so the layout has to make entering text, line items and basic figures quick and error-free. Here’s what matters to me: • A clean, intuitive structure where I can add or remove rows without breaking any formulas. • Logical sections for item description, quantity, price and total so the sheet doubles as a professional-looking quote I can send to clients. • Basic formulas that automatically extend when new lines are added, plus a final summary field that clearly shows the grand total. • Print- and PDF-friendly formatting. I’ll share a small sample of the data I’ll be entering and I’m happy to ...

I have a collection of customer information that must be organised accurately in Excel. Your job is to take the raw details I provide—names, contact numbers, email addresses, and any extra fields I specify—and enter them into a clean, well-structured spreadsheet. The spreadsheet has to follow the column layout I give you, preserve exact spelling, and avoid duplicate records. I will share the source files in batches; each batch should be completed and sent back for a quick review before you move on to the next. I value precision over speed, but I still need a reasonable turnaround so my own workflow isn’t delayed. If you are comfortable handling typical Excel functions—data validation, basic formatting, and simple filtering—that will help keep the file consis...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

I keep a single master report in Excel that contains every client’s figures. I need a small, repeatable Python script that will: • read the master workbook, • isolate the Total Cost column and perform specific calculations, • split the rows so each client gets only their own data, • save every subset as an individual Microsoft Excel 97-2003 (.xls) file. With Data Visualization for Analysis Inside every generated file I still want the same conditional formatting and any existing cell-level number/date formats to remain intact, so the look and feel matches the master. Please write clean, well-commented code—pandas plus xlwt/xlrd or any other library that supports the older .xls format is fine—as long as it runs from the command line on Windows. Inclu...

We are looking for an experienced Excel specialist to help organize and automate our monthly sales tracking workbook. Currently, we maintain multiple sheets containing product-level sales data, but the file lacks structure and automated summaries. We need someone who can clean up the structure and create a simple but reliable dashboard. This is not an advanced BI project, but it requires solid Excel logic and clean structuring skills. Scope of Work Review existing workbook (multiple sheets with sales records) Consolidate data into a structured master table (if necessary) Create automated monthly summary calculations Build a simple interactive dashboard including: Total sales by month Sales by product category Top 5 products Monthly trend (line chart) Use Pivot Tables, SUMIFS, X...

I have a raw sales dataset sitting in Excel and need it reshaped into clear, insightful pivot tables that let me track sales trends at a glance. The goal is to transform the sheet so I can slice results by time period, product line, region, or any other meaningful field, then spot upward or downward movements without manual filtering every week. What I’ll hand over: • A clean Excel workbook containing all transactional sales records. What I expect back: • One or more well-structured pivot tables designed specifically for trend tracking. • Any supporting formulas or helper columns you create, kept within the same file and clearly labeled. • Brief notes (a few lines inside the sheet or a separate tab) explaining how to refresh or expand the analysis when new s...

I have an Excel workbook that already runs several VBA macros. Right now I need an extra routine added that, at the click of a button, builds an automated report containing clear graphs and charts drawn from the data that the existing code produces. Timing is tight—I will be online for the next two to three hours and would like to screenshare while you code so we can iterate quickly. Scope of the mini-upgrade • Insert a new sub or function into the current module stack that gathers the daily results, drops them onto a neatly formatted “Report” sheet, and then creates the required charts (line and bar are fine; feel free to suggest better visuals if you see fit). • Ensure the macro runs smoothly on both Office 365 and Excel 2016, without touching the pe...

I have a backlog of paper-based invoices and receipts that must be keyed into an existing Excel template. Every figure needs to be captured exactly as it appears, with correct dates, vendor names, GST fields and reference numbers, so manual data-entry accuracy is critical. Because these records ultimately feed our Tally ledger, you should understand basic accounting concepts—debits, credits, tax codes—and be comfortable cross-checking your work against Tally reports to be sure totals match. No automated scraping is possible here; it is straight keyboard entry followed by a brief reconciliation step. Deliverable • Completed Excel workbook, fully populated and auto-sum balances matching the physical documents and my Tally control totals. Acceptance criteria •...

I have a mixed set of text and numeric records that need to be moved into a master Excel workbook, carefully cleaned, and laid out so everything is easy to read and filter. Fewer than 1,000 numeric rows are involved, but each row carries accompanying text fields, so absolute precision matters. Key tasks include: • Typing the data exactly as supplied, checking every character for accuracy. • Applying my existing color-coding scheme to highlight status and priority. • Tidying column widths, headings, and basic formulas so the sheet is ready for quick sorting and filtering. I will supply the source files and the color legend; you return a finished .xlsx file—no broken formulas, no stray spaces, and every entry verified. If you spot inconsistencies, note them i...

I have a collection of customer information that must be organised accurately in Excel. Your job is to take the raw details I provide—names, contact numbers, email addresses, and any extra fields I specify—and enter them into a clean, well-structured spreadsheet. The spreadsheet has to follow the column layout I give you, preserve exact spelling, and avoid duplicate records. I will share the source files in batches; each batch should be completed and sent back for a quick review before you move on to the next. I value precision over speed, but I still need a reasonable turnaround so my own workflow isn’t delayed. If you are comfortable handling typical Excel functions—data validation, basic formatting, and simple filtering—that will help keep the file consis...

I need a polished, professional-looking invoice template built directly in Excel. The sheet must already include my company logo in the header area and follow a clean corporate layout that prints neatly on A4. Essential sections • Invoice number and invoice date, ready for quick manual entry. • Client details block (name, address, contact). • An itemised table for products or services with columns for description, quantity, unit price and line total. • A 20 % VAT line that can be switched on or off simply by selecting “Yes/No” from a dropdown. • Grand-total fields that calculate automatically as each row is filled in, reflecting VAT when enabled. Acceptance criteria 1. All calculations (line totals, subtotals, VAT and grand total) update i...

I need a set of Excel sheets purpose-built for handling quotations. I’ll be typing in quotation details rather than running extensive analyses, so the layout has to make entering text, line items and basic figures quick and error-free. Here’s what matters to me: • A clean, intuitive structure where I can add or remove rows without breaking any formulas. • Logical sections for item description, quantity, price and total so the sheet doubles as a professional-looking quote I can send to clients. • Basic formulas that automatically extend when new lines are added, plus a final summary field that clearly shows the grand total. • Print- and PDF-friendly formatting. I’ll share a small sample of the data I’ll be entering and I’m happy to ...

I run an interpreting and translation agency and I want a polished invoice template that works seamlessly in both Microsoft Excel and Google Sheets. Once complete, I should be able to copy-paste raw data straight from our CRM (sample tabs provided) and have the invoice populate instantly without touching any formulas. Key functions I need baked in: • Auto-formatting so the file always prints cleanly in landscape, no matter how many service lines we add. • Dynamic column handling—if I insert extra columns the header must stay intact, and I can hide or show selected columns with a single click. • A dedicated import zone that matches the CRM export fields, ensuring data drops into the correct spots every time. Design requirements: • Custom template styling ...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

I need an Excel sheet tidy-up to track factory production rates efficiently. Requirements: - Organize data into simple tables - Ensure sheet is user-friendly and easily updateable Ideal Skills: - Proficiency in Excel - Experience with data organization and automation - Attention to detail Please provide samples of previous work.

I have a multi-sheet Recruitment Tracker that needs to be distilled into a single, interactive dashboard in Excel. During a live screen-sharing session I want to walk through the raw data with you, connect the sheets properly, and shape a view that updates automatically. The finished dashboard should let me monitor five specific hiring metrics at a glance: Time to hire, Source of applicants, Candidates by stage, Open roles, and Hires by department and more. Bar charts will handle comparisons, pie charts will highlight shares, and line graphs will show trends over time. I’m happy to lean on PivotTables, slicers, or Power Query—whatever keeps the file lightweight and refreshable. By the end of our session I expect: • one tidy, well-labeled workbook that pulls from my exist...