Excel VBA Jobs

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

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 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 need an Excel dashboard to track performance metrics, specifically focusing on operational efficiency. The dashboard will be used to visualize and analyze data related to key operational efficiency metrics. The ideal candidate should have: - Expertise in Excel, including advanced functions and data visualization techniques - Experience in creating dashboards for performance metrics - Strong analytical skills to help interpret operational efficiency data Key operational efficiency metrics to include might be: - Resource utilization - Process cycle time - Error rates Please provide samples of previous Excel dashboards created.

I need specialised support on a workbook that serves as the backbone of an ongoing project. The file already contains raw figures and basic layouts, but accuracy, efficiency, and clarity still feel out of reach. Your task will centre on refining the sheet so it performs reliably—whether that means correcting structure, introducing robust formulas, streamlining data flow, or setting up clear analysis elements. I will share the full workbook and a concise list of priorities once we connect; at that point you can confirm the most efficient path forward. When you reply, please highlight previous Excel-based work that demonstrates depth of experience. Screenshots, brief case notes, or concise descriptions of similar challenges you have solved will help me gauge fit quickly.

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 need a seasoned financial modeler who can build a complete set of models that I will rely on for upcoming investment decisions. The scope covers three core components: • Discounted Cash Flow (DCF) model • Comparative company analysis model • Budgeting and forecasting model Each model must be delivered in a clean, well-structured Excel workbook with transparent formulas, clear assumptions, and a short walkthrough sheet so I can audit or tweak inputs later. Please base your proposal on your direct experience creating similar models for real-world engagements; that is the single most important factor in my selection. If you have a standard template or proprietary approach that speeds delivery while maintaining quality, feel free to highlight it. I will provide histo...

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

Please Sign Up or Login to see details.

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

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

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 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 need assistance on an Excel spreadsheet. The tasks include repairing and adding formulas, specifically for statistical analysis, as well as fixing data formatting issues. Ideal skills and experience: - Expert in Excel - Strong background in statistical analysis - Attention to detail for formatting corrections Please provide your experience and approach to similar tasks.

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

I have an existing Excel workbook that first needs to be put in order, then turned into a concise, pivot-table-driven dashboard. Here’s the scope: • Data cleanup – Remove every duplicate row without losing legitimate repeats – Correct all data formats (dates, numbers, text) so they behave consistently in formulas and pivots – Fill or clearly flag missing values to keep the dataset analysis-ready • Dashboard creation – Build a refreshable pivot-table dashboard that summarises the cleaned data at a glance – Include filters or slicers so I can drill down instantly – Keep the layout simple and presentation-ready on one tab Deliverables will be a single Excel file that contains: 1. The original raw data (un...

I have a raw data set sitting in Excel that needs to be turned into clear, insightful visuals right away. The core of the job is data analysis and visualization—think pivots, dynamic charts, maybe a quick dashboard—that lets me spot trends and present findings to stakeholders without delay. I’m looking for someone who has already handled similar Excel-based analytics projects. When you message me, briefly spell out your experience with advanced functions, charting tools, or any past dashboards you’ve built; that background will help me gauge fit quickly. Timeline is tight: I need the first workable version back ASAP, with any tweaks wrapped up immediately after review. Deliverables are straightforward: • A cleaned, well-structured workbook • Clear, re...

I have 11-50 digital files, all already in Excel, that need careful entry verification, duplicate removal, consistent formatting and overall cleanup. You’ll start with the raw workbooks I provide, review every column for basic data errors, realign any misplaced rows, apply appropriate sorting or filters, and return a single set of polished spreadsheets that are ready for reporting. Because everything originates from existing Excel files (no paper scans or database exports), I expect you to leverage native functions—VLOOKUP/XLOOKUP, conditional formatting, Remove Duplicates, data validation and similar tools—to keep the process fast yet precise. Accuracy is paramount; every corrected cell must match the source values. Deliverables • Cleaned and fully formatted Exc...

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

### Project Description I’m looking for an experienced Excel professional to create a **complete yearly business planning and management Excel workbook for a trading company**. The workbook should cover the company’s full-year operations and provide an organized system for planning, tracking, and analyzing the business. The Excel file should include areas such as: * Annual business plan and monthly targets * Sales and revenue tracking * Purchase and supplier management * Inventory and stock planning * Productwrite  and order tracking * Customer management * Expenses and operating costs * Profit and loss calculations * Cash flow and payment tracking * Monthly and yearly financial summaries * Sales and profit forecasts * KPIs and performance tracking * Employee/task plan...

I need a well-structured, easy-to-update Excel workbook that serves as a preventive maintenance plan for my production machines. The file must let me log each machine, register its running hours, and keep a clear history of past interventions. What matters most is speed and clarity: a dashboard or summary sheet that tells me at a glance which machine is approaching its next service based on hours worked, plus automatic colour alerts when thresholds are reached. I already know the service intervals; I just want formulas or simple VBA snippets that flag the dates and hours for me rather than a complex CMMS. Key requirements • Data entry sheets for every production machine (around a dozen to start) • Fields for total hours, last maintenance date, and next due date calculat...

Je cherche quelqu’un pour gérer simultanément deux tâches : renommer plus de 200 fichiers visuels selon ma convention actuelle et compléter un tableur Excel associé. Détails de la mission 1. Renommage des fichiers • Je fournis la convention exacte (structure, abréviations, ordre des éléments). • Chaque fichier visuel doit être renommé immédiatement après vérification de son contenu pour garantir la cohérence. 2. Saisie dans le tableur Excel • Pour chaque fichier renommé, deux catégories d’informations sont à reporter : – Champs texte (titres, références, commentaires). – Valeurs ...