Excel VBA Jobs

I have a series of company Cash Flow Statements spanning multiple periods and I need a clear, professional trend analysis completed in Excel. Your task is to organise the data, build the necessary formulas, and present the underlying trends so I can quickly spot shifts in operating, investing, and financing activities. I’m happy for you to use any Excel features that make the findings easy to read—pivot tables, dynamic charts, conditional formatting, or dashboards—so long as the final workbook is clean, well-documented, and ready for decision-making. Please focus your application on your experience performing similar cash-flow or broader financial trend analyses in Excel. I’m particularly interested in hearing how you have transformed raw statements into actionabl...

I have a series of documents that need to be turned into clean, well-structured Excel workbooks. The work starts with straightforward typing and transcription—moving the raw information from handwritten notes and PDFs into rows and columns. Once everything is in place, I also want the sheets organized, the right formulas inserted for quick calculations, and a light layer of analysis added so I can spot trends instantly. You’ll be working only in Excel spreadsheets, so deep familiarity with its data entry shortcuts, formula building, and basic visualization tools (think PivotTables, charts, conditional formatting) is critical. Accuracy is more important than speed, but I’m looking for someone who can deliver both. Deliverables I expect: • A fully populated Excel fil...

I have an Excel workbook containing sales data that I need to plug straight into my reporting dashboards, but the file is full of formatting inconsistencies. Your job is to go through every sheet and standardise two things: • Dates – everything must follow a single, clearly documented format across the entire file (e.g. YYYY-MM-DD). • Currency values – all monetary figures need to display as the same currency symbol, use consistent thousand-separator rules, and carry two decimal places. There are no duplicate-removal or missing-value exercises this time; the sole focus is on making the file presentation-ready. I’ll supply the spreadsheet and my preferred final styles. Once you’re done I want the cleaned .xlsx plus a short changelog so I can see exactly...

I have a growing list of customer information that now lives in several scattered files. I need it consolidated into a single, well-structured Excel workbook that is easy to update and filter when new records come in. The job centres on two data sets: contact information (names, emails, phone numbers, addresses) and each customer’s purchase history (order dates, items, quantities, amounts). Once everything is merged, I’d like clear column headings, consistent formats, basic data-validation rules, and a few summary views—simple pivot tables or filtered views are plenty—to give me quick insights without extra clicks. Please show me examples of past work where you cleaned or organised similar customer data in Excel so I can see your approach to structure and clarity....

I have all of my raw sales data stored in Excel workbooks and I want a single, interactive dashboard that instantly tells me how the business is performing. The dashboard must focus on three core metrics and update automatically whenever I drop new data into the same folder or worksheet: • Total sales volume • Sales by region (with an easy way to switch between regions) • Sales growth over time You are free to use PivotTables, Power Query, slicers, dynamic charts, or any Excel-native feature that keeps everything contained in one file—no external add-ins, please. Clean layout, clear labelling, and colour-coded visuals are important because this will be shared with non-technical colleagues. Deliverables • A finished .xlsx file with the dashboard on a ded...

I have an Excel file laid out in a straightforward table and I need fresh rows entered accurately from source material I will provide. No formulas or links are involved—just clean, consistent data entry that respects the existing headings and cell formats so the sheet remains ready for downstream use. At the same time, I have a companion PDF that requires a round of corrections. The exact mix of text edits, layout touch-ups, or image swaps will be shared once you’re onboard; the goal is a polished, print-ready document that matches the updated spreadsheet content. Deliverables • Updated Excel workbook with all new data correctly placed • Final, corrected PDF returned in the same page order and resolution as the original Send back both files error-free and nam...

I have between 50 and 100 documents that contain a mix of text and numeric values. I will supply these files, and I need every piece of information transferred into a single, well-structured Excel workbook. Your job is to: • copy the data from the documents into Excel, • clean and format each column so everything is consistently typed, capitalised and aligned, • insert basic formulas where totals or averages are required, and • rearrange rows or columns whenever it improves clarity. Accuracy is critical—every figure must match the source, and the sheet should be free of duplicates, blank rows and stray characters. The final workbook should be ready for analysis the moment I receive it. Please let me know your best price and how quickly you can turn th...

