Macro di Excel Jobs

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

J’ai besoin de mettre en place un formulaire de type sondage, relié soit à Google Sheets soit à Excel, selon la solution la plus fluide. Le but est de recueillir : • Nom et prénom • Adresse email • Numéro de téléphone Tout en laissant la possibilité au répondant de rester anonyme s’il le souhaite. Concrètement, je souhaite : 1. Un formulaire clair et responsive (Google Forms ou alternative Excel) qui alimente automatiquement une feuille de calcul. 2. Un mécanisme simple (case à cocher ou logique de saut de page) permettant au participant de choisir entre répondre de façon identifiée ou anonyme, sans casser la structure des données dans la feu...

I’m looking for a well-structured Excel workbook that mirrors the screenshot I’ll share and streamlines our daily paperwork at the forecourt. The sheet has to accommodate two MPDs with eight nozzles in total—four dispensing Petrol (MS) and four Diesel (HSD). I’ll key in the opening and closing meter readings manually, so the template must automatically calculate volume sold, deduct any testing quantity, and extend totals, all driven by a per-litre rate I can change each day. Colour-coded sections are important to me: one colour for MS, another for HSD, and a clearly separated collection panel. The collection area needs columns for Cash, Paytm, PhonePe, Swipe Card, DG, Credit, Coin and Tiffin, with a grand total that feeds into a Status/Difference line comparing mon...

I’m looking for a well-structured Excel workbook that mirrors the screenshot I’ll share and streamlines our daily paperwork at the forecourt. The sheet has to accommodate two MPDs with eight nozzles in total—four dispensing Petrol (MS) and four Diesel (HSD). I’ll key in the opening and closing meter readings manually, so the template must automatically calculate volume sold, deduct any testing quantity, and extend totals, all driven by a per-litre rate I can change each day. Colour-coded sections are important to me: one colour for MS, another for HSD, and a clearly separated collection panel. The collection area needs columns for Cash, Paytm, PhonePe, Swipe Card, DG, Credit, Coin and Tiffin, with a grand total that feeds into a Status/Difference line comparing mon...

I have three-to-four separate Excel workbooks (about 100 MB total) that track related data streams. I need a single, clean Excel dashboard that automatically pulls, merges and refreshes those numbers whenever the source files are updated. Here’s what I’m expecting: • One master .xlsx file that uses native Excel tools—Power Query, PivotTables, slicers or any technique you find best—to connect to each source workbook, consolidate the data and present it in a set of well-designed charts, tables and KPIs. • All links set up so that a simple Refresh brings in new data without breaking formulas, formats or visuals. • Clear, in-file notes (or a short PDF guide) explaining where the connections live and how to add or remove a source file in the futur...

I have over ten existing price templates that all follow the same column structure, but each one serves a different customer tier and that data needs to be inputted into the most up to date price template. I need them merged into one clean, well-organized master workbook in Excel. Your task is straightforward: enter the current pricing data exactly as provided, consolidate every template into a single sheet, and add a clear tier reference so that I can filter or pivot by customer level later. Accuracy is critical—formulas, cell formats, and any hidden calculations from the originals must carry over without corruption. If a lookup table or a dynamic named range will keep things tidy, please set that up for me. Deliverables: • One master Excel file containing every price poi...

I maintain a master price sheet (the “source” workbook) and a client-facing quote sheet (the “destination” workbook). I need the destination file to pull prices automatically from the source file through standard Excel formulas rather than macros or Power Query, so the link remains transparent and easy to audit. Inside the destination sheet the user must be able to customise a quote through: • dropdown lists that drive item selection • checkbox selections that add or remove optional services As users make choices, the relevant rows—or whole quote sections—should appear via simple drag-and-drop or copy-down actions, with all pricing fields updating instantly from the source workbook. Future maintenance is also critical. New products or pr...

>Registrati o accedi per visualizzare i dettagli.

I'm seeking an expert to help me with Excel-related accounts issues. Key Areas of Assistance Needed: - Discuss accounts issues with an expert - Help with Excel formulas and functions, specifically VLOOKUP and HLOOKUP Ideal Skills and Experience: - Proficiency in Excel, especially in VLOOKUP and HLOOKUP - Experience in handling accounts-related tasks in Excel - Ability to explain complex concepts in a simple manner - Strong problem-solving skills Looking forward to your expertise!

