Visual Basic Jobs

We are expanding my operations team and need a full-time data entry clerk who can work remotely with very little hand-holding. Day to day you’ll be inside our customer account database keying in, verifying, and updating financial data that feeds directly into our reporting dashboards. Accuracy is critical; a single typo can throw off the month-end numbers, so I need someone who naturally double-checks their own work and spots inconsistencies quickly. Microsoft Excel will be your primary tool—everything from basic formatting to VLOOKUPs and pivot tables for cross-checks. If you already have at least two years of dedicated data entry experience and feel comfortable juggling multiple spreadsheets while meeting daily deadlines, you’ll fit right in. Beyond routine entry, I&r...

I have a set of Excel spreadsheets that contain only text fields needing orderly transfer into our central database. Every cell must be copied exactly as shown, preserving line breaks, punctuation, and any special characters. The files are already well-structured, so accuracy and speed are my priorities rather than complex formatting or formula work. You’ll receive the spreadsheets through a shared drive, and I’d like the completed dataset returned as a single, clean CSV file. A quick turnaround and zero‐error output will be the key markers of success.

I have a list of online sources that contain both narrative text and numeric figures, and I need every one of those details captured in a single, well-structured Excel workbook. The job begins with careful data entry: copy each text field, metric, date, or code exactly as it appears on the web page and paste (or import) it into the template I will provide. Because the information is mixed data—words and numbers side by side—consistent formatting, proper column alignment, and vigilant error-checking are essential. Once the raw information is entered, the spreadsheet has to become an analysis tool. Please set up the formulas that calculate totals, averages, and any other basic statistics we agree on, then create clear charts or graphs that visualise the key results. Think of it ...

I keep my sales records in a Microsoft Excel workbook and need someone reliable to add the day’s sales amount to the correct tab every evening. The file is already set up with clear date rows; you’ll simply open the spreadsheet, locate today’s row, type in the total sales figure I provide, and save the file back to our shared folder. Accuracy matters more than speed, but the update must be completed the same day you receive the number so my dashboards stay current. A quick double-check before saving is all it usually takes to prevent slip-ups. If you know your way around basic Excel functions—filters, sum checks, and the like—you’ll have no trouble. Deliverable • Updated Excel sheet reflecting each calendar day’s sales amount, saved by...

I need a tidy, idiot-proof Google Sheets setup that lets me record every sale we make at our events and immediately see how that affects current stock levels. All data will be entered by one person, so there’s no requirement for multi-user permissions or automated feeds—just a clear, well-structured place for manual inputs that keeps the numbers accurate. Here’s how I picture it working: • A single “Sales Log” tab with data-validation drop-downs for product names, event dates, and payment types, plus protected formulas that calculate quantity sold, total value, and running stock on hand. • A master “Inventory” tab that holds opening stock figures; the Sales Log should reference this in real time so I can spot shortages as soon as the ...

I need a robust yet easy-to-maintain Excel workbook (Office 365) that holds my full annual budget, then pulls in Simplifi monthly actuals via the CSV files the app exports. Once the file is dropped in, I want the sheet to refresh and immediately show me how my Income and Expenses are tracking against plan, both month-by-month and year-to-date. You can take advantage of Office 365 tools such as Power Query, dynamic arrays, PivotTables, slicers, or whatever you feel delivers the cleanest solution, as long as I’m left with a single file I can use without any extra add-ins. Deliverables: • An unlocked Excel workbook with: – a clear input area for my annual budget figures – a simple “Import CSV” or “Refresh” action that loads the Simplifi...

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

excel sheeet making and data entry

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 a growing set of Excel workbooks that must be transferred into a MySQL database on a repeating schedule. The workflow I need is straightforward: read each new or updated workbook, validate the data, then load it into the correct tables without duplicates or broken references. Because these files arrive on a timetable, the import script or utility should run automatically— for example via cron, Windows Task Scheduler, or any scheduling feature you prefer—so there is no manual trigger required once everything is in place. Robust error logging is important; if a row fails validation, I want a clear report so it can be corrected before the next run. Deliverables • A script, small application, or stored procedure that connects to MySQL, parses the Excel files, and ...

