Excel Macros Jobs

I need someone based in or near Dammam to spend a day (or two half-day sessions) sitting with me and transferring customer data from our internal dashboard into an Excel sheet on my laptop. Remote access isn’t possible, so you will work directly on my machine at my office. The task is simple: copy less than 100 customer records, capturing the date and current process status for each, then place them into a clean spreadsheet laid out in standard rows and columns. Accuracy matters more than speed; every entry must match what you see on the screen. Deliverable • One Excel file on my laptop containing all customer rows completed and double-checked for accuracy. Acceptance criteria • All customer records present (no skipped rows) • Dates follow the DD/MM/YYYY forma...

I have several Excel workbooks that combine text fields with numerical columns and the structure is far from uniform. Headers differ, dates use mixed formats, duplicates are scattered throughout, and some key cells are empty or mis-typed. I need the whole collection cleaned so I can run reliable analysis straight away—no surprises, no hidden errors. The job calls for someone comfortable working end-to-end inside Excel (Power Query, formulas, or lightweight VBA if it speeds things up). You’ll be free to stage the process however you like as long as the final files open natively in Excel with all numeric integrity preserved. What I expect to receive • A single, fully cleaned and consolidated workbook (or clearly named set of workbooks if separation is essential). &bull...

I need reliable help consolidating and updating financial data inside an existing spreadsheet. The file contains multiple tabs for monthly revenue, expense categories, and cash-flow projections; my priority is to have every figure entered accurately, cross-checked, and formatted so that formulas and summaries calculate without error. You’ll be working primarily in Microsoft Excel (or Google Sheets if you prefer) and will receive source statements and receipts in PDF and CSV form. Scope of work • Enter new transactions line-by-line, matching the chart-of-accounts structure already in place. • Verify totals against the original documents and flag any discrepancies. • Apply or correct formulas for running balances, quarterly subtotals, and year-to-date summaries. ...

I need reliable help consolidating and updating financial data inside an existing spreadsheet. The file contains multiple tabs for monthly revenue, expense categories, and cash-flow projections; my priority is to have every figure entered accurately, cross-checked, and formatted so that formulas and summaries calculate without error. You’ll be working primarily in Microsoft Excel (or Google Sheets if you prefer) and will receive source statements and receipts in PDF and CSV form. Scope of work • Enter new transactions line-by-line, matching the chart-of-accounts structure already in place. • Verify totals against the original documents and flag any discrepancies. • Apply or correct formulas for running balances, quarterly subtotals, and year-to-date summaries. ...

I’m gathering quotations from roughly a dozen food-service suppliers and need a clean, reliable Excel file that lets me and you plug each quote in and instantly see where we can save money. Structure I have in mind • One master workbook with a dedicated tab for every supplier (expect 10–12). • A dynamic summary tab that automatically identifies the best supplier overall for every line item, taking into account weight and pack-size differences. possible colour coded • Built-in calculations for total costs per supplier, potential savings against a current baseline, and any weight/pack-size conversions so we’re always comparing like with like. Presentation requirements • On the final tab I want a clear “best supplier overall” view, p...

I need a Gantt chart from a PDF converted into Excel. The Excel file should match the style of the original PDF Gantt chart, with merged cells to represent timelines. Ideal Skills and Experience: - Proficiency in Excel - Experience with PDF to Excel conversion - Attention to detail for accurate style matching Please ensure no additional calculations or changes in format are made.

I need my existing workbook to do more of the thinking for me. Right now each process is logged manually, but the column that should show who is responsible is blank. Your task is to insert the right data-analysis formulas so that, as soon as a process code or other key detail is entered, Excel automatically returns the correct “responsible” name. You may lean on lookup combinations, conditional logic, or any other native functions that keep the file fast and easy to edit; lightweight VBA is acceptable only if a purely formula-based route proves impossible. The sheet layout should remain intact—no moving columns or renaming headers. Deliverables • Working formulas (or compact VBA) that populate the “Responsibility” field for every current and future r...

I have several spreadsheets containing staff information that now need to be migrated into a cleaner, unified file. The source material is already in Excel, so you can work directly inside that environment without having to convert from paper or PDFs. For every record you will be entering three specific field groups exactly as they appear: • Name and contact details • Employment history and roles • Certifications and qualifications Consistency is critical—spelling, date formats, and credential abbreviations must match the source. A quick pass for obvious duplicates or incomplete lines before you hand the file back is also appreciated. Please send the finished workbook in .xlsx format. If you use any data-cleaning macros or Power Query steps, include them in th...

