Excel VBA Jobs

I'm seeking an Excel expert to resolve AUTOMATION ERROS! errors in my spreadsheet. The cells involved contain a mix of text, numbers, and dates. Ideal Skills & Experience: - Proficient in Excel formulas and error troubleshooting - Experience with handling data types: text, numbers, and dates - Attention to detail and problem-solving skills Please provide examples of similar work done.

I have a collection of Excel/CSV files that need to be consolidated, checked, and polished so they are ready for analysis and reporting. The raw sheets contain a mix of blank cells, occasional typos, uneven date and number formats, and some possible duplicate records. Your job is to: • Enter any missing rows or columns from scanned notes I will supply as images or PDFs. • Review every field, correcting obvious spelling or numeric errors. • Standardize dates, currencies, percentages, and other formats so each column is consistent throughout the workbook. • De-duplicate the data while preserving the first complete record when matches appear. • Return a single, clean Excel file plus the original, unaltered copy for reference. I’ll share the files...

I already have a working Excel workbook in daily use, but its current macros are slow, brittle, and hard to maintain. I need an experienced VBA developer to dive into the existing code, streamline the logic, and add any missing functionality so routine tasks run reliably at the click of a button. Although the immediate scope is limited to Excel, I would like the code written cleanly enough that it could later be adapted for Access or Word–based reporting if the project grows. After an initial review of the file, we can agree on the exact touch-points, but my priorities are: • Refactor or replace outdated VBA modules • Optimise speed and eliminate manual steps wherever possible • Add clear in-line comments and a brief user guide sheet • Leave the workbook f...

I want a single Excel file that lets me drop in fresh sales and purchase data and instantly see what’s happening in the business. The heart of the job is an interactive dashboard—clean, professional, and easy for anyone on my team to grasp at a glance. Here is what I need the file to do: • Automatically refresh whenever I upload a new data file, so no manual copy-pasting. • Display bar, line, and pie charts that highlight both sales trends and purchase trends. • Use pivot tables and slicers to let me drill down by product, date, or supplier without breaking the layout. • Track current inventory levels in real time, flagging low-stock items. • Surface the two KPIs I care about most—product-wise performance and overall revenue growth&mdas...

I need an Excel dashboard to analyze my sales and purchase data. The dashboard should provide insights on sales trends, purchase trends, and inventory levels. Requirements: - Visual elements: charts, graphs, tables, and pivot tables - Periodic data updates Ideal Skills and Experience: - Proficiency in Excel, especially in creating dashboards - Experience with data visualization - Ability to set up periodic data updates Looking forward to your proposals!

I need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel

I need an extra set of hands to move a collection of mixed text-and-number records into an Excel workbook and make sure every piece of text ends up neatly grouped by category. Accuracy matters: totals and numerical fields must stay intact, and the category labels should be applied consistently so I can sort, filter, and pivot the sheet without additional clean-up. The source files are ready; you will receive a brief legend explaining each category as well as the column layout I already use for similar jobs. If you have suggestions for small improvements—conditional formatting, simple validation rules, or a more efficient way to separate the categories—feel free to propose them, but my priority is getting a reliable, well-structured file back quickly. Deliverables • Compl...

We are seeking an experienced professional with advanced Excel and Power Query skills to develop a robust production control and traceability system for the swine industry. The goal is to create an organized tool that functions as an efficient database for registering and tracking animal batches from nursery placement to the finishing phase. The system must be able to manage and relate the following production stages: 1. Nursery Placement: * Integrated registration, placement date, number of animals, origin, truck license plate, and farm capacity. * The system must allow multiple placements for the same farm until its capacity is reached. 2. Vaccination Control: * Registration of vaccination date, vaccine name, number of vials used, and number of animals vaccinated. * It must allow m...

I manage a driving school and do weekly payroll calculations for driving instructors. I need a clean, reusable Excel workbook that lets me log regular and overtime hours alongside work-related costs (gas receipts with mileage), and any bonuses earned for each driving instructor (employee). The sheet should automatically roll these daily entries into clear weekly totals, then feed monthly and yearly summaries so I can see trends at a glance without extra work. If you find a simple way to leave space for other cost or earnings categories (bonuses earned) that would be a plus. Core requirements • Input section for each instructor would be Name, Dates of Pay, Regular Hours, Overtime Hours, Regular Pay Rate, OT Pay Rate, Gas Expenses, Mileage, Average MPG, Cost/Mile, Miles Driven...