I have between one and five Excel spreadsheets that hold a mixture of numbers and text. Your job is to move every piece of information into the consolidated worksheet I will supply, keeping the original structure intact and double-checking for accuracy as you go. The work is entirely in Excel, so you should be comfortable with basic formulas, filters, and quick validation techniques to spot missed rows, transposed digits, or stray characters. A light touch on formatting—consistent dates, aligned text, clear numeric precision—will make the final file ready for immediate use in our reporting workflow. Deliverables • A single, cleaned master workbook containing all source data • A brief note of any anomalies or assumptions made during entry The data set is s...

I have a batch of mixed text-and-number records pulled from several online databases that must be transferred into a clean, well-structured Excel or Google Sheet. The job is straightforward but detail-oriented: copy each data point into the correct column, keep the formatting consistent, organise the rows logically, and run a basic duplicate check so the final file is error-free. Turnaround matters to me, so I’m looking for someone who can move quickly without sacrificing precision. Familiarity with Excel functions—especially sort, filter and conditional formatting—or the comparable features in Google Sheets will help you spot and resolve issues fast. If you notice obvious anomalies while you work, flag them and I’ll clarify right away; open communication will ke...

I have a stream of operational and campaign data that must be turned into clear, automated business-reporting dashboards inside Excel. The core of the job is to use advanced Excel programming—formulas, VBA, or Power Query, whichever you prefer—to pull raw tables, clean them, and generate weekly summary reports that management can read at a glance. Alongside the technical build, I also want the reports to feed directly into ongoing marketing decisions, so an eye for marketing metrics and the ability to suggest small optimisation tweaks will be valued. Think of it as equal parts data-driven programming and practical marketing insight. Key deliverables • A fully automated Excel workbook that refreshes on demand and outputs management-ready business reports. • Short...

I have a single plain-text (.txt) file that I need reproduced in Microsoft Excel. No processing, re-ordering, or cleaning is required—every character must appear exactly as it does in the source. All content should reside on one worksheet; no additional tabs or formatting tweaks are necessary. You will receive the text file once we begin. Simply paste or import the data, preserve original line breaks and spacing, save the workbook as .xlsx, and return it. I’ll verify by comparing the two files side by side, so accuracy is essential. A quick turnaround is appreciated; let me know how soon you can deliver the completed Excel file.

I have several PDF and Word files that contain plain text tables and paragraphs which I need reorganised inside a clean .xlsx workbook. The data must be split across multiple sheets in a logical way—think one sheet per chapter, category, or section header that appears in the original documents. I will provide the source files and let you know the exact sheet names I want; beyond that, your job is to copy every character accurately, preserve basic formatting where it makes sense (dates, currency, percentages), and double-check for typos introduced during the transfer. Deliverables • One polished .xlsx workbook with the agreed-upon sheet structure • A quick summary sheet noting any ambiguities you discovered and how you handled them Before you return the file, please ...

I have a collection of PDF files that contain tabular data I need organised cleanly in an Excel workbook. The task is straightforward: locate every table inside each PDF, transfer the information into Excel, and preserve the original row-and-column structure so formulas or pivot tables can be applied immediately after import. Accuracy is more important than speed; numbers, dates, and text labels must match the source exactly, and headers should be kept intact. If any table spans multiple PDF pages, please merge it seamlessly in the spreadsheet. I will provide the PDFs and indicate the preferred sheet order once the project starts, and I’m happy to review a sample file first to confirm the layout before you proceed with the rest. Final deliverable: a single .xlsx file containing one...

