Visual Basic for Apps Jobs

I have several Excel workbooks tracking my business’s income and expenses, each in a slightly different format. The goal is to bring everything together into one clean, well-structured master file that lets me see the full picture at a glance—no more hunting through separate sheets. Here’s what I need: • Import every income-and-expense line from the existing Excel files. • Standardise column headers, date formats, and categories so the data is consistent. • Build a single consolidated sheet (or pivot-ready table) that I can filter by month, category, or account. • Include formulas or a simple dashboard to show total income, total expenses, and net position. The source files are all standard .xlsx, so Power Query, VBA, or even straightforward fo...

I need to replace a handful of repetitive steps in both Excel and Word with clean, reliable VBA macros. In Excel the routine involves importing raw CSV files, re-formatting them, and generating summary pivot tables. In Word I’d like a macro that pulls those finished tables into a report template, updates reference fields, and exports the final document as PDF—all triggered by one or two buttons. If you’re comfortable writing and debugging VBA in both applications, this job should be straightforward. Please build the code in a way that is easy for me to maintain: use clear variable names, add short inline comments, and keep everything in one macro-enabled workbook (.xlsm) and one macro-enabled document (.docm). Acceptance criteria • Excel macro processes a sample ...

An existing Excel workbook is starting to slow down reporting because the raw data was compiled from multiple sources. The file now needs a proper clean-up and a consistent structure so I can use formulas, pivot tables, and dashboards without fighting errors. Here’s the scope in plain terms: the entire sheet must be reviewed, obvious problems removed, and every column normalised to the same format. That includes spotting anything that stops sorting, filtering, or lookup functions from working smoothly—mis-typed values, stray spaces, mis-aligned dates, hidden characters, or anything else you notice while you work. If a lightweight VBA routine or Power Query step will save time, feel free to use it; the final file just has to open in standard Excel without external dependencie...

I keep all of my customer information in one Excel file that is starting to sprawl across several worksheets. What I want is a single-entry workflow: I type a customer’s name or code once and the file instantly pulls the relevant details from the various sheets, then produces a clean, printable quotation (and, later, an invoice version) with no extra copy-and-paste steps. The solution can be built with VBA, Power Query, dynamic arrays—whatever is most robust—but it has to meet three essentials: • Pull linked customer data from multiple sheets in the same workbook. • Populate a quotation template automatically, ready for PDF or direct print. • Leave me with a user-friendly front end so anyone on the team can generate quotations without touching the underlyi...

I have an existing workbook that needs two upgrades: solid IF / SUMIF logic and a clean, automated export to PDF. The current sheets already hold the raw data, but totals, flags, and conditional results are still being calculated manually. I’d like you to: • Replace the manual steps with reliable IF and SUMIF formulas so the correct figures appear instantly, even when rows are added or data is shuffled. • Set up a one-click (or short-cut) PDF export that captures only the intended print area, keeps my page setup intact, and produces a professionally formatted document every time. Feel free to use native Excel tools, VBA, or another lightweight approach as long as it works on Office 365 for Windows without additional add-ins. Deliver the updated workbook plus a brief set...