I need a clean, reusable Excel workbook that lets me do two things from the same file. First, track daily attendance in a simple table that shows each employee’s name, check-in time, check-out time, and total hours worked. Second, have those attendance figures feed seamlessly into a salary-slip sheet so I can generate individual payslips at month-end without re-entering data. A formula-driven solution is my priority, but I’m open to lightweight VBA if it keeps everything one-click simple. The layout must stay fully editable, as different teams may add or hide columns later. Please deliver: • A master attendance sheet with automatic date handling and clear data-validation for time entry • Dynamic formulas (or macro) that calculate total hours per person per day and...

I need a fully automated Excel bill for my trading business. The Excel sheet should be capable of generating invoices automatically. The invoices need to include: - Customer information - Product details - Payment terms Ideal skills and experience: - Advanced Excel skills - Experience in creating automated Excel templates - Attention to detail - Prior experience in invoicing for retail or trading businesses Please provide samples of similar work done.

I keep a master list of text in Excel and need the same strings to appear in set bookmarks inside a lengthy Word document. Manually updating each spot is getting out of hand, so I want to automate the round-trip. The core job is to write reliable VBA/macros that will: • Pull text data from specific Excel cells. • Match each cell to its corresponding Word bookmark. • Push the new text into Word at the click of a button (or Workbook_Open/Document_Open event). • Offer a simple “refresh” command so I can rerun the sync whenever the spreadsheet changes. • Handle errors gracefully (missing bookmark, blank cell, Word not open, etc.). Nice-to-have: If a bookmark’s text is edited directly in Word, a reverse sync back to Excel would be a bonus. ...

I have an urgent assessment to finish and need a specialist who truly understands Workforce Management logic inside Excel. You will receive one raw workbook that already holds the time-stamped data and all supporting assessment figures. Your main job is to turn that sheet into a clear-cut capacity-planning model, then walk me through the reasoning so I can present it with confidence. Here is what I am looking for: the model must calculate staffing requirements, shrinkage, occupancy, service-level projections and any other standard metrics you normally include for solid capacity planning. Forecasting and scheduling elements sit right behind this priority, so design the file in a way that lets me easily extend it to those areas. Accuracy is essential, but speed matters even more; I need fir...

My Excel workbook already contains a VBA macro that opens a PDF, extracts targetted numeric value from certain columns, aggregates them, and drops the results straight into specific cells. Functionally it works, yet it generates errors when it comes accross different number formats. I need a fast, tidy rewrite (or smart port) that does the same three core steps—read, parse & aggregate, write—within roughly three hours of coding time. You can choose the approach that lets you move fastest: streamline the existing VBA, replace it entirely with a Python routine built around pdfplumber, or create a hybrid where Python performs the heavy lifting and VBA simply updates the sheet. I’m comfortable with any of those paths as long as the final workbook remains a one-click solu...

I’m looking for a clean, reusable sales-invoice template built entirely in Microsoft Excel. The finished workbook must let me enter customer details, list product descriptions, and spell out payment terms without breaking the layout. For the product section I’d like full flexibility—sometimes a single line per item is enough, other times I need multiple descriptive lines or even a category breakdown. Please structure the sheet so any of those views can be shown or hidden easily. Automatic line totals, subtotal, tax, and grand-total formulas should already be in place, and all cells where I’ll type data clearly marked. A spot for my company logo and address would be helpful too. Deliverable: • One unlocked .xlsx file ready to use and modify later. If you&rsq...

PROJECT: Excel-Based Quotation System with Admin Control (MODA Windows & Doors) We need to develop a quotation system using Microsoft Excel (offline), with structured pricing logic, admin-controlled pricing tables, and manual PDF export. The system must be easy for sales users to operate while maintaining full control of pricing by the admin. 1. USER ROLES & ACCESS CONTROL There are two types of users: Admin Has full access to all sheets, including Pricing List and Customer Database. Can edit all pricing, unlock protected areas, and manage the system. User (Sales) Has access only to: - Customer List (restricted editing) - Quotation Sheet (data entry only) User cannot: - Access or modify Pricing List - Change formulas or pricing logic - Delete or edit customers without admin...

When I export my .xlsx workbook to PDF, what should be a single-page printout gets split across two pages. In Excel’s print preview everything fits neatly on one sheet, so I know the layout is correct inside the file; the problem appears only at the PDF stage. The sheet contains a mix of text labels and numerical data, no external links or macros. I need someone who can dive into the page-setup settings, scaling, margins, printer drivers or any other culprit and deliver a PDF that mirrors the one-page view I already see inside Excel. Ideally you’ll explain the tweak so I can apply it to future sheets too. Deliverable: • Updated workbook (or documented steps) that consistently exports to a single-page PDF matching Excel’s print preview.