I need a clean, up-to-date spreadsheet that lists Polish companies at scale. The file must contain three columns only—Company Name, Email Address, and Sector—and total no fewer than 300 000 unique records. Automated web-scraping or API harvesting is the only collection method I will consider; manual research is out of scope. Please structure the delivery as a single XLSX (or compatible) file. In your proposal tell me: • how many records you can supply for each sector you intend to cover, • your total price for the full dataset, and • the estimated turnaround time. Data quality matters: I will sample for duplicate domains, obvious syntax errors, and bounced addresses, so plan for basic validation before hand-off. If this is within your capabilities, I look ...

I need a machine-scraped contact database for Romanian companies operating in five clearly defined sectors: design offices & architects, locksmithing & metalworking, electrical installations, stonemasons, and carpentry. Each record must contain exactly three fields—company name, phone number, and email address—delivered in a single Excel file. Feel free to pull the information from company websites, reputable business directories, and social-media business pages; those three sources together should give the breadth I’m after. A basic validation of phone numbers and email syntax is enough, as long as obvious bounces or malformed entries are removed. Volume is critical. I expect several thousand, ideally tens of thousands, of unique records overall. When you respo...

I receive a raw Excel export straight from our database and need it turned into a clean, analysis-ready workbook. Every record is already there, but column widths, dates, numbers and text fields arrive in mixed formats, making the file hard to read or filter. The main requirement is to clean up the Excel conditional formatting, remove any incorrect or unnecessary formatting, and make the formatting consistent and organized. The freelancer can use the existing Excel file as the reference. Your task is to bring order to the chaos: • Verify the download imported correctly—no cut-off text, misaligned columns or hidden characters. • Apply smart conditional formatting rules that instantly flag duplicates, outliers or empty cells and add subtle banding for readability. &bull...

I have a financial report drafted in Microsoft Excel that needs a careful editorial pass. Your task is to review every worksheet for numerical accuracy, consistent formatting, clear labeling, and correct formulas, then polish the wording so the final document reads professionally and is ready for stakeholder review. I’m looking for a mid-level editor with solid accounting knowledge and strong command of Microsoft Excel features such as conditional formatting, pivot tables, and data validation. If you’re comfortable checking totals, tracing formulas, and tightening explanatory notes, you’ll fit right in. When you apply, focus on relevant experience—tell me about similar financial reports or spreadsheets you have edited and the impact your changes made. No lengthy p...

I have between two and five Excel workbooks that must be publication-ready for our upcoming reports. Before I can plug them into the dashboards, each sheet needs a precise clean-up: • Remove every duplicate entry while keeping the first accurate record. • Detect, fill, or clearly flag missing values so no blank cells slip into the final figures. • Standardise formatting—dates, currency, percentages, text casing, column names, and number precision—so each file follows the same structure. I’ll provide the original files plus a short data dictionary. Please return: 1. A cleaned version of every workbook, keeping original file names with “_clean” appended. 2. A concise change log (Excel sheet or CSV) that notes what was removed, filled, or ...

I need you to complete the attached Excel file **“APF – Organisation Data Sheet FY 2026–27”** for organisation. Your responsibility is to complete the entire workbook accurately and make it **submission-ready**. Please do not just enter whatever information is readily available—review the instructions in the workbook, identify the information/documents required, collect the missing details from the organisation's records, and complete all applicable sections. ### Scope of Work Please review and complete the following tabs: 1. **Org Profile & Documents** * Verify and complete the organisation profile. * Complete all required organisation details. * Review the complete list of required documents. * Mark whether each document has been up...

I have several Excel workbooks that contain customer records and I’ve noticed the same phone numbers appearing more than once. Your task is straightforward: scan every sheet, spot rows that share an identical phone number, and give me back a version of each file where those duplicates are either eliminated or clearly flagged on a separate tab—whichever you find cleaner to implement. I do not need help with missing values or formatting issues right now; the focus is solely on duplicate detection. Excel-native solutions such as advanced filters, Power Query, or a short VBA routine are all acceptable, as long as the final files open without macros blocked warnings and every surviving record is unique by phone number. Please provide the cleaned Excel files plus a brief summary of...

