Excel VBA Jobs

I have a batch of text-based information that needs to be transferred accurately into a clean, well-structured Excel workbook. The job is straightforward data entry—no calculations or formulas—just precise transcription and sensible column alignment so the sheet is easy to read and ready for future analysis. Here is what I need from you: • Enter all supplied text data into the appropriate Excel columns and rows. • Tidy the layout as you go—consistent fonts, header rows styled for clarity, and no blank lines or stray characters. • Double-check spelling and spacing so everything looks polished before you hand it back. When you deliver, I expect a single Excel file that mirrors my source documents perfectly and is formatted to a professional standard.

I have an Excel workbook that’s become messy over time and now needs a thorough text-format refresh. I need every cell that holds text to read consistently—no random capitalization, no stray spaces, no columns that shift out of alignment when the file is filtered or sorted. Here’s what I expect from you: • Open the file, review each worksheet, and correct all visible formatting inconsistencies. • Apply the appropriate Excel functions or Power Query steps to remove extra spaces, standardize capitalization (sentence, proper, upper, or lower case as the content demands), and ensure column alignment without altering the underlying data. • Return a polished version of the workbook along with a quick summary of the key transformations you applied so I can...

I have a spreadsheet that needs to be populated with mixed text-and-number data. Accuracy is essential, but so is presentation—I already have a layout in mind and want the finished sheet to follow that structure precisely (column widths, date and currency formats, consistent fonts, conditional colour bands, etc.). Your task is to take the raw information I send, key it into Excel, and apply the specified formatting as you go so that the file is immediately client-ready. If simple formulas or data-validation rules help keep everything clean, feel free to add them; otherwise, straight data entry with the agreed-upon styling is all that’s required. Deliverable • One Excel workbook fully filled and formatted exactly to the reference sample I provide, with no stray charac...

I need an Excel workbook set up for straightforward data analysis. The core of the job is to structure my raw data clearly, apply the right formulas where useful, and summarise everything with well-designed pivot tables so I can slice the information fast without extra clicks. Once I send the dataset, configure the sheet so new rows dropped into the source table automatically flow through to the pivots. Clean headings, consistent data types, and no hard-coding in the calculations are essential. Deliverables • Final .xlsx file with fully functional pivot tables linked to a neatly formatted source table • Brief in-sheet notes explaining any key formulas or settings If you prefer using Power Query or a light VBA macro to keep the refresh seamless, feel free to suggest it&mdas...

I'm seeking an Excel expert to help me create comprehensive reports. Key Requirements: - Proficiency in Excel, especially in report generation. - Experience with financial, sales, or inventory reports. - Skills in charts, pivot tables, and conditional formatting. Ideal Skills and Experience: - Advanced Excel knowledge - Experience with data visualization - Strong analytical skills - Attention to detail and accuracy Please provide samples of previous work and relevant experience.

I have a series of raw Excel spreadsheets that I use strictly for record keeping, but right now they are messy and hard to read. I need you to step in and turn them into a clean, well-structured workbook. You’ll receive the data already in .xlsx format, so your first task is to apply the usual housekeeping: remove duplicates, correct any obvious alignment or text issues, and make sure each column has an appropriate data type. From there, I want the sheets sorted and filtered logically so I can locate information quickly—basic formulas such as SUM, AVERAGE, COUNTIF, or simple look-ups are enough for my needs. Once the data is tidy, convert key ranges into properly named tables; this is important because I rely on structured references later. If you see a spot where a small, ...

I have an Excel workbook that contains several thousand rows of raw data. The core issue is inconsistent text formatting—capitalisation varies, extra spaces appear, and some entries include stray symbols that break downstream look-ups and reports. Your job is to correct those text fields so every cell follows the same, clearly documented pattern. What I will provide • The original .xlsx file • A short style guide that shows how each column should read (e.g., “Title Case with no trailing spaces”) What I expect back • The same workbook returned with all text fields cleaned and validated—no broken formulas, no hidden characters, no mismatched encodings • A brief change log or summary sheet explaining the main fixes you applied so I can a...

