Excel Macros Jobs

I have a set of Excel and Google Sheets files that track day-to-day financial data. A number of typos slipped into the header row and other column labels, and those mistakes are starting to break formulas and reports. Your task is simple but needs a sharp eye: open each spreadsheet, scan only the headers and labels, and correct every spelling or formatting error you spot while leaving numbers, formulas, and cell references exactly as they are. Because these documents feed into dashboards and pivot tables, consistency matters—please follow standard US English spelling and keep capitalization uniform across all sheets. Once finished, send the corrected files back together with a brief, line-by-line summary of what you changed so I can verify the edits quickly. Deliverables: • Up...

I need ongoing help keeping my customer data workbook clean, accurate, and up to date every single day. The dataset grows continuously, so I rely on a freelancer who can jump in, understand the structure quickly, and handle three core activities without constant supervision: • Data entry – capturing new customer records from source files or emails • Formatting and sorting – keeping columns consistent, removing duplicates, applying filters for quick look-ups • Applying basic Excel formulas – totals, averages, lookups, and error checks to flag any anomalies Each workday you’ll receive the raw inputs, update the master file, and return the refreshed version (or sync it in a shared drive) before the agreed daily cutoff. Consistent accuracy is cru...

I need a professional and easy-to-use **Excel Financial Database** for **Muhammad Waseem**. The database should be clean, modern, professional and simple to use. I should only need to enter my daily financial transactions, while Excel should automatically calculate balances, totals, summaries and graphs. The database should have **4 main pages/sheets**. -------------------------------------------------- PAGE 1 — FINANCIAL DASHBOARD Title: **Muhammad Waseem** **Personal Financial Management Dashboard** At the top, show: - Name: Muhammad Waseem - Year - Current Month - Professional dashboard header Main financial summary cards: 1. Total Credit / Income 2. Total Debit / Expenses 3. Opening Balance 4. Closing Balance 5. Total Money to Receive 6. Total Money to Pay 7. Total Savi...

I need help recovering an Excel file that won't open. I've already tried using Excel's built-in repair tool without success. Ideal Skills and Experience: - Expertise in Excel file recovery - Experience with data recovery tools and techniques - Familiarity with handling corrupt Excel files

I need an efficient, detail-oriented partner to keep a high-volume data project moving. The core of the job is pure numerical data entry: thousands of figures must be keyed into my database and mirrored in a clean, well-formatted Excel spreadsheet. Accuracy is paramount because these numbers drive financial reporting. Alongside this, I’m automating account creation and will hand you a queue of sign-up URLs. Each sign-up page triggers a captcha that must be solved before you can proceed. The targets are three groups—social media platforms, major email services, and several e-commerce websites—so expect a mix of image and text captchas. Workflow • I supply the raw numbers and an Excel template. • For captchas, you’ll receive credentials, proxy details ...

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 a clear, well-structured costing sheet in Microsoft Excel that lets me calculate every expense that goes into a tour package here at our DMC in Muscat, Oman. The workbook has to capture the full range of cost elements I deal with every day—accommodation, transportation, meals, guide charges, plus any third-party or other outsourced services—while still being easy enough for the reservations team to update quickly. Key points I want built in: • Separate input areas for each cost component with automatic subtotals • A consolidated summary that rolls everything into a single “tour cost” figure • Space for markups or margins so I can see net versus sell price at a glance • Currency flexibility (our suppliers bill in both OMR and USD) ...

Task: Create Treg accounts and collect API keys I will provide you with an Excel file containing approximately 100 GOOGLE email addresses and their corresponding passwords. For each email address, your task is to: 1. Go to Treg: 2. Create a new Treg account using the email address provided in the Excel file. 3. Complete the account setup if required. 4. Access the Treg dashboard. 5. Retrieve the API Key / X-Treg-Token displayed in the account. 6. Copy the API key into the corresponding row of the same Excel file, in a new column called “Treg API Key”. 7. Repeat the process for all accounts. The final Excel file should contain: Email | Password | Treg API Key Please make sure that: * Each API key corresponds to the correct email address. * No rows are mixed up. * You do n...