Project overview • Need an Excel-based system for a small vehicle finance office (4‑wheelers and 3‑wheelers). • Objective: move from handwritten registers to a single Excel workbook that tracks all agreements, instalments and reminders with minimal manual work.[freelancer +3] --- Core requirements • Create a Master “Agreement” sheet (one row per agreement) with: • Hirer details (name, address, mobile). • Guarantor details (name, mobile). • Vehicle details (type, make, model, year, regn no, engine no, chassis no). • Finance details (loan/finance amount, total amount to recover, number of instalments, instalment amount, first due date, frequency). • Create an Installments / Dump sheet (one row per instalment) that can be auto‑generated from...

My main Excel workbook refuses to load correctly. The moment I try to open it, Excel throws the warning: “Excel cannot open the file because the file format or file extension is not valid.” If I continue, the file does open, yet every sheet is visibly corrupted—numbers, formulas and formatting are all unreadable. The goal is simple: restore this file so it opens in modern Microsoft 365 without errors and displays its original data, formulas, charts and pivots intact. You may rely on any recovery approach—built-in repair, VBA, third-party tools, hex or binary editing, even temporary conversion through LibreOffice—as long as the outcome meets the criteria below. Acceptance criteria • A clean .xlsx that opens with zero error prompts • Origina...

I have several digital files—mostly PDFs and Word documents—that contain a mix of numbers and text. I need everything transferred accurately into Excel and organised as clean, structured tables. Each table must have clear, consistent headers so the sheet is ready for sorting, filtering, and further analysis the moment you hand it back. Please keep cell formatting tidy, use native Excel tables (so the headers stay locked in place), and double-check that every numeric figure and text entry matches the source. Deliverables: • One Excel workbook with separate, well-named sheets for each source file • All data entered in official Excel table format, with headers applied • Quick rundown of any data you could not decipher or confirm If you’re comfortable w...

I have an inventory spreadsheet in Excel that’s getting hard to read at a glance because every new entry lands wherever it pleases. What I need is a clean, repeatable way to reorder all rows strictly by the Quantity column, lowest-to-highest (or highest-to-lowest if that proves more practical). The file is under 5,000 rows, uses standard .xlsx formatting, and has no macros at the moment. The job is straightforward: • Open the sheet in Excel (Office 365). • Apply an accurate numerical sort on the entire dataset so each product line keeps its details intact. • Double-check that no values shift out of alignment during the process. Once done, send back the updated .xlsx plus a short note on the exact steps you followed so I can repeat them on future uploads. That&r...

I have an existing Excel workbook that needs a thorough clean-up and a touch of professional polish. Your job is to: • remove any stray characters or spacing issues, • apply a single, consistent font style across every sheet, • set up the formulas and functions that will automate all current manual calculations (SUM, VLOOKUP/XLOOKUP, IF statements, or whatever is most efficient for the data on hand). When you return the file, every cell should calculate correctly without error messages, and the entire workbook should look cohesive at a glance. Please tell me about projects where you have performed similar Excel data cleaning or formula-building work. A quick note on the challenges you solved and the tools or functions you relied on will help me pick the right fit.

I have several digital files—mostly PDFs and Word documents—that contain a mix of numbers and text. I need everything transferred accurately into Excel and organised as clean, structured tables. Each table must have clear, consistent headers so the sheet is ready for sorting, filtering, and further analysis the moment you hand it back. Please keep cell formatting tidy, use native Excel tables (so the headers stay locked in place), and double-check that every numeric figure and text entry matches the source. Deliverables: • One Excel workbook with separate, well-named sheets for each source file • All data entered in official Excel table format, with headers applied • Quick rundown of any data you could not decipher or confirm If you’re comfortable w...

I have several raw data files that need to be transferred into a single, well-organised Excel workbook. Your first step will be to enter the information accurately, align the columns to a consistent structure, and label every header clearly so future updates are straightforward. Once the data is in place, I’d like the sheet to look clean and professional. That means readable fonts, sensible column widths, and colour or conditional cues wherever they make the numbers easier to scan. If you see opportunities to introduce simple formulas, named ranges, or validation rules that prevent typing errors, feel free to suggest them—I’m interested in anything that keeps the file tidy and reduces manual rework. Deliverables • A fully populated, logically structured Excel workb...

I need a machine-scraped contact database for Romanian companies operating in five clearly defined sectors: design offices & architects, locksmithing & metalworking, electrical installations, stonemasons, and carpentry. Each record must contain exactly three fields—company name, phone number, and email address—delivered in a single Excel file. Feel free to pull the information from company websites, reputable business directories, and social-media business pages; those three sources together should give the breadth I’m after. A basic validation of phone numbers and email syntax is enough, as long as obvious bounces or malformed entries are removed. Volume is critical. I expect several thousand, ideally tens of thousands, of unique records overall. When you respo...

