Macro di Excel Jobs

I need help restoring a corrupted Excel 2016 file. The file primarily contains text and numbers. Unfortunately, I don't have any previous versions or backups. Ideal skills and experience: - Proficiency in Excel, particularly 2016 or later - Experience with file recovery and repair tools - Familiarity with handling corrupted Excel files - Ability to recover data without backups

We need an experienced Excel MIS / Business Analyst freelancer to validate and improve an Excel-based garment manufacturing order tracker. I have an Excel workbook that follows each garment order from buyer PO through merchandising, procurement, production, dispatch, GRN and finally payment follow-up. Right now it falls short in three obvious ways: formulas misfire, the workflow feels tangled, and key data fields are either missing or only half-filled. Because the sheet’s core job is to let me monitor production progress in real time, those gaps make day-to-day factory use frustrating. I’m looking for a freelancer who can step in, audit everything, and turn the file into a practical, error-free tool. A background in garment manufacturing or export operations will help you un...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I need a VBA-powered, macro-enabled workbook that lets a user press a single button to pull raw data from fixed worksheets, crunch it, and output a polished summary report. The flow is entirely manual—no scheduled tasks—so the code should run only when the user triggers it. Here is what I picture: • A clean interface element (ribbon button or clearly labeled worksheet control) that launches the macro. • The macro gathers data from predefined tables, applies any necessary filters or calculations, then populates a separate “Report” sheet with formatted tables and charts ready for printing or PPT export. • Well-commented VBA code so I can adjust ranges or add new fields later. Please build the workbook in the current desktop version of Excel for Window...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

We need an experienced Excel MIS / Business Analyst freelancer to validate and improve an Excel-based garment manufacturing order tracker. I have an Excel workbook that follows each garment order from buyer PO through merchandising, procurement, production, dispatch, GRN and finally payment follow-up. Right now it falls short in three obvious ways: formulas misfire, the workflow feels tangled, and key data fields are either missing or only half-filled. Because the sheet’s core job is to let me monitor production progress in real time, those gaps make day-to-day factory use frustrating. I’m looking for a freelancer who can step in, audit everything, and turn the file into a practical, error-free tool. A background in garment manufacturing or export operations will help you un...

Necesito una sola hoja de cálculo, preferiblemente en Excel, que me permita administrar de principio a fin la asignación del personal de cubierta. En la primera sección debo poder cargar la lista de trabajadores junto con su Departamento y su Subespecialidad; estos dos datos son imprescindibles además del nombre y demás campos básicos. Cada trabajador tendrá un registro claro de sus cursos obligatorios. Los que necesito reflejar son exactamente: CPO, ABORDAJES, CONTRAINCENDIO, CONTROL DE AVERÍAS, OCA, PARTIDA DE VUELO, MOTORISTA BOTE RHIB y GRÚA. Además, quiero incluir una calificación numérica o alfabética que me ayude a ponderar su nivel de entrenamiento tanto en Navegación como en Puerto. ...

Create Full fleged Astrological Software with complete following modules : Birth Data Management Module * Astronomical Calculation Engine * Ephemeris Integration Module * North/South/East Chart Rendering Module * Divisional Charts Module * Planetary Position Calculation Module * House & Bhava Calculation Module * KP Cusp Calculation Module * Nakshatra & Sub-Lord Engine * Planetary Strength Analysis Module * Avastha Calculation Module * Shadbala Calculation Module * Ashtakavarga Engine with editing RULE * Sarvashtakavarga Module * Dasha Calculation Engine * Vimshottari Dasha Module * Ashtottari Dasha Module * Yogini Dasha Module * Multi-Level Antardasha Engine * Transit Analysis Module * Gochar Prediction Module * KP EVENT Significator Engine with EDITING RULE * Ruling Planets Modu...

I need an Excel-based log sheet for trip details plus a user-friendly console that drivers can open, fill out, and save without touching the underlying tables. The workbook must: . Printable Excel sheet and • Guide each driver through mandatory fields with clear data validation so missing or wrongly formatted entries are blocked on the spot. • Perform automated calculations—totals, mileage differences, fuel cost per kilometre, and any other running sums that make end-of-day reporting effortless. • Offer an instant search and filter panel so I can pull up any past trip or driver record in seconds. I’m happy with a protected sheet interface or a VBA userform—whichever delivers a clean, button-driven experience for non-technical users. Final delivery ...

My current invoicing workbook needs to move from “mostly manual” to fully automatic. The core of the job is to build an Excel-based solution that: • Instantly generates a clean invoice sheet from order data • Pulls and pushes data through reliable import/export routines (CSV, XLSX or Power Query—whatever is most robust) • Performs every total, tax and discount calculation without the slightest manual tweak On top of that foundation I need two extras that matter a lot to the workflow: switchable custom templates (so I can brand invoices for different business lines) and a live connection to mainstream accounting software. Think of the integration as a one-click post of the final invoice straight into the ledger, keeping GL codes, customer IDs and pay...

