Excel VBA Jobs

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. 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. • Standardise headers, data types, currency and date formats so the sheet can feed directly into pivot tables or dashboards without further tweaks. Deliverable: a single .xlsx file returned with all conditional formatting in place...

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

I need an organised freelancer to populate an Excel workbook with a batch of text records and apply my custom formatting rules as you go. This is strictly a data-entry task—no analysis or formulas required—yet accuracy is critical because every cell must follow the style I provide (headings in Title Case, specific column widths, wrapped text, and colour-coded status flags already embedded in the template). You will receive: • A blank template (.xlsx) that already contains the conditional-formatting rules. • A folder of raw text files to copy from. Your job is simply to: 1. transfer each text snippet to its correct column; 2. confirm the formatting renders exactly as in the sample row; 3. return the completed workbook for a quick spot-check. I’m ha...

I update my product-sales workbook every evening, but the volume has grown past what I can comfortably handle alone. I’m looking for someone who can take over the daily Excel entry of all product sales that come through each day. The workflow is completely manual at the moment: I’ll send you the raw figures in a simple text or photo format, and you’ll record them in my existing Excel template. For every single sale you will capture the following: • Product name and quantity • Date and time of sale • Customer details Accuracy is more important than speed, yet I still need the file returned the same day so I can reconcile inventory and produce a quick report. If you already have solid Excel habits—data validation, consistent formatting, basic f...

I have a text-only PDF that needs to be transcribed into an Excel workbook. Every sentence from the original document should appear in its own row, keeping exactly the same formatting—bold, italic, underline, superscript, everything—so that the spreadsheet mirrors the visual emphasis of the source. Accuracy is critical: punctuation, line breaks inside sentences, and special characters must be identical to what you see in the PDF. Since the content is pure text, no table reconstruction or image handling is required; it is strictly a matter of lifting the sentences and placing them cleanly into Excel while preserving their styling. Deliverable • One .xlsx file with each sentence in a separate row, formatted precisely as in the PDF. I will run a side-by-side comparis...

I update my product-sales workbook every evening, but the volume has grown past what I can comfortably handle alone. I’m looking for someone who can take over the daily Excel entry of all product sales that come through each day. The workflow is completely manual at the moment: I’ll send you the raw figures in a simple text or photo format, and you’ll record them in my existing Excel template. For every single sale you will capture the following: • Product name and quantity • Date and time of sale • Customer details Accuracy is more important than speed, yet I still need the file returned the same day so I can reconcile inventory and produce a quick report. If you already have solid Excel habits—data validation, consistent formatting, basic f...

I have approximately 45 Excel files containing data from our old clients. I am looking for an experienced freelancer who can carefully review these files and make the required changes and updates as instructed. The work may include editing existing data, updating information, correcting entries, formatting, and making other necessary modifications while maintaining the original structure and accuracy of each Excel file. Requirements: Experience with Microsoft Excel and data management Ability to work with multiple Excel files Accurate and careful data entry/editing Maintain the existing formatting and structure where required Follow instructions precisely Keep all client data confidential Complete the work within the agreed deadline More detailed instructions and the required changes w...

I have several months of raw automotive service records that need to be transformed into reliable, presentation-ready workbooks. My immediate priority is accurate data entry and rigorous cleaning—specifically removing duplicates, correcting any formatting inconsistencies, and validating every key field for accuracy. Once the data set is trustworthy, I’ll also be moving on to the usual next steps of insightful formulas, Pivot Tables, and dashboards, so an eye for analysis will be valuable, even if the first milestone centres on cleanup. If you have worked with dealership or workshop data before, you’ll recognise the quirks these files can contain and the importance of precision when labour hours, parts numbers, and costs are involved. Experience with warranty claims or br...

I’m handing over a raw Excel workbook that needs careful data cleaning focused strictly on correcting errors. You’ll work sheet-by-sheet, hunting down typos, mis-keyed numbers, misplaced decimal points, broken formulas, inconsistent dates, and any other inaccuracies that could throw later analysis off course. I’m not asking for duplicate removal or format standardisation right now—just make sure every value that’s supposed to be numeric really is, every date registers as a valid date, and every reference or formula returns the right result. Feel free to use any Excel tools you prefer—Power Query, Find/Replace, conditional formatting, data validation rules, or simple manual fixes—as long as the final file is spotless and calculation-ready. Deliv...

Saya membutuhkan bantuan untuk memindahkan data riwayat pembelian pelanggan ke dalam satu file Excel yang rapi dan mudah dianalisis. Jumlah barisnya berada di kisaran 100 – 500, jadi kecepatan sekaligus ketelitian sangat penting. Saya belum memiliki template apa pun, jadi saya mengandalkan Anda untuk merancang tata letak yang logis—misalnya mencakup kolom tanggal transaksi, nama/ID produk, kuantitas, dan nilai pembelian—lalu mengisi seluruh data sumber persis seperti aslinya. Silakan gunakan fitur Excel yang menurut Anda paling efisien (validasi data, drop-down, rumus sederhana, atau tabel terformat) asalkan hasil akhirnya bersih dan konsisten. Deliverable tunggal saya adalah: • Satu file .xlsx berisi seluruh 100-500 entri dengan format yang sudah Anda susun,...

I have an Excel workbook that tracks every order moving through my shop. Each business day I will send you the raw updates, and I need those figures keyed straight into the correct rows and columns of that file so the status dashboard always shows the latest information. The sheet structure is locked in, formulas are already set, and I’ll share both the file and a short loom video that walks through the exact cells you’ll touch. Turnaround is same-day: once you receive the update, enter the data, double-check for obvious mistakes, save, and send the file back (or sync it to the shared folder) before close of business. Acceptance criteria • All new or changed values entered in the designated cells of the Excel workbook provided • No accidental edits to protected ...

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 need help standardising the text in an Excel workbook. Several columns are filled with names, product titles, and location fields that now appear in random mixtures of upper- and lower-case letters. Every entry should read in proper Title Case—first letter of each word capitalised and the rest in lower-case. The job is straightforward but must be done with precision. A quick PROPER() formula works for most cells, yet I also expect you to catch exceptions such as “USA”, “eBay”, or common abbreviations that shouldn’t be converted blindly. You are free to rely on formulas, Power Query, or a small VBA macro; just make sure the method is repeatable so I can apply it to future files. Deliverables • My original spreadsheet returned with every relevan...