I am writing to express my interest in your project regarding the consolidation of multiple Excel files into a master spreadsheet. I understand that for your system, precision, naming conventions, and data integrity are non-negotiable. Why I Am the Right Fit for This Task: I don’t just "copy and paste." I treat data entry as a technical process to ensure your system receives clean, error-free uploads: Data Scrubbing: I will use functions like TRIM and CLEAN to remove stray spaces and hidden characters that often cause upload errors. Format Integrity: I will ensure that SKUs and Descriptions remain as text, while Quantities and Prices are strictly maintained in Number/Currency format without losing decimal precision. Attention to Detail: I will proactively fl...

I have a current excel spreadsheet that i record my options trades in. I didnt' design the spreadsheet. I want to recreate the current excel spreadsheet with a couple extra things. This should be a fairly easy job since I already have the excell workbook done and just need to recreate it with a couple changes. Please let me know if this is a project you could take on. Again, this should be fairly easy with the right designer.

I need an interactive Excel dashboard that turns my raw sales data into clear, weekly insights. The primary focus is tracking sales performance, so the layout must highlight both our overall sales volume and how that volume breaks down by region. Data will be refreshed every week. With that in mind, the file should be structured so I can drop in a new data dump and see the visuals update automatically—no manual re-linking or reformatting. Slicers or simple drop-down filters for date ranges and regions are welcome as long as they stay intuitive for non-technical users. Deliverables • One Excel workbook containing: – Dynamic tables feeding all charts – At least two visuals: a headline KPI card for total volume and a region-level comparison (bar, map, or s...

I have a straightforward data-entry job focused purely on spreadsheet management. I will provide the raw data along with the existing workbook; your task is to organise the information, enter any missing figures, verify accuracy and return a clean, fully-updated spreadsheet that matches the current structure. Accuracy is the priority, so please be comfortable with common spreadsheet functions (sorting, filtering, basic formulas) and able to spot inconsistencies quickly. Once the file is complete and double-checked, simply send back the updated version along with a brief note outlining any assumptions or issues you discovered. If you thrive on tidy rows and reliable data, this should be a quick win for both of us.

I have a growing set of customer records that must be brought into a single, reliable Microsoft Excel workbook. The work involves three clear steps: • Data entry – transfer raw customer details I provide (names, contact info, purchase history, notes) into a structured Excel template. • Data cleaning – de-duplicate, standardise phone and email formats, and flag any incomplete fields so our CRM import runs smoothly. • Basic analysis – add pivot tables and simple charts that highlight total customers by segment, recent purchase frequency, and any notable trends you spot. Everything has to stay inside Excel—no outside tools—so a solid command of formulas, data validation, conditional formatting, and pivot tables is essential. I will review the...

I'm looking for an Excel sheet to help plan projects by calculating and categorizing expenses. Requirements: - Track and categorize expenses: Products, Labor, Miscellaneous, Subtrades - Automatic calculations for totals - Expense categorization for better organization Ideal Skills: - Proficiency in Excel - Experience with automatic calculations and data organization

I have several months of raw sales transactions in Excel that need to be cleaned, organized, and transformed into formal financial reports. The source sheets include order dates, SKUs, unit prices, discounts, tax, and payment method details; nothing is yet summarized or categorised. Your job is to: • Tidy the data (remove duplicates, standardise date and currency formats, flag anomalies). • Build an Income Statement that automatically rolls up revenue, COGS, gross margin, operating expenses, and net profit. • Build a Balance Sheet driven by the same dataset, updating assets, liabilities, and equity as new rows are added. Both reports must stay fully formula-based—no hard-typed totals—so that I can paste next month’s sales and instantly refresh the f...

I have several Excel workbooks that already contain raw customer information, but they’re scattered across different tabs and follow no consistent structure. I need someone to consolidate every record into a single, clean master sheet, standardise the column headers, and ensure all values (names, phone numbers, email addresses, addresses, etc.) are formatted uniformly. Accuracy is critical, so I will be checking for duplicates and incomplete fields. You are free to rely on functions such as VLOOKUP/XLOOKUP, Power Query, or pivot tools—whatever speeds up the process without compromising quality. When you finish, I expect one tidy .xlsx file ready for import into our CRM plus a short note outlining any assumptions, data issues you encountered, and how you resolved them. If th...

I have several Excel workbooks that need to start running themselves today. The goal is simple: turn my manual, time-consuming routines into push-button macros. The focus is on two areas: • Generating polished, ready-to-send reports from raw sheets • Cleaning and transforming data so downstream formulas, pivots, and dashboards work flawlessly Everything sits in Microsoft Excel and must be handled entirely with VBA. No add-ins or external tools are required—just clean, well-commented VBA modules that I can maintain later. I will provide the current files and a quick walkthrough of the reporting logic and data issues. From there, I need: 1. A single workbook (or a small set, if separation makes sense) containing fully automated procedures. 2. Clear triggers&mda...

I’m consolidating a collection of product details that currently live in multiple Excel sheets. Before these records move into our live system, they must be entered accurately and made analytics-ready. Here’s what has to happen: • Data cleaning & verification – detect typos, duplicate SKUs, or incomplete attribute fields and correct them. • Formatting & organizing – structure columns uniformly, apply consistent naming conventions, and ensure every record aligns with our template so the import runs smoothly. • Analysis & reporting – once the file is clean, generate a brief summary (e.g., item counts per category, missing image percentages) so I can validate data health at a glance. The final hand-off will include the clean...

We are looking for an experienced Excel automation specialist to help connect two existing Excel workbooks used in a digital media workflow: Traffic Sheet Workbook (placement-level trafficking instructions) CMW (Creative Specs) Workbook (creative details: ad names, rotation %, flight dates, etc.) Currently, these documents are separate and require manual copy/paste of data (e.g., ad names, rotation values, creative flights). We would like to implement a reliable, maintainable way for the Traffic Sheet to automatically pull select fields from the CMW. This is not a redesign of the documents — it is a structured automation enhancement. Current State CMW workbook contains multiple tabs: Standard Display Custom Units Video Audio Traffic sheet is placement-based (one row per placement...

I run a labour‐contract business and need a single Excel file that lets me stay on top of three things every day: (1) how much advance each worker still owes me, (2) what we spend versus what we earn from client companies, and (3) the exact cash and bank position at any moment. Here is the workflow I want reflected in the workbook: • Daily I note every advance handed to a worker and any cash that comes back. • At month-end I record the company’s lump-sum payment and the salary we finally release to each worker, leaving any un-cleared advance to carry forward automatically. • Expenses—transport, materials, incidental costs—should feed straight into a running profit calculation so that, with one click, I can see a simple month-to-date profit figure. ...

I have a backlog of paper-based invoices and receipts that must be keyed into an existing Excel template. Every figure needs to be captured exactly as it appears, with correct dates, vendor names, GST fields and reference numbers, so manual data-entry accuracy is critical. Because these records ultimately feed our Tally ledger, you should understand basic accounting concepts—debits, credits, tax codes—and be comfortable cross-checking your work against Tally reports to be sure totals match. No automated scraping is possible here; it is straight keyboard entry followed by a brief reconciliation step. Deliverable • Completed Excel workbook, fully populated and auto-sum balances matching the physical documents and my Tally control totals. Acceptance criteria •...

I maintain a detailed tracker in Google Sheets (exportable to Excel) that now requires a tidy, professional refresh. The core file already exists; I simply need a skilled pair of hands to: • insert new records that have accumulated since our last update • clean and correct a few legacy rows where the data no longer matches source information • refine or extend formulas so totals, variance calculations, and date-driven reminders run automatically If you are comfortable adding light visual aids—quick charts, pivot summaries, or well-targeted conditional-formatting rules—that would be a welcome bonus, but the first priority is rock-solid data accuracy. Please be ready to work directly in Google Sheets, mirror the changes in an .xlsx copy, and leave concise ...

I have a collection of customer information that must be organised accurately in Excel. Your job is to take the raw details I provide—names, contact numbers, email addresses, and any extra fields I specify—and enter them into a clean, well-structured spreadsheet. The spreadsheet has to follow the column layout I give you, preserve exact spelling, and avoid duplicate records. I will share the source files in batches; each batch should be completed and sent back for a quick review before you move on to the next. I value precision over speed, but I still need a reasonable turnaround so my own workflow isn’t delayed. If you are comfortable handling typical Excel functions—data validation, basic formatting, and simple filtering—that will help keep the file consis...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...