I’m looking to streamline a set of financial spreadsheets by introducing reliable, well-structured macros. The files contain strictly financial data—no customer or inventory information—so the code must handle numbers, formulas, and summary reports with speed and accuracy. Here’s what I need: • A macro-enabled workbook (.xlsm) that performs the repetitive steps I currently execute by hand: importing monthly figures, cleaning and reformatting them, updating consolidated sheets, and producing a printable summary. • Clear, in-cell or separate comments so I can follow the logic and maintain it later. • Brief usage notes explaining any buttons or shortcut keys you add. Acceptance criteria: 1. One-click execution completes without errors on Excel 2019...

I have a batch of mixed text-and-number records pulled from several online databases that must be transferred into a clean, well-structured Excel or Google Sheet. The job is straightforward but detail-oriented: copy each data point into the correct column, keep the formatting consistent, organise the rows logically, and run a basic duplicate check so the final file is error-free. Turnaround matters to me, so I’m looking for someone who can move quickly without sacrificing precision. Familiarity with Excel functions—especially sort, filter and conditional formatting—or the comparable features in Google Sheets will help you spot and resolve issues fast. If you notice obvious anomalies while you work, flag them and I’ll clarify right away; open communication will ke...

Using , I need a comprehensive extraction of data for 100 separate locations. For every single day of the week I want the raw numbers for foot traffic and dwell time pulled, then organised in one clear Excel workbook. Inside that same workbook please add a concise summary section for each site that shows: • Average foot traffic • Average dwell time • Peak traffic hours Label everything intuitively—location name, date, day of week—and keep formulas visible so I can audit or update the figures later. If you already have scripts or a repeatable workflow; speed and accuracy are both important.

I have script for video and I want to make a animated with recorded video , that I want to turn into polished social-media-style content for my YouTube channel. I’ll supply the raw footage, any screen-captures, and reference assets; your task is to shape it into an engaging final cut that feels crisp, professional, and platform-ready. Core tasks include trimming and sequencing the clips, cleaning up audio, adding smooth transitions, light colour correction, on-screen text or lower thirds where helpful, and exporting in 1080p (or higher if you prefer) so I can publish immediately. If you work in Premiere Pro, Final Cut, or DaVinci Resolve, please send the project file as well—this lets me make small tweaks later. I’m aiming for a pace that keeps viewers watching yet stil...

I have a set of text records that need to be transferred into a clean, well-structured Excel workbook. The information will be provided for you to type in manually—no imports, scripts, or copy-paste shortcuts this time, just careful keystrokes to keep everything accurate and consistently formatted. What I will hand over: • The source text in clearly labeled documents • A simple template (.xlsx) showing the exact column order and any required headings What I’d like back: • The same template returned with every row filled, spell-checked, and double-verified • A quick note highlighting any unclear entries or duplicates you spot while typing If you’re detail-oriented and comfortable spending focused hours inside Excel, this should be a straightforwa...

I'm looking for a reliable and detail-oriented professional who can assist with large-scale data entry tasks. Your primary responsibilities will be: - Cleaning and formatting data across multiple Excel sheets, ensuring no data is lost in the process and it's organized for easy access. - Verifying and validating the cleaned data to ensure accuracy. - No need to worry about complex formulas or functions, this task doesn't require it. The ideal candidate will have a strong background in data entry, be comfortable navigating numerous Excel sheets and have a keen eye for details. Experience with data validation and verification will also be highly regarded. There are more than 10 worksheets that require attention.

I have a collection of Word documents that contain only text, and I need every piece of that content moved into an Excel workbook while keeping the original formatting exactly intact. Paragraph breaks, bullet points, bold or italic emphasis—whatever is on the page now must look the same once it lands in the spreadsheet. You will receive the Word files as soon as we start. Your job is to create or populate an Excel file so that: • Each document’s text sits in its own clearly-labeled sheet (or in designated columns/rows if you have a better layout idea). • All formatting remains preserved; no auto-stripping to plain text. • The final workbook opens cleanly in the latest Microsoft 365 desktop version without warning dialogs or broken styling. Feel free to use...