I have an existing workbook that needs a set of well-structured, reusable formulas so I can run quick calculations without relying on manual edits. At this stage I’m still finalising the exact datasets and worksheet layout, so your formulas should be written in a way that can easily be adapted to either a single sheet or a multi-sheet setup. The data itself may range from pure numbers to mixed alphanumeric values, so the logic must account for different data types and avoid errors when a cell contains unexpected content. Nested functions, dynamic named ranges, array formulas (or their Office 365 equivalents), and clear in-cell documentation are all welcome if they keep the workbook lean and easy to audit. Once the formulas are in place I’ll test them against several sampl...

I need an Excel expert to create several formulas for a spreadsheet. Essential Requirements: - Ability to perform mathematical calculations, including basic arithmetic, statistical functions, and financial calculations. - Experience with text manipulation functions. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong analytical skills - Experience with complex formulas and functions - Attention to detail Please provide examples of previous work.

I need an Excel template that makes it quick and fool-proof to log our revenue. The sheet will only capture sales amounts, and every entry has to be automatically tagged by product or service so I can slice totals instantly. Core requirements • Simple, protected entry form for daily sales amounts • Drop-down list (or similar) that forces the user to choose the correct product/service category on each line • Behind-the-scenes table structure that keeps raw data clean for future pivot-table or Power Query use • A summary tab that rolls up total revenue per product/service and refreshes with one click I’m happy with native Excel functions—no external add-ins needed—as long as the workbook stays compatible with Microsoft 365.

I have a batch of financial records that need to be transferred into a clean, well-structured Excel workbook. The information includes plain text labels, numerical figures, and date/time stamps, all pulled from my accounting statements. Your task is straightforward data entry: • Set up or refine a simple template inside Excel (any recent version is fine) so each field—text, numbers, and dates—lands in the right column, with consistent formats and basic validation where practical. • Key every line of the provided financial data into that template with zero transcription errors. • Return the finished .xlsx file ready for immediate analysis, plus a brief note highlighting any unreadable items you had to flag. Everything will be supplied in PDF and CSV form, ...

I’m putting together a three-sheet Excel workbook to help me stay on top of my money and I’d like a specialist to build it cleanly so everything updates automatically. Sheet 1 – Income & Expenditure I want a straightforward table with separate columns for income and expenses. As I add rows, running totals and a net-balance field should refresh instantly. Simple drop-downs for date and category would be a bonus, but clarity and ease of data entry come first. Sheet 2 – Statistics Here I only need bar charts that pull from the first sheet and redraw themselves as new figures appear. At a glance I should be able to compare monthly totals and see trends. Sheet 3 – Budgeting (50/30/20) This sheet should apply the classic 50 % Needs, 30 % Wants, 20 % Sav...

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

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 a collection of records that need to be keyed into Excel manually. The information is a mix of text and numbers, so the workbook has to be arranged in a way that keeps labels clear while still allowing basic calculations or filtering. I do not yet have a working template, only a rough idea of how the finished sheet should look. Your first task will be to shape an easy-to-use layout—column headings, consistent data types, light formatting, and, where it makes sense, simple formulas or data-validation to prevent errors. Once the structure is approved, you’ll enter all of the supplied data with careful attention to spelling, number accuracy, and overall consistency. Deliverables • A reusable Excel template (.xlsx) reflecting the agreed layout • The template ...

I have a set of raw figures that I need entered accurately into a master Excel workbook and, just as importantly, I want the file to do the heavy lifting for me once the numbers are in place. This means building solid formulas—SUM, SUMIF/S, XLOOKUP, IF statements, running balances, variance percentages—so the totals and subtotals update automatically every time I add new rows. Accuracy is critical because these tallies feed straight into management reports. If you spot a cleaner way to structure the sheet or streamline calculations, I’m open to your suggestions as long as everything remains transparent and easy for me to maintain. Deliverables • A clean .xlsx workbook populated with my supplied data • All requested formulas working and tested with sample v...

I need a polished, dynamic financial workbook that will impress Australian venture capitalists and help me secure funding. The model must handle budgeting and forecasting, drill into financial-statement analysis, and keep a close eye on cash-flow management so I can show exactly how much runway we have and when we hit break-even. You’ll start with an editable assumptions tab and build out three- to five-year monthly projections that flow automatically into the profit & loss, balance sheet, and cash-flow statement. Because the primary goal is to attract investors, I also want clear KPI dashboards—burn rate, runway, CAC, LTV, EBITDA—and simple, investor-friendly charts that can drop straight into a pitch deck. Scenario toggles (base, conservative, aggressive) are essen...