I keep a growing list of clients and need every record kept accurate and tidy in a single Excel workbook. You will manually browse the specified website, copy each client’s number along with all available contact information, and paste that data into the matching columns of the sheet I provide. Accuracy is more important than speed because this is strictly a manual data-entry task—no scraping tools or APIs this time. I will supply the site link, the template Excel file, and a short set of naming conventions so everything stays uniform. As new names appear online, you will add them; if any entry changes, you will update it rather than duplicating. Deliverables • Updated Excel workbook containing every client number and complete contact details, checked for duplicates ...

I need all of my current figures ­– income and expenses, individual departmental budgets, and several project-level budgets – transferred into a single, well-organised Excel workbook. The source data is already collected; what’s missing is a clean, accurate entry and a structure that makes analysis easy. I’m undecided on the exact template, so I’d like you to weigh in. If an existing industry-standard layout suits the data, great; if a custom sheet with dynamic formulas, drop-downs and clear categorisation would work better, let’s build that instead. Either way, totals must reconcile, categories need to be intuitive, and the file should be ready for monthly updates without breaking any links or formulas. Deliverables: • An Excel file contain...

I have a set of operational-expense figures already captured in an Excel spreadsheet that now need to be transferred into my master budget-tracking file with complete accuracy. The task is straightforward: take each row from the source sheet, verify the numbers, and enter them into the appropriate cost centres and period columns in the destination workbook. Because these are purely operating costs, I need the chart-of-accounts coding kept intact so our month-end reporting flows without manual fixes. Consistency in date formats, currency symbols, and decimal precision is critical; a single misplaced digit throws the whole variance analysis off. You’ll receive: • The source Excel file with all original entries. • A blank copy of the budget template that mirrors our ac...

I have a PDF made up exclusively of neatly structured tables and I need every row and column moved into Excel with absolute fidelity. Because the table layout never changes from page to page, the job is straightforward in terms of mapping—but the resulting workbook must be more than a copy-and-paste. Key requirements • Each PDF table goes into its own worksheet, preserving original column order and headings. • Apply clear data-validation rules (e.g., drop-downs where the source file shows fixed choices, numeric limits for quantity fields, and date pickers for any date columns). • Match source formatting: header shading, bold totals, and any merged cells that exist in the PDF. • Final file must open error-free in the current versions of Excel for both Wi...