I need a clean, easy-to-update daily sales scorecard built in Excel. The file should let me enter each day’s numbers and instantly see my performance at a glance—totals, averages, simple charts, whatever you feel best communicates results. Please set up formulas so I don’t have to touch any calculations; my role is just to drop in raw figures and read the insights. Structure is flexible as long as it stays in one worksheet or a logically linked set of tabs, but I do want space to expand later if I decide to track weekly or monthly summaries. Clear labeling, consistent formatting and a visually tidy layout are essential. Deliverable: an unlocked Excel workbook ready for daily use, with a brief note explaining any key formulas or pivot tables you add so I can maintain it ...

I have an existing spreadsheet and I need you to build a clean, reusable formula that adds a percentage-based margin across several columns at once. The goal is simple: each product cost already in the sheet should automatically display its selling price after the margin is applied, and any future rows I add must calculate correctly without extra work on my part. You’ll receive the workbook as it is now, along with the exact percentage I use. Please set up the formulas (or structured table columns, if that’s the most robust route) and test them so I can drop in new cost figures and instantly see the margin-adjusted numbers in every specified column. Deliverables: • Updated Excel file with the margin formula in place for all required columns • A brief note or comme...

I’m looking for a clean, well-structured Excel workbook that lets me enter sales figures and all associated costs, then instantly see my profit margins at a glance. Detailed calculations are essential, so every figure—from gross to net margin—should flow automatically from clear, auditable formulas. The file should include: • An input area where I can add or update revenue and expense data without breaking the model. • Formula-driven summaries that display total income, total costs, gross profit, net profit, and margin percentages. • A calculation sheet that performs the heavier analytical work (break-even points, sensitivity toggles, growth comparisons, or any other routine you recommend for deep-dive profitability checks). • A tidy dashboard...

I have a single Excel file holding fewer than 1,000 rows of mixed text and numeric fields. My aim is to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. In other words, I need a reliable fuzzy-matching solution that surfaces these near-matches so I can review and consolidate them. Here is what I need from you: • A working Excel-based approach—formulas, Power Query, VBA, or a combination—that compares the mixed fields and returns a similarity score or direct match flag. • Clear, editable logic so I can tweak thresholds or add new columns later without rewriting the whole thing. • A brief walkthrough (written notes or short screen capture) showing how the matching was set up ...

I need an experienced Excel expert to fine-tune my workbook used for data analysis, specifically for generating skill completion reports. The goal is to eliminate any bugs and ensure its long-term reliability. Key Tasks: - Debugging existing formulas and functions - Streamlining report generation processes - Ensuring data integrity and accuracy Ideal Skills and Experience: - Proficiency in Excel, especially in data analysis - Experience with report generation and complex formulas - Attention to detail and problem-solving skills Looking for someone who can deliver a robust and efficient Excel workbook.

I need an Excel expert to help create formulas, specifically for text manipulation. Ideal skills and experience: - Proficiency in Excel, especially in formula creation - Expertise in text manipulation formulas - Ability to work efficiently and accurately Please include examples of past work in your application.

I have a collection of financial figures that needs to be transferred accurately into an Excel workbook. The task is straightforward: type the numbers exactly as provided and apply a consistent currency format so every value displays correctly. Accuracy is critical, as these figures feed into later reporting. I will supply the source material and a blank template; you simply populate the sheet, double-check for entry errors, and ensure the currency formatting is applied throughout. If you are detail-oriented, comfortable working with Excel’s basic formatting tools, and can turn this around quickly, I look forward to collaborating with you.

I’d like a streamlined Excel tool that lets me generate instant cost estimates for flyer jobs in my printing press. The sheet should prompt me for key variables—paper type, quantity, print quality, freight, profit margin, cutting, design, and actual press-run charges—then output a clear per-unit price and grand total that I can copy straight into a client quote. Here’s what I need the workbook to do: • Simple front-end form or clearly labeled input cells for each variable listed above • Behind-the-scenes formulas that add mark-ups, combine fixed and variable costs, and flag any negative margins • An easy-to-read summary section showing subtotal, tax (if I toggle it on), and final figure If you can add optional dropdowns for common paper stoc...

I have an existing workbook that needs a tidy-up from top to bottom. Your first task is to key in a batch of raw data with zero transcription errors, remove any blank or duplicate rows, realign columns where headings or values have drifted, and generally make sure every cell is in the right place. Once the information is clean, I’d like the sheet formatted for quick reading: headings that stand out, columns auto-sized, clear number and date formats, and any simple visual touches (for example basic colour highlights or borders) that make patterns jump out without becoming cluttered. If you spot a chance to add light data validation, a summary formula, or a pivot table that boosts usability, include it and note what you changed. Deliverable: the fully cleaned and reformatted .xlsx ...