I have a set of raw financial figures that still need a bit of tidying before they can reveal their story. Once the data is properly formatted in Excel, I need clear, well-labeled outputs for these descriptive measures: mean, median, plus the full spread of quartiles and percentiles. Please structure the workbook so that the cleaning steps (date or currency standardisation, removal of blanks, etc.) are transparent, then create the calculation area—whether that is with built-in functions, dynamic arrays or PivotTables is up to you, as long as the results update automatically when new records are dropped in. Deliverables: • A single Excel file containing: – A “Raw_Data_Clean” sheet with all prep formulas in place – A “Stats_Summary&rdquo...

I have several Excel spreadsheets filled with statistical entries recorded on different dates. I need the date columns repaired and standardised first, then a reliable way to compare each entry across the sheets so perfect matches surface immediately. Once the data is aligned, A small dashboard or set of charts inside the workbook is perfect; I want to see the movement at a glance. Everything must stay in .xlsx format. Use familiar Excel tools—formulas, conditional formatting, PivotTables, maybe Power Query if it speeds up the cleaning—so I can inspect or tweak them later. Deliverables: • Cleaned and consistently formatted spreadsheets • Automated comparison logic for the date-based entries • Standard deviation results for each metric • Tren...

I run a small business and need our entire bookkeeping cycle captured accurately every month. The work covers day-to-day sales and purchase entries, updating the Cash Book and Bank Book, maintaining all ledgers, and closing each period with a balanced Trial Balance. The data must be recorded in both Excel and Tally; I use Tally for quick ledger look-ups while my partners prefer the flexibility of Excel. I already have a template in both platforms—once you come on board I’ll share these files so you can follow the exact layout we’re accustomed to. Deliverables each month • A fully updated Excel workbook that mirrors the structure I provide • The corresponding Tally data file with identical figures • A concise monthly report pack generated from th...

I have a short Excel VBA procedure called Sub AboutMe( ) that pops up a message box introducing me. I now need a clean, well-commented revision of that macro so the entire prompt appears in Hindi and also shows my contact information directly in the same MsgBox. Key points you must cover while editing the code: • Replace the existing mixed-language text with full Hindi phrasing. • Append a concise contact line (phone / email placeholder is fine; I will fill real data later). • Keep the procedure lightweight so it runs in any standard Excel workbook without additional references. Please return: 1. A .bas or .xlsm file containing the updated macro. 2. Brief instructions (one or two lines) on how I can change the contact string myself whenever needed. If you ca...

I have an existing monthly-budget workbook that already tracks income and savings, but the expense side is lagging behind. I need you to dive into the Expenses section, review the current cells and ranges, then build or correct the formulas so every expense line rolls up cleanly into a monthly total and feeds the year-to-date view. The sheet is laid out clearly, so this is mostly a formula and cell-reference task: SUMIF/SUMIFS, structured references, and a few conditional calculations for overspend alerts. No macros are required; pure Excel functions are fine. Once finished, I should be able to drop new numbers into each daily or weekly expense row and see the monthly forecast adjust automatically. Deliverable: the updated workbook with transparent, commented formulas in the Expenses are...