I have a sizeable Excel spreadsheet filled with mixed text and numeric fields that now needs a thorough clean-up before it can be analysed with confidence. The work involves removing duplicates, correcting obvious entry errors, standardising formats (dates, currencies, phone numbers), and applying clear filters so the file can be sliced and queried without glitches. Once everything is tidy I’d also like a brief sanity-check analysis—pivot tables or simple summaries are fine—so we can confirm the dataset’s integrity. Deliverables • A fully cleaned, consistently formatted .xlsx file with working filters • A short change log or note that flags the main issues you fixed and any assumptions you made • A quick analytical snapshot (pivot tables or sim...

I need an Excel workbook that lets my team enter sales figures through a user-friendly form and, with one click, posts each record into a master sheet. The whole point is to make data collection painless and consistent so I can move straight into analysing sales performance later. Data validation is non-negotiable. The form must stop typos and out-of-range numbers, force date entries to the current financial year, and offer drop-downs for product SKUs and sales reps. Whether you prefer VBA, Office Scripts, or Power Automate is up to you—as long as the solution runs inside Microsoft 365 on both desktop and (ideally) the web. Deliverables • Excel workbook with built-in form and automated submission • All validation rules implemented and tested against sample sales data ...

Hi, I need a **professional Excel spreadsheet for GeetMP3 YouTube Song Management**. The main purpose is to maintain a complete and organized record of all GeetMP3 songs released on YouTube. ### Required Columns 1. Sr. No. 2. Label 3. Release Date 4. Song Name 5. Album / Project 6. Release Type – Single / Album / Movie / EP / Other 7. Singer 8. Lyricist 9. Composer 10. Music Director 11. Video Director 12. Language 13. YouTube Views 14. Video Duration 15. YouTube Link 16. Spotify 17. Apple Music 18. JioSaavn 19. Gaana 20. Remarks ### Requirements * Professional, clean and corporate design * Easy to enter, edit and update * Filters and sorting for all columns * Freeze header row * Proper date formatting * Clickable YouTube links * Dropdown menus wherever useful (especially Relea...

I manage a growing rent roll and handle lease renewals outside of PropertyMe, relying instead on a series of linked Excel spreadsheets. What I need is a detail-minded virtual assistant who can step in and keep those sheets current, ensuring every lease agreement is updated promptly and every upcoming expiration is flagged before it becomes urgent. Your core focus will be twofold: first, update lease agreements as soon as new terms are approved; second, monitor the expiration tracker so I receive a concise daily report highlighting leases that are approaching renewal. Because everything feeds into the same workbook, accuracy in data entry and version control is critical. You’ll have secure access to the existing files in OneDrive along with a brief walkthrough video of my workflow s...

I track all of my transactions in a single Excel workbook and need those figures transferred every day into a clean, well-organised register. Each entry must be sorted into clear income and expense columns and then tagged under one of my three standing categories: • Salary • Investments • Savings For every daily batch you receive, please: – enter each line exactly as it appears, preserving dates, amounts, and any notes – assign the correct category so I can filter totals instantly – double-check your work for typing or placement errors before saving Deliverables are simply the updated file returned to me by the end of each day, ready for the next morning’s review. Consistency and accuracy matter more than speed, but I still expect a re...

I have multiple Excel workbooks that hold our organisation’s budget reports and I need every line of that financial data re-entered with perfect accuracy. Your task is to take each source sheet, capture every figure and description exactly as it appears, and place it into a single, clean master file that I will supply. Because these are budget reports, totals must reconcile once your entry is complete; I will be cross-checking formulas, so attention to detail is critical. No formatting surprises—I want consistent column order, date formats, and currency symbols throughout. Deliverable acceptance will be based on: • 100 % of rows present with no transcription errors • Column headings and cell formats matching the template I provide • Final file returne...

I have multiple Excel workbooks that hold our organisation’s budget reports and I need every line of that financial data re-entered with perfect accuracy. Your task is to take each source sheet, capture every figure and description exactly as it appears, and place it into a single, clean master file that I will supply. Because these are budget reports, totals must reconcile once your entry is complete; I will be cross-checking formulas, so attention to detail is critical. No formatting surprises—I want consistent column order, date formats, and currency symbols throughout. Deliverable acceptance will be based on: • 100 % of rows present with no transcription errors • Column headings and cell formats matching the template I provide • Final file returne...

I have a raw list of about 10,000 phone numbers that needs to live in a single “Master” tab inside Google Sheets. From there, every time I type a note in the Call Notes column, that row must instantly surface in one of three working tabs: • Reattempt – when the note contains “did not answer” • Alternate Method – when the note contains “did not want our services” • Follow-Up – when the note contains “interested” The logic has to be dynamic because notes will be entered manually, row by row, as the calling team works. I don’t want to copy-paste or run a filter each time; the sheet should recognise the text string and show the record in the correct tab automatically while always preserving the fu...

I need a polished, print-ready GST invoice built entirely on a single Excel sheet for my retail business. The file must let me drop in my company logo and display all contact details and GSTIN in the header. An itemised table should follow, with formulas that automatically apply the correct GST rate and split CGST/SGST (or IGST) before showing line totals and the overall grand total. Below the financials, reserve space for my standard payment terms and conditions, then finish with a clearly marked column where I can sign and add the company stamp. Keep the layout A4-friendly, unlocked for easy colour or font tweaks, and make sure every field recalculates as quantities or rates change. Deliverable: • One editable .xlsx file that meets the above structure and prints cleanly without ma...

I receive a fresh Excel workbook every week containing the latest investment-returns figures for multiple portfolios, and I need those numbers keyed into our master tracking file with absolute accuracy. Here’s what the job involves: • Open the weekly Excel sheets I supply and enter each data point into the corresponding tabs of my master spreadsheet. • Double-check totals, percentages and date alignment so the values match the source file exactly—no rounding errors or skipped rows. • Save and return the updated master file to me by the agreed weekly cutoff, ready for further analysis. You may use any Excel-friendly workflow that keeps the file structure intact—macros, Power Query, or plain data entry are all fine as long as the final sheet mirrors the sou...