Macros de Excel Jobs

I have a workbook with salary information for 100 employees that needs to be reshaped so it drops straight into our destination software without further tweaks. To make that happen I will send you a sample file that illustrates the final structure, then share an additional note that spells out the exact column names we must use. Here is what has to change: • Column headers need to be renamed • Data must be sorted in a different order to mirror the import sequence • Certain fields have to be added or removed so the sheet lines up perfectly with the target template Once those adjustments are complete I just need the finished Excel file back, ready for import and free of validation errors.

I need a clean, user-friendly Excel workbook that lets me capture transaction information through a single form and instantly generates clear, printable PDF report from those entries. The focus is squarely on reporting, so the workflow should look like this: PLEASE SEE THE ATTACHED CDA WORKSHEET! 1. Form-based data entry • One intuitive sheet (or VBA UserForm) where I can type the key business details—dates, client, amounts, notes, anything you suggest for solid record-keeping. • Dynamic drop-downs or validations to keep entries consistent. 2. Reporting layer • A report sheet that pulls fresh figures the moment new data is added. I’m open to formulas, structured tables, or VBA—whatever produces a smooth experience and reliable output...

I have an existing Excel workbook that holds our full product catalog, and a portion of those details is now out of date. Your task is to go through the sheet, locate each item that shows incorrect or missing information, and bring every field up to current specs—titles, descriptions, prices, SKUs, anything that has drifted from what we now sell. You will work directly in the supplied Excel file, keeping the established column structure and formulas intact. Accuracy is critical: every value you touch must match the latest source material I provide, and formatting (capitalisation, units, currency symbols) has to stay consistent across the sheet. Deliverables • Updated Excel workbook returned with 100 % of product rows verified and corrected • A short change log highlig...

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

Διαθέτω έναν βασικό πίνακα 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 ...

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