I have an Excel workbook that needs to do more than hold raw numbers. Using IF, SUMIF (and similar) formulas, I want the file to: • filter my data on the fly, • run conditional calculations that adapt as new rows appear, and • roll everything up into clear, criteria-based summaries. Once that logic is solid, I also need a one-click way to export the relevant sheets—or a defined print range—straight to PDF. The export should preserve whatever structure the formulas create, so the numbers shown in the PDF always mirror the latest workbook state. If charts or additional tables are required to make the report clearer, please build those into the flow; I’d like the option to toggle them on or off without touching the underlying code. Deliverables: ...

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

I have a batch of more than ten Excel workbooks that must be turned into polished, press-ready PDFs. Before you generate each file, I need three specific customisations applied: • Formatting changes – adjust column widths, fonts, margins and page breaks so every page sits neatly on standard A4/Letter. • Adding headers/footers – insert my logo on the left, the file name centred and the date on the right, mirrored on every page of the export. • Including charts/graphs – keep all embedded charts exactly where they belong and ensure they render sharply in the final PDF. If you can automate the process with a reusable VBA macro, Power Query routine, or a reliable Python script (openpyxl, pandas, reportlab, etc.), that would be ideal; I want to be able to r...

I have a raw spreadsheet that needs to be tidied up and then pushed a step further into simple predictive work. I only need four well-chosen Excel formulas that will: • clean the data first—removing blanks, standardising text and isolating usable rows, • feed a lightweight predictive-model setup so I can forecast future values from the cleaned series. Please give me: 1. The exact four formulas, written so they drop straight into Excel without extra add-ins. 2. A brief line under each explaining what it does and why you chose it. 3. A small demo sheet (can be dummy data) showing the formulas in action, with the forecasted values clearly visible. Keep the approach native to Excel—functions such as FILTER, UNIQUE, TEXTSPLIT, LET, XLOOKUP, FORECAST or whatever c...

I have a live spreadsheet that has to be cleaned, have smart logic added, and be ready to share today. The job breaks down into three fast-moving parts: 1. Data organisation – tidy the existing rows, ensure consistent headers, remove blank or duplicate lines, and generally get the file into a solid table structure that works well in Excel 365. 2. IF and SUMIF formulas – build the conditional logic I’ll specify (e.g. flagging records that meet multiple criteria and rolling subtotals by category). Every formula must calculate correctly across the full data set. 3. Exports – once the numbers check out, create two outputs: • a flat .csv file that carries all final values (no broken references) • a clean, print-ready PDF report of the same data, sized to...

I have a customer database in a single Excel workbook that needs a thorough scrub. The file currently contains duplicate rows, inconsistent name capitalisation, mixed-format emails, city names with spelling variations, and several date columns that appear in multiple formats. Here is the refinement I’m after: • Remove every duplicate record while keeping the first valid instance. • Standardise all personal fields—names in proper case, emails in lowercase, city names consistently spelled. • Reformat every date to DD/MM/YYYY so reporting tools read them correctly. • Apply uniform cell formatting (text, number, date) across the sheet. • Leave any legitimately missing value blank; do not introduce placeholders or delete rows that could still ho...

I need two things handled in the same engagement. First, my existing workbook needs reliable SUM, AVERAGE and a few straightforward (and nested) IF formulas placed in the correct columns so monthly roll-ups calculate automatically. Second, I have several reports locked away in PDF format that must be converted into clean, fully editable Excel sheets—tables aligned, numbers preserved as numbers, and no text scrambling. Feel free to work with whichever tools you trust most—Power Query, Adobe Acrobat, or a dedicated converter is fine—as long as the end result is accurate and easy for me to maintain. I’m flexible on timing, so take the space you need to get the details right. Deliverables: • Updated .xlsx file with all requested formulas in place and functi...