I need an experienced Excel specialist to build a polished sales report that pulls together total sales figures in a clear, decision-ready format. The raw data will come to you in spreadsheet form, and I’d like you to transform it into an easy-to-read report using advanced formulas, pivot tables, and, where helpful, charts or conditional formatting. My priority is accuracy and a layout that lets managers grasp overall performance at a glance. If you prefer Power Query, Power Pivot, or VBA to streamline the workflow, feel free to incorporate them—just keep the final file self-contained so any user can refresh the numbers without extra add-ins. Deliverable: one Excel workbook that includes the cleaned data, automated calculations for total sales, and a well-formatted summar...

I have a collection of Excel and CSV files that contain strictly numeric information. Your job is to open each file, transfer the numbers exactly as they appear into the template I provide, and save the completed sheet in the same format. Accuracy is critical—I’ll be spot-checking totals and cell positions—so you’ll need good command of Excel or Google Sheets functions such as copy-paste-special, basic formulas, and quick validation tricks. I’ll share a concise set of column-by-column instructions plus a small sample first; once that’s approved, you can move on to the full batch. The final deliverable is the populated template returned with every value verified and any irregularities noted in a separate comments tab. If you’re comfortable wit...

I need an extra pair of hands for ongoing data processing work. Your main focus will be taking raw data I supply—spreadsheets, CSVs, or occasional PDFs—and turning it into clean, well-structured tables ready for analysis or upload to our internal tools. Accuracy and consistency matter more to me than speed, but prompt delivery is still important because the information feeds directly into daily reports. Here is what you can expect once we start: I will share a sample data set plus clear formatting rules. You process it, return the finished file, and if everything matches the rules (no missing rows, correct column order, validated totals), we move on to the next batch. I handle quality checks within 24 hours and give feedback right away so you always know where you stand. Plea...

I have a spreadsheet ready and need my mixed dataset transferred into it with absolute accuracy. The numeric figures will come to you as digital files, while the accompanying commentary and labels are written in clear-hand handwriting. Your task is to key everything into the correct rows and columns, verify that totals still add up after entry, and return a clean, well-formatted Excel file. Because this is a straightforward data-entry project, I welcome detail-oriented newcomers who want to earn their first review—just show me you can meet the standards below. Deliverable • Completed Excel workbook with every numeric value and handwritten note entered exactly as supplied, no spelling or calculation errors.

I have a spreadsheet of purely numerical records that needs to be put into a clean, analysis-ready state. The core task is to correct every formatting issue—numbers stored as text, misplaced thousand separators, mixed decimal symbols, stray spaces, hidden characters—so each cell ends up as a true numeric value that Excel can calculate with no errors or warnings. Once the data is standardised, simply return it to me in the same structure (or a clearly documented new sheet if you think that is safer). No deduplication or gap-filling is required this time; the sole focus is formatting accuracy. Acceptance criteria • Every entry recognised by Excel as a number (green triangle errors eliminated). • Consistent decimal and thousand separators across the file. &bull...

I'm seeking an experienced Power Automate developer to recreate Automation Anywhere RPA processes, primarily using SAP connectors. Key tasks include: - Automating data entry, report generation, and workflow management. - Handling customer data: extracting and updating. Ideal skills and experience: - Proficiency in Power Automate and SAP connectors. - Strong background in RPA tools. - Experience with data extraction and updates. - Ability to streamline workflows and enhance efficiency. Looking for a detail-oriented freelancer to ensure smooth automation and data accuracy.

I will hand you a neatly structured Excel/Google Sheets file and I need you to turn its numbers into story-driven visuals. The focus is on comparing up to three key categories, so the charts must make those differences pop at a glance. You’ll work inside the same workbook—no extra data gathering—and build a concise suite of bar, line and pie charts. Each visual should carry consistent colours, clear labels, legible axes and dynamic ranges so the graphic updates automatically when the data changes. The sheet itself should remain clean and intuitive: frozen headers where useful, painless navigation, zero clutter. What I expect: • The original file returned with professionally formatted bar, line and pie charts placed beside or on a dedicated dashboard tab. &b...