Project Overview I have an existing Excel workbook used for job costing in a construction/striping business. The workbook is already functional and calculates costs based on quantities entered across multiple sheets (organized by item types such as striping widths, colors, markers, removals, etc.). Each sheet calculates unit pricing based on quantity tiers and produces totals. However, my current summary sheet only shows category totals (e.g., total striping, total removals) and does not provide a detailed, itemized breakdown. What I Want to Achieve I need to create a final summary sheet that dynamically pulls and displays ONLY the items used in a job, including: Item description (ex: 4” White Stripe, RPM Marker, etc.) Quantity entered Unit cost (based on the pricing logic alrea...

Need Excel + Power Query Expert for Inventory Dashboard (Pen Drive Based System) Project Overview: I run a manufacturing business and maintain stock in multiple Excel files (7–10 files), each for different categories like motors, inverters, pumps, etc. These files are stored in a folder on a pen drive. I need a simple, reliable system to view consolidated stock in one place without manually opening multiple files. Constraints (VERY IMPORTANT): * All files will remain on a pen drive (no cloud solutions like OneDrive or Google Drive) * Folder path will remain fixed (example: E:Stock_Files) * I will only open ONE master Excel file (no need to open individual files) * System must work offline * Must be simple to use (non-technical staff) Requirements: 1. Use Power Query (“Fr...

I need our simple logistics data-entry workbook turned into a smarter, mostly hands-off tool. Right now staff key information into a single base sheet, then we spend extra time copying, filtering and re-formatting that same data before it can be e-mailed to clients. I want to keep the base sheet as the only place anyone touches the raw figures, but have the rest happen automatically: • Guided data input – drop-downs, look-ups or forms that prevent typos and ensure each required field is filled. • One-click data output – macros or Power Query that transform the base data into clean, customer-ready sheets (PDF or XLSX) and save them to a specified folder, ready to attach to an e-mail. Because all finished files go out as e-mail attachments, the generated sheets mu...

I need a comprehensive financial report spreadsheet created in Microsoft Excel. The spreadsheet will need to handle mixed data types, including numbers, text, and descriptions. There already is a financial model, but it needs to be optimised and also be able to be changed into different currencies. There then need to be a consilidation option needed as well. Key Requirements: - Create a detailed financial report - Use Microsoft Excel - Handle mixed data types - Ensure data accuracy and integrity Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with financial reporting - Attention to detail and accuracy - Ability to manage mixed data types Please provide samples of previous financial reports created in Excel.

I need a single Excel workbook that can serve as an issue register for roughly twenty ongoing projects. Each project will sit on its own sheet, and every sheet must let me log: • the date an issue is booked • its target closure date and actual closure date • a status field with the options Open, In Progress, or Resolved • the name of the resource responsible for that issue Across the whole file I want a compact dashboard, shown as summary tables, that rolls everything up in real time. At a glance I should see: • total issues booked • total issues still open • total issues closed / resolved A simple date-range filter is essential so I can instantly list all deliverables that remain open (or moved to Resolved) between any two dates I choos...

I need a single Excel workbook that lets me monitor four different products from the moment they come into stock until they reach my customers each week. The file must show, at a glance, how many units I still have on hand, how many went out this week, and the exact date each order was placed. The only way I want to add customer orders is through a clean, user-friendly form—no typing directly into tables. When I open the form, I should be able to pick the product, enter the quantity requested, choose or type the customer name, and hit submit. As soon as I do that, the workbook should automatically: • deduct the quantity from the correct product’s stock balance • stamp today’s date (or the date I select) as the order date • log the transaction so w...

I have two nearly identical Excel workbooks—each with approximately 300 rows and columns A through AE—that need to be merged into a single, clean master sheet, which is already established. The goal is to streamline our data management by ensuring every record is transferred accurately and all duplicates are eliminated using an automated duplicate-checking tool, rather than manual review. The finished file must reach me by Wednesday, 16 April 2026, midday AET.

I need a clean, branded Excel file that lets me build product-only quotations quickly while still looking fully professional to my clients. The sheet has to show, at minimum, columns for Product Name, Product Description, Quantity and Unit Price, with automatic line totals, subtotal, tax and grand total calculations. I sometimes attach images to help the client visualise an item, so please leave space or an optional column that can accept embedded pictures without breaking the layout. A few other things will make the file truly useful to me: my company header and contact block locked into place, space for the client’s details, auto-generated quotation number and date, clearly formatted terms & conditions at the bottom, and colour-coded cells so it’s obvious which fields I ...

Διαθέτω έναν βασικό πίνακα Excel όπου καταγράφω το πληθος των ημερομισθίων ανα μηνα, των εργαζομένων μου. Θέλω να μετατρέπεται αυτόματα σε πίνακα παρουσιών ανά ημερομη...

Ich habe 580 Datensätze mit Postleitzahlen und möchte sie in Excel als übersichtliche Punktkarte Blasenkarte auf einer Landkarte darstellen. Aufgabenstellung • In einer einzigen Excel-Datei soll eine Punktkarte entstehen, die alle 580 Standorte korrekt platziert. • Die Punkte sollen entsprechend dem vorgegeben Wert unterschiedlich gross sein. • Die Karte soll sauber formatiert sein, damit sich Cluster und Einzelpunkte klar erkennen lassen (farbliche Abgrenzungen oder dezente Beschriftungen sind willkommen, solange die Lesbarkeit gewahrt bleibt). Damit Sie direkt loslegen können, stelle ich eine Excel-Tabelle mit Spalten für Postleitzahl, Beschreiung und Wert bereit. Bitte nutzen integrierte Excel-Mapping-Funktionen oder Power Map/3D Maps ...