I have a series of Excel documents that contain only text—no numbers or formulas—pulled together from earlier reports. Your job is to take that text exactly as it appears and enter it into the data capture template I’ll share once we start. Accuracy matters more than speed; the wording, spacing, and capitalization must match the source files so downstream searches work correctly. You will receive: • A folder of Excel files, each clearly named. • A simple web-based form with fields that mirror the column headers in those spreadsheets. Your deliverable: • The online form fully populated for every row in every file, with no typos or omissions. I will run a spot-check before sign-off. If you’re comfortable working line-by-line in Excel and have a goo...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I need a fully-functional severance calculator built directly in Microsoft Excel so our HR team can run it on Windows machines without additional software. The worksheet should allow users to enter the following variables in clearly labelled input cells: • Years of service • Age of employee • Job position • Job grade • Short-term incentive eligibility Province Based on these inputs the file must return the correct statutory and common-law severance entitlements for Canadian employees, following current federal and provincial guidelines. All formulas should be transparent, with assumptions documented in a hidden but unlockable sheet so we can update rates later. Deliverables • Unlocked Excel workbook with user-friendly input area and results da...

I have two related workbooks. Sheet 1 is my working file; Sheet 2 holds the customer information I need to reference. Both sheets share a unique reference code, and I want a single, reliable formula—ideally built with HLOOKUP—to pull the customer data into the correct columns of Sheet 1 every time the reference appears. Here’s how I’d like to tackle it: • We jump on a quick 30- to 45-minute call with screen-share. • You review the current structure, insert the lookup formula where it belongs, and test it on a few rows. • You leave me with a short note explaining how the formula works so I can extend or tweak it later. I prefer HLOOKUP because the customer fields run across columns, but I’m open to VLOOKUP or INDEX/MATCH if you think they&...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I have a series of Excel documents that contain only text—no numbers or formulas—pulled together from earlier reports. Your job is to take that text exactly as it appears and enter it into the data capture template I’ll share once we start. Accuracy matters more than speed; the wording, spacing, and capitalization must match the source files so downstream searches work correctly. You will receive: • A folder of Excel files, each clearly named. • A simple web-based form with fields that mirror the column headers in those spreadsheets. Your deliverable: • The online form fully populated for every row in every file, with no typos or omissions. I will run a spot-check before sign-off. If you’re comfortable working line-by-line in Excel and have a goo...

I have an Excel workbook packed with productivity figures that needs to tell its story clearly in an upcoming presentation. My audience is non-technical, so visuals must be intuitive: clean tables with strategic highlights rather than complex charts. Here’s what I need: • A set of formatted tables that surface the key productivity metrics—think conditional-formatted cells, sparklines, or color-coded variances—so trends and outliers pop at a glance. • An easy-to-follow layout: summary at the top, detailed breakdowns below, each section clearly labeled for quick navigation when I’m presenting. • Light automation where it helps (simple formulas, named ranges, perhaps a few slicers) so I can refresh the data without re-doing the design. Accept...

I need someone who can sit with me this afternoon and again tomorrow afternoon in Daman or Vapi and help knock out a very simple Excel task. The file contains mixed data that just has to be copied and pasted into the right spots, then given a quick tidy-up. After a five-minute walkthrough I’ll provide, your job is to: • enter the records exactly where shown, • use basic formatting only—mainly data sorting, filtering, and a couple of straightforward formulas to keep totals correct. No macros, no complex analytics—just clean, accurate entry and a neatly organised sheet by the end of each half-day. Bring a solid grasp of Excel shortcuts, show up on-site for both sessions, and we’re good to go.

I have a sales performance sheet. I want an experienced person who is specialized in advanced Excel formulas and who can automate the sheet. The sheet is already automated. Some of the formulas are not working, and I want to add some more stuff into it, so I need someone who can actually do the stuff.

Complete Excel-Based Business Record Management System I need a complete Excel-based business management system to maintain all daily business records in a professional and organized way. The file should be user-friendly, automated, and easy to manage. The system should include the following modules: 1. Customer Ledger Customer Name Contact Number City Opening Balance Debit / Credit Entries Outstanding Balance Customer Transaction History 2. Supplier Ledger Supplier Name Purchase Records Payment Records Remaining Payable Amount Supplier History 3. Stock / Inventory Management Item Name SKU Code Stock In / Stock Out Current Available Stock Purchase Price Sale Price Low Stock Alert 4. Expense Management Daily Expenses Expense Categories Cash Expenses Monthly Expense Summary 5. Bank & C...