We’re looking for someone highly skilled in Excel to help our company build a small suite of sales documents. All of the below, we have the contractual wording already, we just need the dashboard built and the automation of input of informaiton Document 1 – Services Contract (Excel → PDF): A services contract template where the sales team enters client details on a “Home” tab, and the information automatically populates throughout the contract. The final output should export/print to PDF in a clean, visually appealing format. Document 2 – Short-Form Contract (Excel → PDF): A simplified version of Document 1 for smaller engagements. Client details are entered once on a main tab and auto-populate the short-form agreement, which can then be exported/...

I need help securing an Excel file with a password. Requirements: - Password protection to open the file - Minimum password length of 8 characters Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with password protection features in Excel - Ability to create secure passwords meeting minimum length requirements

I have an existing Excel-based inventory workbook that has started to behave unpredictably. Data entered in one sheet no longer flows through to the summary pages, several formulas now return #REF! or #VALUE! errors, and the overall stock-on-hand figures are plainly wrong. What I’m looking for is a deep clean of the workbook, with particular attention on the inventory tracking formulas. Please trace the current logic, identify the break points, and rebuild the calculations so that every time new stock is received or sales are logged the counts update instantly and accurately. You will have access to the current .xlsx file plus a short note describing the intended flow. I just need one deliverable: the repaired file, ready for everyday use, with all inventory totals populating c...

I have two practical Excel tasks that I want wrapped up into clean, reusable templates. First, I need a professional-looking invoice sheet. It must automatically pull in client information, list each item or service, calculate totals, display the payment terms with the due date, and show an invoice number and issue date without me having to touch formulas every time. Second, I want a simple stock report that reads my raw inventory data, shows current quantities on hand, and highlights low-stock items so I can reorder on time. A clear summary view and the underlying formulas are both important because I’ll maintain it myself later. You’re free to approach the layout and formulas however you feel is most efficient—as long as everything stays in native Excel with no exter...

We’re looking for someone highly skilled in Excel to help our company build a small suite of sales documents. All of the below, we have the contractual wording already, we just need the dashboard built and the automation of input of informaiton Document 1 – Services Contract (Excel → PDF): A services contract template where the sales team enters client details on a “Home” tab, and the information automatically populates throughout the contract. The final output should export/print to PDF in a clean, visually appealing format. Document 2 – Short-Form Contract (Excel → PDF): A simplified version of Document 1 for smaller engagements. Client details are entered once on a main tab and auto-populate the short-form agreement, which can then be exported/...

I’m building out a new website and now need a reliable pair of hands to move the product information that I already have in Excel into the site’s back-end. The job is entirely data-entry focused—no writing, design, or user-management work—just accurate transfer of each product’s title, description, price, images, and any variant details I’ve already collated. You’ll receive neatly structured Excel sheets and secure access to the admin panel. From there, your task is to create the corresponding product records so they display perfectly on the live pages. Consistency in formatting, correct category assignment, and double-checking that every image is attached and every SKU is error-free are crucial. Deliverables • All products from the supplied...

I need an Excel-based dashboard, driven by VBA, that runs entirely offline and guides pharmacists and clinicians through chronic kidney disease and cardiovascular risk screening. The workbook must accept three kinds of patient inputs: demographics with medical history, current lab tests and vital signs, plus any active medications or treatment plans. As soon as the user enters or pastes that information, the tool should automatically calculate evidence-based risk scores, assign the correct CKD stage, and display clear on-screen prompts for next clinical steps—no internet look-ups, external add-ins, or cloud calls allowed. Fast, intuitive navigation is essential because the primary users will be frontline pharmacists and clinicians working in low-resource settings. I’m envision...

Quiero un dashboard dinámico en Excel que me permita seguir el rendimiento diario de mis ventas. Proporcionaré la base de datos cruda y necesito que la transformes en un panel claro y visual que incluya las siguientes métricas: • Cantidad de ventas • Ingresos generados • Número de clientes . Otros dato relevante para la base de datos que aportan valor. Tengo prioridad en el análisis de las ventas diarias, así que la estructura debe destacar ese horizonte temporal y permitir filtrados rápidos por fecha. No indiqué un tipo de gráfico concreto porque estoy abierto a sugerencias: barras, líneas o la combinación que consideres más intuitiva para comparar tendencias. Entrego el archivo de ...