I have a set of CSV files that hold purely numerical fields, and I need every value placed into a clean Excel workbook with the formatting still recognised as numbers. No extra calculations or text parsing—just an accurate, reliable transfer. A reusable method is important. If a concise VBA macro, Power Query routine, or a short Python script using pandas / openpyxl can automate the process, include it along with concise guidance. The final file must open error-free in the latest desktop version of Excel and display each column as true numerical data, with headers preserved (or created from the first row where they are missing) and sensible column widths for quick review. Deliverables • Populated Excel workbook. • Transfer script or macro, fully commented. • A ...

I have a PDF document that must look and feel identical once it lives in Excel. Every column width, row height, font style, border, and color should mirror the source so that a quick side-by-side comparison shows no visual difference. I do not need formulas—this is purely about presentation—but I do need the file to remain editable afterward. Please bring in only those images that add meaning to the sheet and discard the decorative ones; if an image clarifies data or serves as a header or logo, keep it in the same position and scale. All pages and sections deserve the same level of care, so work through the PDF sequentially instead of prioritizing any single area. Deliverable: • One Excel workbook (.xlsx) that faithfully reproduces the entire PDF layout, with relevant ...

I have an Excel file containing more than 5000 customer records that need to be added to Viber. I don’t just want one large broadcast list—I need these contacts neatly segmented into multiple groups so future messaging remains targeted and manageable. Here’s what I’m after: • Cleanly import every entry from the Excel file into Viber without triggering number-block issues or spam flags. • Create and name the groups based on criteria we agree on (e.g., location, purchase history, or any other filters you recommend). • Provide a repeatable method—whether that’s a step-by-step guide, a small script, or automation using the Viber API/desktop tools—so I can run future imports on my own. • Verify that each group shows the correc...

I have a raw Excel workbook that needs a careful sweep before it can be used for reporting. The file holds a few thousand rows spread across several sheets and currently suffers from duplicate records, inconsistent date and number formats, scattered blank cells, and a patchwork of column names. Your job is to transform this messy source into a single, tidy .xlsx file that is ready for analysis. Standard Excel tools—filters, conditional formatting, VLOOKUP/XLOOKUP, PivotTables, data validation, and simple formulas—should be all you need; no macros or external add-ins are required. Deliverables • One consolidated, fully cleaned Excel workbook • A short “change log” sheet noting what you removed, merged, or reformatted • Optional: a brief note with...

I need a tidy, well-formatted Microsoft Excel workbook built with up to five separate sheets, each populated with text records that I will supply—every record includes a person or company name and a full mailing address. Your job is simple but must be flawless: transfer the information exactly as shown in the source documents, keep the spelling and line breaks intact, and place each field in its proper column so the file is instantly searchable and ready for mail-merge use. To keep things consistent, I will send you a template that shows the column headers I need (Name, Street, City, State/Province, ZIP/Postal Code, Country). Please stick to that layout, avoid merged cells, and apply the same basic formatting on every sheet. Deliverable: • One Excel (.xlsx) file containing 1...

Sales & Profitability Dashboard — Project Description Overview An interactive Excel-based dashboard that consolidates raw sales transaction data into real-time KPIs, breakdowns, and visualizations for tracking revenue, cost, and profitability performance across regions, product categories, time periods, and sales reps. Objective To give sales and finance stakeholders a single, self-updating view of business performance — eliminating manual pivot-table building and enabling faster, data-driven decisions on where revenue and margin are strongest or weakest. Key Features Live transaction table — a structured Excel Table capturing Date, Region, Category, Product, Sales Rep, Units Sold, Unit Price, and Unit Cost, with Revenue, COGS, Gross Profit, and Margin % calculate...