I need a single Excel workbook that runs like a mini-app for my personal-training clients. As soon as I open it, I want to land on a clean dashboard that pulls each client’s name, their SMART goal summary, PAR-Q status, and—as selected—session notes, any adaptations I’ve logged, and automatically generated progress charts. Inside the file: • Exercise Programme – A drop-down driven sheet where I pick “Warm-up, Cardio, Strength, Cool-down or Stretching” and the exercise list instantly populates from a master exercise library you’ll set up for me. I’ll fill in or adjust weight, reps, time, or calories and the sheet should feed those numbers into calorie-burn calculations that compare against each client’s BMR and daily cal...

Our financial information needs to move from scattered files into one reliable Excel environment. The job starts with disciplined data entry and organisation: every transaction must be imported, cleaned, categorised and dated so the workbook stays audit-ready. With the raw data stable, bespoke report templates are required. I presently have no usable formats, so fresh, professional-looking Profit & Loss, Cash-Flow and Balance-Sheet layouts must be built from scratch. Dynamic formulas, pivot tables, charts or Power Query are all welcome as long as the numbers update automatically when new rows are added. The final step is forward-looking insight. Using the newly structured history, create an analysis and forecasting sheet that projects at least the next twelve months and lets me a...

I have raw sales data coming in regularly and I want a single Excel file that turns those numbers into insight without any manual number-crunching from me. The sheet should focus exclusively on analysis: • Highlight sales trends over time so I can see seasonal spikes or dips at a glance. • Compare product performance side-by-side to reveal my best- and worst-selling items. • Uncover customer purchasing patterns that might inform promotions or loyalty offers. I’d like this insight presented visually. Please build clear, well-labeled charts and an interactive dashboard inside the workbook so I can filter by date range, product line, or customer segment and have everything update automatically. I don’t need invoice generation or basic sales tracking featur...

I have a small window—just two days—to pull my handwritten / PDF records into a clean, reusable Excel file. The file will contain two separate worksheets: • An invoice template that already has fields for customer details, an item-by-item product list, and clear payment terms. All I should have to do is drop in the numbers and hit print or save to PDF. • A sales tracker that accepts the same source data (sales figures, customer information, product details) and automatically calculates both total sales and the percentage growth over time. The summation and growth-rate formulas need to be locked in so totals update the moment new rows are added. I will supply the raw notes and scans; you turn them into a polished workbook ready for daily use. Accuracy of the formula...

I need a system to record and email work scores at shift end. Requirements: - Use Excel for scoresheet - Record quantitative scores - Aggregate data with typed results and totals per subcategory - Email results to designated address after each shift Ideal Skills: - Proficiency in Excel - Experience with data aggregation and automation - Reliable and detail-oriented

I have a collection of text-based records that need to be transferred into both MS Excel and Google Sheets with absolute accuracy. Your first task will be straight-forward data entry: copy the supplied text data into the correct columns, apply consistent formatting, and double-check that nothing is missed. Once everything is in place, I’d like you to add helpful formulas—think look-ups, CONCAT, LEN checks, maybe a few IF statements—to make the sheet easier for me to search, filter, and maintain later on. If you see smarter ways to automate routine steps, I’m open to suggestions. There’s no hard deadline, so you can focus on getting each sheet perfectly clean and fully functional. Please share a brief sample of similar work or a short demo file so I can see...

