Makro Excel Jobs

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I need help formatting an Excel sheet that contains novel scenes and chapters. The project is urgent and needs to be completed ASAP. Requirements: - Format Excel for novel scenes and chapters - Use of cell styles and borders Ideal Skills and Experience: - Proficiency in Excel - Experience with cell styles, borders, and organization of complex data - Ability to work quickly and meet tight deadlines

I need an Excel workbook enhanced with VBA that can pull sales data directly from our database, crunch the numbers automatically and present clear, on-demand reports. The focus is pure analysis and reporting—no manual copy-pasting, no repetitive filter steps—just hit a button and the figures are there. Here is what I’m after: • A reliable VBA routine that connects to the database, refreshes the data set, and stores it in well-structured worksheets. • Automated calculations for common sales KPIs—revenue by product and region, period-over-period growth, averages, and any additional measures you suggest that add quick insight. • Polished summary views (pivot tables or a lightweight dashboard) that update whenever the refresh runs, so management can ...

I have an Excel workbook waiting for a fresh set of numeric records. Each figure must be entered exactly as provided—every value is in decimal form—so preserving precision is non-negotiable. Beyond typing, I also need you to run a quick error-check: use whatever light-touch Excel techniques you prefer (COUNTIF, conditional formatting, cross-totals, etc.) to flag blanks, obvious outliers, or mismatches. No elaborate validation rules, just a reliable sanity sweep so I receive a clean, trustworthy sheet. The source file will be in your inbox as soon as we start, and I need the finished workbook back within 48 hours. Accuracy and a sharp eye for inconsistencies are essential; solid experience with Excel data entry will make this task straightforward. Deliverable: • Complet...

I have a set of printed documents that must be transferred into a clean, fully-formatted Excel workbook. Every detail—text, numbers, dates, even blank rows—needs to appear exactly as it does on paper, so the sheets in Excel mirror the originals line for line. I will supply: • High-resolution scans of each printed page. • A short guide listing the precise column headers and sheet names I want used. Your job is to: • Key all data into Excel accurately. • Recreate the printed layout (tables, spacing, bold headers, subtotal rows, etc.) so the file feels like a digital twin of the hard copy. Deliverables 1. A single .xlsx file containing all pages in order. 2. A brief note confirming you have double-checked totals and obvious typos. Accuracy and faithfu...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I already have an Excel system with a Measurement Sheet (input) and Dashboard. I need a small automation to generate an RA Bill sheet automatically from the measurement data. Requirement: RA Bill should be generated automatically based on the selected RA number. Each Item No. should appear as a heading with its BOQ description. Under each item, the measurement rows should appear automatically from the Measurement Sheet. The table should have these columns: Description | Unit | N1 | N2 | Length | Width | Depth | Qty The Description column should show location/sub-item from the measurement sheet. When entries for the same Item No. end, the system should automatically show Total Quantity. After the total row, the next Item No. section should start automatically. The number of rows under each ...

I need support with a sizeable Excel file that must be reorganised, cleaned and formatted according to the templates I will supply. Your task is to follow those guidelines precisely, arrange the data into the correct column order, remove inconsistencies, standardise dates and numbers, and consolidate multiple sheets into one well-structured master workbook. Accuracy is critical—every cell has to comply with the rules before the project is considered complete—and I expect a quick yet careful turnaround. Deliverables: • Updated, fully formatted Excel workbook in .xlsx • Brief changelog outlining any issues spotted and fixed Let me know your estimated completion time and any questions you may have so we can begin.

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...

All of our production figures are already captured in a single Excel workbook; what I need now is a clear, interactive dashboard that turns those raw rows into insight. The layout should feature bar charts, pie charts, and line graphs so supervisors can see at a glance where we stand. Key metrics are straightforward—total production volume and accumulated downtime—updated automatically each day as fresh data is entered. The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required. Deliverables • One dashboard tab with the visualisations laid out cleanly for shop-floor display • A...

I need a clean, well-structured Excel workbook that lets me plug in every expense tied to an electrician and instantly see the true labour recharge rate we should be billing. Core costs to be captured • Labour and wages (hourly rates only) • Overhead and administrative costs, specifically the software and tools we use to run the business • Insurance premiums • Vehicle hire fees and ongoing vehicle costs Functionality The sheet must let me update each of these figures quickly, apply any on-cost percentages I specify (super, holiday pay, etc.), roll everything into an annual total, then divide back to an accurate hourly charge-out rate. A separate section should let me add a profit margin so I can test different mark-ups without touching the underlying cost model....