I’m working with a single .xlsx file that holds all of my raw sales transactions and I need it turned into an insightful workbook in just three days. The core of the job is to build robust pivot tables that summarise performance by product, by month, and—importantly—by region, with the spotlight on India. Because I don’t have any existing templates, you’re free to design the layout, colour scheme, and overall flow of the dashboard from scratch. The visuals should rely primarily on bar charts so that trends and comparisons are instantly clear. Please add slicer or timeline filters so I can toggle months, products, and regions without touching the underlying data. I also need a concise monthly summary sheet that pulls key KPIs straight from the pivots. Deliver...

I need an Excel-based quotation template for my aluminium windows and doors manufacturing business. The template should include: - Itemized product list - Pricing breakdown - Terms and conditions - Glass details - Fabrication cost - Installation cost Ideal skills and experience: - Proficiency in Excel - Experience with quotation templates - Understanding of manufacturing and installation cost breakdowns

I have a set of Excel workbooks that need a smarter layer of automation. Your job is to weave in solid, intermediate-level formulas—VLOOKUP, nested IF statements, and similar functions—to turn raw data into information I can slice and present quickly. Alongside the formulas, I need reliable data sorting and filtering controls as well as conditional formatting rules that instantly flag exceptions and trends. The focus is on clear, maintainable solutions; no VBA or complex array formulas are necessary. Deliverables: • Updated .xlsx file(s) with all new formulas, sorting/filtering views, and conditional formats in place • A concise in-sheet note or README explaining the logic so I can update it later I’ll share the current workbook as soon as we start and will...

I have several very large spreadsheets that need to be audited, cleaned, and uniformly formatted. The job revolves around identifying and fixing discrepancies quickly while keeping every entry accurate. You’ll be diving into thousands of rows, using VLOOKUP, XLOOKUP, and any other advanced functions you find useful to reconcile records, highlight mismatches, and verify totals. I care a lot about proper formatting—leading zeros must stay intact, text-to-number issues have to be resolved, and custom field structures need to remain consistent from sheet to sheet. Throughout the process I expect frequent spot-checks to confirm that formulas are returning the correct values and that no data has been lost or overwritten. Deliverables: • One consolidated, fully audited work...

I need an Excel-based auto quotation maker that generates both product and service quotations. Requirements: - Generate quotations in Excel format. - Include: - Client details - Itemized list with prices - Payment terms Ideal Skills and Experience: - Proficient in Excel - Experience in designing automated quotation systems - Attention to detail and accuracy

I’d like my current Excel rota transformed into a clean, automated workbook that practically manages itself. Right now dates are out of order and shifts run together; I need everything sorted chronologically with each shift clearly separated so I can scan the week in seconds. The file must keep one critical data point—employee names—at its core, because every formula will rely on that. As soon as I enter a start and end time I want the sheet to calculate the shift length and each employee’s running monthly total automatically. If two people accidentally overlap or a shift doubles up, conditional formatting should light it up straight away. Presentation matters too. Please apply a single, professional font across the workbook; beyond that I’m not fussy about ...

I’m working with an Excel rota that has become unwieldy and hard to trust. I need you to reorganise it so every working day appears in chronological order, start- and finish-time columns calculate shift length automatically, and monthly hour totals are ready at a glance. Please separate the data by shifts (not by clients or locations) so each type of shift is simple to scan and edit. Because I frequently adjust start or finish times, all totals must update instantly through robust formulas, not manual entry. A key requirement is highlighting any scheduling conflicts; the moment two shifts clash I want clear conditional-formatting alerts so I can spot and fix issues right away. While you’re streamlining the layout, keep the original information intact—just tidy th...

I have between one and five CSV files containing purely text fields that I want moved into a single, well-structured Excel workbook. While the move itself is straightforward, I also need basic cleaning carried out along the way—think trimming leading/trailing spaces, normalising simple text inconsistencies, removing blank rows, and ensuring each column retains a consistent header. Once the import and tidy-up are finished, please deliver the final .xlsx file with the cleaned data sitting on clearly named worksheet tabs (one tab per source file is fine). I would also appreciate a short note describing any issues you spotted and the steps you took to correct them so I have a quick audit trail for future reference. If you work comfortably with Excel formulas, Power Query, or similar to...