I have a batch of PDFs that all share the same form-style layout. Each file contains text fields—names, dates, IDs, a handful of numeric values—and I need every field copied accurately into an Excel workbook. Because the structure never changes from one PDF to the next, the task can be fully automated; I am open to Python (PyPDF2, pdfplumber, Camelot), VBA, or any other reliable tool you prefer, as long as the end result is a clean .xlsx file with one row per PDF and clearly labeled columns matching every original field. Deliverables • A script or repeatable workflow that reads each PDF and exports the data. • An initial run showing at least 10 sample PDFs mapped correctly in Excel. • Brief instructions so I can rerun the extraction when new files arrive. ...

I need a clean, easy-to-navigate Excel workbook that lets me manage patient records from the moment they walk in. The sheet has one clear job: efficient patient records management. Everything must be organized so I can instantly filter, sort, or report on each visit by its date. Please structure the workbook so each new entry is automatically grouped by the date of visit, making it simple for me to review any given day’s caseload or run time-based summaries. A dashboard or pivot that pulls totals by date is welcome if it keeps things intuitive. The core data I must capture is straightforward: • Personal information (name, age, address) • Medical history and diagnoses • Current medications and treatments Lay these fields out so data entry feels natural—t...

I need a single workbook in Excel 2013 that will let me track 50-100 different stock items across six locations and one master sheet. Each sheet must share the same first column (Item Description), followed by Opening Stock, Stock In, Calculated Total (Opening + In), Stock Out, and Closing Stock (Total – Out). Whenever I add or remove an item on any sheet it must instantly appear, in the same order, on every other sheet. Here’s the twist: any quantity I record as “Stock Out” on one of the six secondary sheets should automatically roll up as “Stock In” on the master sheet for that same item. At the end of each day the Closing Stock on every sheet becomes the next day’s Opening Stock; I will type the daily movements manually, so an easy “new d...

An Excel file with several thousand rows needs a quick but thorough format overhaul. The only issue I’m facing is inconsistent data presentation—no duplicate removal or missing-value work is required. Here’s what I need: • Dates and times must all follow a single, clean standard (e.g., YYYY-MM-DD). Some cells currently mix slashes, dashes, and regional order, so the job involves detecting every variation and converting it accurately without altering the underlying values. • Text columns require tidy, uniform formatting—trimming stray spaces, fixing broken line breaks, and ensuring consistent case where appropriate—so that filtering, lookups, and pivot tables work flawlessly afterward. You may use native Excel functions, Power Query, or VBA;...

I have a batch of records that combines numbers, text strings, and the occasional special character, and I need each line entered accurately by hand into my spreadsheet template. Automated scraping or bulk-upload tools won’t suit the structure I’m working with, so the task is entirely manual. The job is straightforward: open the provided source files, follow the column order I’ll share, and key the information in exactly as shown, double-checking for typos as you go. I’ll supply a brief style guide that explains which fields must keep their original formatting, which can be normalised, and the quick validation steps I perform before signing off. When you reach out, tell me about the data entry projects you’ve tackled before—specifically ones where you ...

I need an Excel workbook that lets my employees record their own daily attendance. The sheet should capture only two data points for each person—Check-in and Check-out times—and store them in a clean, easy-to-navigate table. Because the attendance will be marked “By students themselves,” I want a user-friendly, self-service layout: visible input cells, protected formulas or headers, and clear date navigation so nobody overwrites another day by mistake. Simple conditional formatting that flags missing entries would be helpful, but the core priority is a ready-to-use template where staff open the file, pick the current date (or land on it automatically), type their times, and save. Please deliver the finished .xlsx file plus a brief note (or short sheet) explaining ...

I have an Excel workbook where every date column is a mess of mixed-up formats. Nothing is missing; the problem is strictly that the existing entries are stored in multiple, incorrect styles. I need each of those values converted and locked into the DD/MM/YYYY format across the entire file. You’re free to use the method you prefer—formulas, Power Query, a quick VBA routine—so long as the result is a clean sheet that keeps all other data exactly as it is. Deliverables • The cleaned workbook with every date shown as DD/MM/YYYY • A brief note (or commented VBA, if a macro is used) outlining the steps so I can repeat the process on future files, should the need arise