Project Title Complete Excel-Based Business Record Management System Project Description I need a complete Excel-based business management system to maintain all daily business records in a professional and organized way. The file should be user-friendly, automated, and easy to manage. The system should include the following modules: 1. Customer Ledger Customer Name Contact Number City Opening Balance Debit / Credit Entries Outstanding Balance Customer Transaction History 2. Supplier Ledger Supplier Name Purchase Records Payment Records Remaining Payable Amount Supplier History 3. Stock / Inventory Management Item Name SKU Code Stock In / Stock Out Current Available Stock Purchase Price Sale Price Low Stock Alert 4. Expense Management Daily Expenses Expense Categories Cash Expenses Mo...

My phone book currently lives in a single .xlsx file and holds about 200,000 records. I need that sheet cleaned and standardised in two key ways: 1. Every duplicate number—regardless of whether it carries the +91 prefix or not—must be identified and removed so each contact appears only once. 2. Phone numbers must carry a consistent format for the Indian market. That means adding or stripping “+91” wherever required so each final entry follows one clear rule (I’m happy to agree on the exact rule with you before you start so we’re on the same page). The end result I’m after is a fresh Excel workbook with: • Zero duplicate rows • Uniformly formatted mobile numbers • No broken formulas, blank rows or stray characters If you ...

I have several existing spreadsheets that contain a blend of text and numerical fields. They now need to be brought together into a single, well-structured Excel workbook. Your task is to copy the data across, preserve every character and figure exactly as written, and apply consistent formatting so the finished file is easy to filter, sort, and run formulas on. Accuracy is essential—please double-check that text strings stay intact, numbers keep their original decimal places, and column headings remain uniform throughout. Where you spot obvious typos or irregular spacing, correct them as you go so the final sheet is clean. Deliverable: • One polished Excel file that merges all source sheets, with data validated and neatly formatted. If you’re comfortable moving mixed d...

Estoy buscando un experto en Excel para el desarrollo (o adquisición) de una Plantilla de Funnel de Ventas Profesional. El objetivo es centralizar la gestión comercial en una herramienta robusta, intuitiva y visualmente atractiva que permita monitorear el ciclo de vida de los prospectos. Estructura Requerida (4 Módulos) Configuración Personalizable: Definición de etapas del embudo, tasas de conversión objetivo y validación de datos. Registro de Prospectos: Base de datos centralizada con campos para contacto, origen, etapa actual, valor de oportunidad y probabilidad. Visualización de Progreso: Pipeline activo con formatos condicionales para detectar cuellos de botella y estancamientos. Dashboard de Rendimiento: Panel visual con KPIs cl...

I have an Excel workbook in which numeric entries are a mess—some are real numbers, others are text strings littered with stray symbols, and quite a few mix commas and periods as decimal separators. I need every monetary figure, in every column that contains numeric data, converted so it behaves as a true number and displays in a single, consistent currency style: the $ symbol with two decimal places. Your task is to hunt through the file, detect any value that should be treated as money, automatically recognise whether the comma or the point is acting as the decimal marker, correct it, and then apply the chosen format. Dates, percentages, text, formulas, and the workbook’s structure must stay exactly as they are; after the cleanup nothing should break or recalculate incorrect...

I have several Excel workbooks that contain a blend of text and numeric fields, and I need every row copied into a single master sheet with 100 % accuracy. Everything you’ll work with is already in digital form, so the task is pure data entry and validation—no scanning or transcription from print. You will receive: • All source spreadsheets • A destination template that shows the required column order and cell formats What I need from you: • Transfer each record exactly as it appears, following the provided column map • Maintain number formatting (decimals, dates, currency) and preserve text capitalisation • Spot-check totals or obvious anomalies and flag anything that looks out of place When you finish, I should be able to open the master shee...

I need an Excel sheet to record users for applications access review. The data should be organized in a pivot table for detailed analysis. This project involves an Applications Access Review, starting with two applications containing sensitive information. The goal is to clean up user access by gathering a list of users from each department in the company. These users will be reviewed, categorized, and unnecessary access will be eliminated. You need to record the following information: - User ID and names - Access levels and permissions - Last access date - Department - Inactive user And any other information that you recommend Ideal skills and experience: - Proficiency in Excel, especially with pivot tables - Experience in data organization and management - Attention to detail

I run a micro-business in Ireland and need the last trading year laid out as a clean, well-structured Excel file. All transactions are already in digital form—PDF invoices, bank CSVs, and card statements—but nothing lives in Excel yet. Your job is to import those records, categorise every line, reconcile totals, and produce both an income-and-expense view and a concise balance sheet that fits Irish micro-entity requirements (very close to UK rules). I don’t have a fixed template in mind, so feel free to suggest or build one that keeps things clear and easy for me to maintain next year. Automation with simple formulas or pivot tables is welcome as long as everything remains transparent. Deliverables • Excel workbook with separate sheets for the raw ledger, summarise...