Results About google sheet 2- tabs perfer . We are looking for a specialist who can organize and optimize the data structure of Google Sheets. This project is not about building new software. The task focuses on analyzing and organizing existing Google Sheets structures. Main responsibilities include: • Analyzing and organizing existing Google Sheets structures • Organizing data flow between sheets • Improving table structure and readability for data management • Adding simple formulas or logical structures if necessary Currently, there are approximately 20 sheets in the system. The selected person will review the overall structure and perform standardization and organization. Required skills: • Advanced experience with Google Sheets or Excel • Experi...

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...

I’m looking for a reliable specialist to turn several raw Excel-based spreadsheets into polished, easy-to-use documents. Here’s what I need done: • Build clear tables and visually engaging charts so key figures stand out at a glance. • Apply conditional formatting that instantly highlights trends, outliers, and priority items. • Set up robust data-validation rules to prevent future entry errors. • Enter new records, clean existing information, and reorganize the overall layout so every column and sheet follows a logical structure. The files cover mixed numerical and text data, so accuracy, consistency of styles, and a tidy workbook structure are essential. If you’re comfortable combining data-entry precision with smart Excel formatting, I&rsquo...

I have a spreadsheet whose dates now appear in a mix of styles—some show “12/05/23”, others “05-12-2023”, a few are stored as text strings, and a handful are genuine serial numbers. I need the whole column cleaned so every entry follows one consistent, true-date format that Excel recognises natively. Your task is strictly data cleaning: standardise every date, verify the change with a quick formula check (COUNT, MIN, MAX—whatever you prefer), and hand back a file that requires no manual fixes from me. Feel free to tap Power Query, formula tricks, or simple formatting commands; I only care that the resulting dates sort, filter, and calculate correctly. Deliverables • The cleaned workbook with a single, uniform date format (I’m happy with yy...

I need an Excel spreadsheet to track data on people, the number of pieces they handle, and any mistakes they make. It should include: - Data entry forms for easy input - Error tracking (method flexible) - Automated calculations Ideal skills and experience: - Proficiency in Excel - Experience in creating user-friendly data entry forms - Strong understanding of error tracking methods and automated calculations

I have an existing Excel VBA workbook that is already developed and mostly working fine. However, sometimes it hangs or becomes slow when using buttons in the first sheet. I need a freelancer to review the existing VBA code, fix the issue, and improve the file’s performance and stability without changing the current working logic. This is mainly a small debugging and optimization task, not a full development project.

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

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 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 have three Excel workbooks whose VBA-driven macros used to handle a handful of quick calculations and automated steps for my students. Those functions have stopped running altogether—no errors, just macros that refuse to fire—so first I need the existing code reviewed, debugged, and restored to full working order. Once everything works flawlessly in Excel, the same functionality has to live inside Google Sheets. After you tidy up the VBA, please translate it into clean, well-commented Google Apps Script, embed it in a Sheets copy of each file, and make sure the buttons or menu items behave exactly as they do on the desktop. Deliverables • Repaired VBA across the three original worksheets • Change log or in-line comments explaining what you fixed • Google ...

I’m approaching my last assignment, an online exam that will test my overall proficiency in Microsoft Excel, and I want an experienced Excel specialist to guide me through the preparation process. The goal is to make sure I can complete every task confidently during the live assessment, from structuring data correctly to using core features without hesitation. Here’s what I’m looking for: • A short, focused review session to pinpoint any weak spots in my workflow. • Targeted practice questions that mirror the typical exam format. • Clear explanations of why each solution works so I can replicate the steps on my own. • Live walkthroughs—screen-sharing or annotated screenshots—demonstrating the fastest, most reliable methods inside Exc...

I have a clean historical-weather spreadsheet and I want to turn it into a set of engaging dashboards and interactive 3d models. I am trying to prove a thesis that wind direction during winter months contributes to snow blocking a road. The key stories I need to see are: • Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model. • Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month. Focus is on Dec-March Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. ...

I need an Excel expert to fix formula errors in my resource management workbook. One worksheet isn't correctly pulling hours required by employee type from other sheets. Requirements: - Excel proficiency - Experience with complex formulas - Problem-solving skills Please provide relevant experience in your application.

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

I need help to make an Excel sheet non-editable. I have already filled in all the details. Requirements: - The main sheet should be view-only, allowing users to view data only. - One specific editable sheet for me or select users. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience with cell locking and permission settings

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 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 keep all of my renewal data in a single Excel workbook, and every time I need to review information for a specific customer I have to re-apply filters manually. I want that entire routine collapsed into a single click. Here’s what I need: a lightweight automation—VBA, Power Query, or another native Excel approach—that sits inside the file and instantly filters the renewal dataset by customer whenever I press a button or choose a custom ribbon command. The solution must work in standard desktop Excel (Microsoft 365), recognise new rows automatically as the table grows, and preserve any existing formulas and pivot tables. Please deliver a working, macro-enabled version of the workbook (or a clearly commented code module I can import) along with a short set of instructio...

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.