I have a data-heavy workbook that relies on several IF statements to drive the analysis, but a few of them are getting unwieldy and returning inconsistent results. I’d like a fresh set of eyes to review my current logic, streamline it where possible, and make sure each formula scales as new rows are added. The job is purely formula-focused—no VBA or macro work—so deep knowledge of Excel’s logical functions is essential. Deliverables • Corrected or rebuilt IF formulas for the specified sheets • Brief in-cell or separate notes explaining how each formula works • Confirmation that results update accurately when I append additional data Once the revised workbook passes a quick spot-check on my end, the task is complete.

I’ve put together several product-information workbooks in Excel and now need two things finished. First, add or refine the conditional formulas—mainly IF and SUMIF—so totals, flags, and subtotals update automatically no matter how many products I append. The logic has to stay transparent so I can tweak thresholds later, and every reference must stay within the sheet (no hard-coded ranges that break when data grows). Once the calculations are solid, convert each completed worksheet to a clean, print-ready PDF. I’d like the PDFs to keep the same column order, hide gridlines, fit to A4, and stay under a reasonable file size for email sharing. Deliverables: • Updated Excel files with working IF/SUMIF logic • One matching PDF for each finished sheet S...

I have a stack of raw financial records that need to be transferred into Excel and transformed into clear, accurate monthly summaries. I will supply the source documents—mostly PDF bank statements and expense receipts—and I’m looking for a clean, well-structured workbook that lets me see each month’s totals at a glance. Here’s what I need from you: • Enter every transaction exactly as it appears, double-checking dates, descriptions, and amounts for accuracy. • Create a separate sheet (or clearly labelled section) for each month, then roll those figures into a concise summary tab that shows income, expenses, and net. • Add basic checks—simple formulas or pivot tables are fine—to flag any obvious data entry errors. • Keep ...

I’m looking for focused, one-on-one help in Excel so I can turn raw management data into clear, executive-ready visuals. My priority is data analysis in the form of data visualization, and I want to concentrate specifically on Conditional Formatting and Sparklines. I already know the basics of spreadsheets; what I need are practical techniques that let me highlight trends, embed tiny in-cell charts, and package everything into a monthly report that prints—or exports to PDF—without surprises. Please work with the real files I’ll share, walk me through best-practice layouts, and show me how to keep everything dynamic so the visuals update automatically as new numbers arrive. Deliverables • Live screen-share coaching sessions scheduled over the next two week...

I maintain large Excel files exported from Myntra and need them transformed into clean, ready-to-upload CSVs at the click of a button. The work is strictly re-organising: reshuffle columns into a fixed layout, normalise headers, drop unused rows, and save each sheet (or a consolidated range, if easier) as a separate CSV file. I will provide a sample workbook that shows exactly how the raw data arrives and a template that illustrates the desired CSV structure. Your job is to write a well-commented VBA macro housed in the same workbook so I can press a single control and generate the files automatically whenever new data comes in. No external add-ins are permitted; standard VBA in Office 365 is fine. Deliverables • The macro-enabled workbook (.xlsm) containing all code • Clea...

I have a collection of customer records that currently live partly in PDF documents and partly in a rough Excel file. I want everything consolidated into a single, tidy workbook and equipped with the right formulas so I can slice the numbers instantly. Step one is pulling the information out of the PDFs and arranging it in clean, tabular form inside Excel—no manual copy-and-paste errors, and every column properly typed. Once the data sits where it belongs, I need the following logic added: • SUM and AVERAGE calculations for key spend, balance and contact counts • IF statements tied to conditional formatting that immediately highlight missing fields, overdue payments or duplicate entries • VLOOKUP and HLOOKUP where look-ups make sense, and XLOOKUP for the longe...

I’m working on an Excel workbook that stores and organises large volumes of GST- and TDS-related figures. The structure is solid—data validation, filters, sorting and some conditional formatting are already in place—but the heart of the file, the formulas and functions, now need a careful audit and refinement to keep the data flow error-free as the sheet grows. Here’s what I need from you: • Go through every existing SUM, IF, nested IF, VLOOKUP and XLOOKUP I’ve built, check for hidden inconsistencies and remove any redundant calculations. • Optimise each formula so look-ups are fast and ranges stay dynamic even when new rows are added. • Confirm that all totals reconcile across summary tabs and the GST & TDS sections. • Return a ...