I have a PDF that consists purely of tables—no text paragraphs or images. There are fewer than ten individual tables, and I’d like each one transferred into a clean Excel workbook using standard Excel formatting (headers in the first row, consistent column widths, and basic number/text recognition—nothing custom or complex). Accuracy is crucial; I need the data captured exactly as shown, with rows and columns preserved so the sheet is ready for basic analysis the moment I open it. Please return a single .xlsx file containing all tables on separate worksheets or in one sheet if they fit logically together; whichever approach keeps the layout clear and easy to work with.

I need basic arithmetic calculations on a spreadsheet, specifically for inventory counts. Requirements: - Apply basic arithmetic (addition, subtraction) to inventory data - Use formulas that can be applied to entire columns or rows Ideal Skills & Experience: - Proficiency in spreadsheet software (Excel, Google Sheets) - Attention to detail - Experience with basic arithmetic operations in spreadsheets

I need an easy-to-update Excel workbook that produces a complete municipal rate estimate. The model has to pull together property values for residential, commercial and industrial parcels, apply current tax rates, layer in municipal services fees, and then add a separate civil engineering cost section so I can see the full picture in one place. Key deliverables: • Clearly labeled sheets for Inputs, Calculations, and Summary • Input cells for each property class with space for future growth figures • Tables that let me drop in new tax rates and services fee schedules without breaking formulas • A civil-cost worksheet that rolls up unit rates, quantities and contingencies into a single figure and feeds it to the main summary • Automatic totals showing an...

I need a clean, fully-formulated cost estimate laid out exactly in line with our municipal Schedule of Rates. The final file must be an editable Excel workbook that mirrors the official column order, item codes and measurement units so it can be dropped straight into the approval process without extra rework. Here is what I will provide once we start: • The list of work items and their respective quantities. • Any special notes or local amendments to the latest municipal SoR. What I expect back: • One Excel file with separate sheets for summary, detailed rate analysis and contingencies. • All rate entries pulled directly from the current municipal SoR, with formulas intact for easy updates. • Grand totals, taxes and overheads calculated automatically. Plea...

I have an Excel worksheet in which every text entry is stored in all-lowercase. I need that text transformed to clean, ALL UPPERCASE values throughout the file while preserving every other aspect of the sheet—cell positions, formulas, dates, and numeric data must remain untouched. Please return a new .xlsx with: • Every previously lowercase string converted to uppercase. • No broken formulas or altered cell references. • The original file name appended with “_UPPER”. A quick turnaround is appreciated, and a short note on the method you used (formula, Power Query, VBA, etc.) will help me verify repeatability in future updates.

I have a spreadsheet that mixes numbers, text strings, and codes in the same columns. Before I can move on to my analysis, every duplicate row has to go—no highlighting or moving them elsewhere, just a clean file with the repeats completely removed. You’ll work directly in Excel; Power Query, advanced filters, or any other native tools are fine as long as the end result meets these criteria: • All exact-match duplicate rows are deleted (case-insensitive for text). • Original column order, formulas, and formatting stay intact. • File is returned in the same format, plus a brief note summarising how many records you eliminated. The sheet is small enough to handle in one sitting, so once you receive the file I expect a quick turnaround. Let me know if anythin...

I need a tidy-up pass on an existing Excel workbook. Two things have to happen: 1. Every date column must have the month-and-year extracted into its own field (for example, “15/04/2024” should become “Apr-2024”). Please preserve the original date values so the sheet continues to calculate correctly. 2. Text columns contain stray leading or trailing spaces. Those spaces have to be trimmed so that look-ups and pivots work properly, while leaving all other characters intact. Feel free to use formulas, Power Query, or a lightweight VBA routine—whatever is quickest and still keeps the file fully editable in Excel 2016 or later. Send me back: • The cleaned workbook with both the original and the newly formatted columns visible • A short note (or work...