Excel VBA Jobs

I keep a running list of every lumpsum, SIP and SWP I make, but right now all I have is a raw spreadsheet. I need a single Excel workbook that turns that manual entry into clear, fully-automated insights on my mutual-fund portfolio. Here is what I have in mind: • One Transactions sheet where I will continue to type or paste each deal (lumpsum, SIP, SWP, redemption, etc.). • A Holdings statement, organised the way mutual-fund investors actually think—fund-wise totals with units held, average cost, current NAV, current value, and unrealised gain/loss in both ₹ and %. • Dynamic reports that spin off automatically from the data: – Detailed transaction register – Valuation snapshot that recalculates the moment I update NAVs – A concise...

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 an Excel workbook that lets me stay on top of my day-to-day personal finances. The layout has to be clean and clearly labeled so I can spot where my money is going at a glance, yet remain fully editable when I decide to add or rename categories. Core tracking starts with Housing, Utilities, and Entertainment. I’ll be entering new data every day, so the sheet should automatically roll those entries into running totals, a monthly snapshot, and a simple visual summary (a chart or dashboard is fine as long as it stays lightweight). Formulas must be protected from accidental edits, but every input field needs to stay open for quick manual updates. Please structure the file for future growth—if I want to insert a new category later, I should be able to do it without breaking...

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

*Excel Assignment Help Needed* I am looking for someone experienced in Microsoft Excel to complete an assignment for me. Project Details: I have an Excel assignment that needs to be completed professionally, including data entry, formatting, and applying formulas/functions as required. The work must be accurate and well-organized. Requirements: - Strong skills in Microsoft Excel - Knowledge of formulas (SUM, IF, VLOOKUP/XLOOKUP, etc.) - Data cleaning and formatting - Ability to create tables/charts if needed - Attention to detail and accuracy Deadline: I need this completed within the given timeframe (will be shared after hiring). Files: I will provide all required instructions and raw data after hiring.

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 need a detailed comparison between purchase orders and acknowledgements. The task involves identifying discrepancies in several areas: Discrepancy Types: - Line item discrepancies - Quantity discrepancies - Price discrepancies - Line numbers and descriptions may not match exactly Ideal Skills and Experience: - Proficiency in PDF comparison tools - Attention to detail - Experience with purchase orders and acknowledgements

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.

Hi there! Fixed budget & Looking for resonable canditade allowed! I need to streamline a recurring data-analysis routine that currently takes me hours of manual work each week. The raw data arrives in several worksheets and, from there, I want one clean, automated flow that: • pulls the latest dumps into a master sheet • applies dynamic formulas and functions to flag key metrics, spot variances, and summarise totals automatically • refreshes itself with a single click so I can hand the file to colleagues with zero additional steps Formulas and functions sit at the core of this job. If you decide that a few pivot tables or quick charts would clarify the insights, I’m open to that, but the heavy lifting must happen through well-structured formulas that are easy to...

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

So this is the task. There is a look up of different cities Tampa, Pune, Chennai etc. I place people across Jan to Dec and it should calculate the net cost. If total cost is more than allowed total, then turn the cells P2 - P5 red. If less than, turn blue. If equal, turn is: green.

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

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 need a detailed comparison between purchase orders and acknowledgements. The task involves identifying discrepancies in several areas: Discrepancy Types: - Line item discrepancies - Quantity discrepancies - Price discrepancies - Line numbers and descriptions may not match exactly Ideal Skills and Experience: - Proficiency in PDF comparison tools - Attention to detail - Experience with purchase orders and acknowledgements

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 manage billing at a busy super-mart and the daily volume of customer details is now more than I can comfortably maintain on my own. I’m looking for a reliable data-entry clerk who can step in on a part-time basis and keep our customer information clean, complete, and up-to-date in Google Sheets. Here’s what you’ll do: • Log customer names, contact numbers, and purchase references from the point-of-sale slips into an existing Google Sheets template. • Double-check new rows for spelling, numeric accuracy, and consistent formatting. • Flag duplicates or incomplete entries so I can resolve them quickly. • Save and label each day’s sheet revision before your shift ends, ensuring I can trace changes if needed. Acceptance criteria: • 100 ...

I manage billing at a busy super-mart and the daily volume of customer details is now more than I can comfortably maintain on my own. I’m looking for a reliable data-entry clerk who can step in on a part-time basis and keep our customer information clean, complete, and up-to-date in Google Sheets. Here’s what you’ll do: • Log customer names, contact numbers, and purchase references from the point-of-sale slips into an existing Google Sheets template. • Double-check new rows for spelling, numeric accuracy, and consistent formatting. • Flag duplicates or incomplete entries so I can resolve them quickly. • Save and label each day’s sheet revision before your shift ends, ensuring I can trace changes if needed. Acceptance criteria: • 100 ...

I manage billing at a busy super-mart and the daily volume of customer details is now more than I can comfortably maintain on my own. I’m looking for a reliable data-entry clerk who can step in on a part-time basis and keep our customer information clean, complete, and up-to-date in Google Sheets. Here’s what you’ll do: • Log customer names, contact numbers, and purchase references from the point-of-sale slips into an existing Google Sheets template. • Double-check new rows for spelling, numeric accuracy, and consistent formatting. • Flag duplicates or incomplete entries so I can resolve them quickly. • Save and label each day’s sheet revision before your shift ends, ensuring I can trace changes if needed. Acceptance criteria: • 100 ...

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 have a working Excel VBA macro that end-users should be able to run, but I don’t want them to see or tinker with the underlying code. I’d like you to implement password protection on the VBA project so that: • The code window stays hidden unless the correct password is entered. • Users can still execute the macro without needing that password. • Both viewing and editing the code are blocked. Compatibility needs to span any common desktop build—Excel 2016, 2019, and Microsoft 365—so please use methods that work across those versions with no add-ins required on the client’s side. Deliverables I expect: 1. The secured workbook (or a stripped-down sample if you can’t touch my production file) with the password protection in place. 2. ...

Tôi đang tìm một chuyên gia Excel có thể hướng dẫn tôi sử dụng phần mềm thành thạo cho công việc văn phòng hằng ngày. Những gì tôi mong đợi: • Giải thích rõ ràng các hàm và công thức cơ bản đến nâng cao (SUM, IF, VLOOKUP, PivotTable…). • Tư vấn cách định dạng bảng tính, quản lý dữ liệu và trình bày báo cáo chuyên nghiệp. • Cung cấp file ví dụ, bài tập thực hành và đáp án để tôi tự luyện sau mỗi buổi. • Hỗ trợ qua Zoom hoặc Google Meet, có thể chia sẻ màn hình, ghi lại phiên học để tôi xem...

I have 300 weekly Excel files, each following the same layout, and I need their key metrics rolled into one master workbook. I’m running the latest Excel from Office 2024, so Power Query is available and should be the ideal tool for this. What I want: a single, refreshable table that automatically pulls ten fields from every weekly file—dates, ROR, fund balances, calculated withdrawal amounts, and six other columns already labelled the same way across all workbooks. All 300 files sit in one folder; more will be added over time, so the solution has to cope with new files without extra setup. Please configure Power Query to: • Connect to that folder • Extract the ten columns in their native data types • Load everything into one structured table I can sort, ...