Excel VBA Jobs

I’m working with a PDF site plan for a 1 MLD Water Treatment Plant and need an accurate Bill of Quantities compiled in Excel. The job is limited to structural components only—think excavation, concrete, reinforcement, formwork, masonry and any other load-bearing elements that appear on the drawing. Finishes, utilities and services are outside the scope. Everything must be expressed in metric units (metres, square metres, cubic metres, kilograms of steel, etc.). Set up the workbook so each line shows: item description, drawing reference, unit, quantity and a remarks column for notes or assumptions. Include a second sheet (or clearly separated section) that shows the take-off calculations you used so I can trace every figure back to the site plan. Deliverables • Main BOQ...

I need a fully linked, three-statement financial model for PVR INOX Ltd that I can rely on for valuation analysis. The model must cover a single fiscal year and flow seamlessly from the Income Statement through the Balance Sheet into the Cash Flow Statement, with schedules for working capital, capex, and debt clearly feeding back into the core sheets. Because this will underpin my own discounted cash-flow and multiple-based checks, accuracy and transparency are critical. Please build in clean, traceable formulas, keep hard-codes isolated, and structure the file so assumptions can be tweaked without breaking the model. I typically work in Excel, so deliver in .xlsx with no macros unless absolutely necessary. Deliverables • Integrated 1-year Income Statement, Balance Sheet, and ...

I need an Excel document (one work book, two pages) reviewed and edited for an upcoming client presentation. The primary focus is on improving the formatting and layout. Key requirements: - Adjust font and color scheme - Modify cell borders and shading - Refine page layout (margins, orientation) Ideal skills and experience: - Proficiency in Excel - Strong eye for design and detail - Experience with professional document formatting Please ensure the document is polished and ready for presentation.

I’m looking to centralise all of my monthly habits in a single Excel workbook that feels more like a dashboard than a spreadsheet. For every habit I want two core data points: a simple Yes/No to confirm the habit was completed during the month and the total time I spent on it. As the data builds, I’d like automatic visual feedback—clean charts, clear graphs and intuitive progress bars that refresh themselves whenever I enter or modify a value. The file should be easy to expand; I’ll probably add and archive habits over time, so formulas, tables or pivot-based solutions that scale without much manual tinkering are essential. A polished, at-a-glance dashboard (think conditional formatting, percentage rings or bar visuals) that rolls up performance for the current mon...

I have several raw data files that need to be organised in Excel so the information is accurate, searchable, and presentation-ready. The core of the job is straightforward: • Enter data from PDFs and text documents into Excel with zero transcription errors. • Clean and format every column—remove duplicates, correct dates, apply consistent number formats, and set up clear headings. • Build or update spreadsheets so totals, subtotals, and simple analytical views (filters, sorts, conditional formatting) work smoothly. I will provide the source files and a brief for each sheet. All work should stay within Excel; no third-party add-ins are required. Turnaround for the first batch is three days, and I’m happy to review interim files as you progress to ensure we s...

Busco un archivo Excel que combine en un mismo lugar plan de alimentación y rutina de entrenamiento para mis clientes Necesito: • Planificación completa de comidas: desayuno, almuerzo y cena, con celdas para raciones, macros y calorías que se actualicen automáticamente al cambiar los ingredientes. que incluya calculo de macros y micros al introducir los datos y cantidad de kcals, introduciendo el tipo de dieta, ya sea de intercambio de alimentos • Seguimiento de progreso: tablas y gráficos que recojan peso, medidas corporales y evolución semanal, todo calculado de forma automática. • Recomendaciones de ejercicio: hojas dedicadas a cardio, fuerza y flexibilidad, con espacio para registrar series, repeticiones, tiempos y ...

I have a collection of information that needs to be keyed into an Excel workbook and structured across several sheets rather than a single table. Your task is to take the raw data I provide, enter it accurately, and lay it out so that each logical section lives on its own tab while common fields remain consistently formatted throughout. Accuracy and neat organisation matter more to me than speed. Every value must match the source exactly, formulas (where required) should calculate correctly, and each sheet must be clearly named for quick navigation. Deliverable: • A single Excel file containing all data, organised across multiple, clearly labelled sheets, ready for immediate use and analysis. If you are comfortable working in Excel and confident in your attention to detail, I look ...

I'm looking for a developer to create a medical readiness tracker for a military unit. This tool will help us upload specific reports and sort, compute, and identify deficiencies. Key requirements: - Upload specific reports via batch file uploads - Sort and compute inputs to a roster - Identify deficiencies: - Medical exams overdue - Dental exams overdue - Medical profiles - Calculate metrics like percentage of readiness Ideal skills and experience: - Strong background in data management and software development - Experience with batch file processing - Familiarity with military medical requirements is a plus - Proficient in creating sorting and computation algorithms Can provide live examples of the imports will be using. At this time Planning on copying and pasting imports...

I’m putting together a personal-finance coaching workbook and need an Excel expert to turn my outline into a polished, user-friendly file. The core of the job is a 12-month layout (January through December) with a clear yearly dashboard that automatically rolls up every figure. Users will open this file on Excel for Office 365 and Excel Online, so every formula, table, and link has to behave perfectly in those environments and display well on phones as well as desktops. Each monthly sheet should include sections for Income (broken down into Salary/Wages, Investments, and Other Income), Expenses, and an at-a-glance Net Total. All totals must flow up to the summary page without complicated array formulas or VBA; simple SUM, SUMIF/SUMIFS, and basic links are fine so clients can audit o...

I need multiple Excel spreadsheets brought together into one clean, automated workbook that updates itself and delivers clear reporting and analysis. The source files hold similar data structures, so the key tasks are to merge them reliably, build VBA macros to refresh the data with one click, and present the consolidated figures in easy-to-read summary sheets. What success looks like • A single master file that pulls from all current and future source sheets without breaking existing formulas • Automated macros that handle data import, de-duplication, and error checking • Well-formatted summary tabs that give me instant insights instead of manual copy-paste work When you reply, focus on the experience you have building comparable Excel solutions—particu...

I want to convert my current Excel file into a simple fleet management system for our bus operations. Right now we are creating a separate sheet for every day’s collection. Instead of that, I want a better structure where we only enter the daily data once and all reports are generated automatically. The system should have one main sheet called DATA ENTRY where we enter the following columns: Date Route No Bus No Driver Conductor Total Collection RFID Collection HSD Litres (diesel filled) Expense From this data Excel should automatically calculate: HSD Cost = HSD Litres × Diesel Rate (currently ₹91) Net Collection = Total Collection − Expense If Net Collection becomes negative, it should automatically appear in red. From the DATA ENTRY sheet I want Excel to automati...

I have 1,000 customer records that are already fully organized, and I’ll share a clean Excel template with predefined columns for name, address, phone number, and email. All I need is for you to transfer the data into that sheet, complete the work within three days, and run a quick round of validation and cleaning so every field is consistently formatted and error-free. Because the source list is tidy, the job is mostly steady typing and copy-paste, but close attention to detail is essential—misspelled emails or shifted cells will break my downstream import. I’m comfortable with any of the usual Excel techniques (data validation rules, conditional formatting, text-to-columns, etc.) as long as the finished file is ready to use straight away. Deliverables: • Final Ex...

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

I need two small Windows utilities built as stand-alone .exe files, each with a simple point-and-click interface (no command line). Utility 1 – Excel-to-Excel re-formatter • I will pass you a source workbook and the target layout “ERP_CONVERTED_2”. • The tool must map every column exactly into that layout, then sort the sheet so that, within each Account No, the Disbursement dates appear first (oldest-to-newest) followed immediately by the corresponding Collection dates. • Finally, the macro should generate a second sheet in the same file called “VITRAN VASULI” that shows a dropdown-driven view arranged Account-wise in the same row order (Disbursement row first, Collection row next or combined when dates match). Utility 2 – PDF-to-...

I have a compact contact list that I need turned into a polished Excel file. The raw sheet already holds names, emails, and phone numbers, but right now the columns are uneven, some cells are merged, and a few records are duplicated. Here is what I need you to do: • Keep the work in Excel (my preferred platform). • Re-align every piece of data into clear, consistent columns. • Remove duplicate rows so each contact appears only once. • Re-format phone numbers into an international format. • Apply visual touches—bold headers, alternating row colors, and a neat border around every data block—so the sheet is instantly readable. Deliverable: • A single, tidy Excel spreadsheet ready for immediate use.

I need the AIA G702 and G703 application for payment documents recreated in Excel. The final product should be an Excel spreadsheet with custom formulas or calculations as needed. Requirements: - Recreate AIA G702 G703 documents - Deliver as Excel spreadsheets - Include custom formulas as required Ideal Skills and Experience: - Familiarity with AIA documents, particularly G702 and G703 - Proficiency in Excel, especially with custom formulas - Attention to detail and accuracy

I have two bed rooms i need 3d and 3d drawings for excellent looking

I need an Excel macro that searches for whole numbers throughout the entire workbook and copies them to another sheet. Requirements: - Search for whole numbers - Operate on the entire workbook - Copy found numbers to a designated sheet - Editable for adding more search criteria

I need a simple Excel program to track customer scoring daily for a calendar month. Requirements: - Track customer scoring (1-100%) for each day - Manual data entry - Include graphs/charts for data visualization Ideal Skills: - Proficient in Excel - Experience with data visualization in Excel

I developed an interactive BMW Global Sales Analysis Dashboard using Microsoft Excel to analyze sales performance across different regions, models, and time periods. The goal of the project was to transform raw sales data into a clear and insightful dashboard that helps users quickly understand business performance and trends. In this project, I performed data cleaning and transformation, then used Pivot Tables, Pivot Charts, and slicers to create an interactive dashboard. The dashboard includes key metrics such as: *Total Units Sold *Total Revenue *Average Car Price *Total Models Sold It also provides deeper insights through visualizations like: *Monthly sales trend analysis *Sales comparison by region *Revenue distribution by car model *EV growth trend over multiple years *Fuel pri...

Virtual Assistant (Excel Support) – Strategy Consulting Firm We are a boutique strategy consulting firm based in Australia that works with CEOs and Boards of large community organisations. We are looking for a reliable and detail-oriented Virtual Assistant to support our consulting work with data preparation, Excel work, and general administrative support . This is a remote role with flexible hours. Initially the role will involve approximately 10–15 hours per week, with potential to grow over time. Key Responsibilities The Virtual Assistant will support consultants by assisting with tasks such as: • Excel data entry and spreadsheet formatting • Updating performance data in Balanced Scorecard tracking sheets • Basic data cleaning and organising information i...

I have an intermediate-level assignment that must be completed in Excel with the @Risk add-in, and I want to finish it myself while being coached in real time. My main sticking points are building the simulations correctly and interpreting the risk analysis output that follows, so I’ll need you to explain each step, verify my formulas, and help me understand the Monte Carlo results rather than simply doing the work for me. Speed is important—I’m ready to start as soon as you are and would like to wrap this up quickly. Because this is a walkthrough, live collaboration (screen-share or similar) is essential. I’m comfortable scheduling multiple short sessions if that’s easier, but I’d like clear milestones so I always know what comes next and can practise ...

Virtual Assistant (Excel Support) – Strategy Consulting Firm We are a boutique strategy consulting firm based in Australia that works with CEOs and Boards of large community organisations. We are looking for a reliable and detail-oriented Virtual Assistant to support our consulting work with data preparation, Excel work, and general administrative support . This is a remote role with flexible hours. Initially the role will involve approximately 10–15 hours per week, with potential to grow over time. Key Responsibilities The Virtual Assistant will support consultants by assisting with tasks such as: • Excel data entry and spreadsheet formatting • Updating performance data in Balanced Scorecard tracking sheets • Basic data cleaning and organising information i...

We are a growing specialty concrete contractor seeking an experienced Excel developer, financial modeler, or budgeting consultant to build a robust, scalable 12-month budgeting tool in Microsoft Excel. Our company operates on a fiscal year of January 1 through December 31 and expects approximately 20% year-over-year growth over the next 3–5 years. We need a budgeting tool that is not only useful for immediate annual planning, but also flexible enough to scale with the business as we continue to grow. The ideal solution will provide both high-level executive visibility and detailed month-by-month budgeting functionality, while remaining easy to update and maintain year after year. Project Scope The Excel workbook should include the following components: 1. Executive Overview / Co...

I need a rolling Excel spreadsheet with the following features: - Data Entry and Validation - Automated Calculations (Sum and Averages) - Manual Input for Data Sourcing Ideal Skills and Experience: - Proficiency in Excel - Experience with Data Validation and Automated Calculations - Attention to Detail and Accuracy Looking for someone to create a user-friendly, efficient spreadsheet. 14 tabs with a corporate total page

I have already drafted an Excel-based dynamic model based on financial data and a set of underlying assumptions, yet the workbook is wrong. I need an experienced accountant to step in, correct formulas, build Income Statement, Balance Sheet, and Cash Flow Statement, and correct everything. Deliverables -Updated and 100 percent correct financial statements based on my comment in the sheets. -Two scenarios to be incorporated in the model (80 percent of the work is actually done). -Updated ratios based on the reference model to be attached in the second stage. No plug numbers to mathematically balance the statements, no misleading figures.

I need a clean, well-structured Excel workbook that will automatically calculate our storage fees at $0.60 per cubic foot. I’ll supply the raw numbers as cubic feet per line item, spanning more than 10 different organizations, so the file must scale gracefully. Workbook requirements • A data sheet where I can paste or import the monthly cubic-foot figures per line item. • Formulas that multiply each entry by 0.60 to generate the charge, then roll those charges up:  - by line item and organization for each month,  - into directorate-level totals for the same period. • Pivot tables that let me view charges month-by-month for every organization and its individual line items, plus a grand-total row for each directorate. • An additional pivot (or...

EXCEL RELATED TASK...IN SIMPLE LANGUAGE EK EXE DEVELOP KRNI H APKO AI SE JISME MAX 10 MIN LGENGE JO ME APKO FORMAT FILE DUNGA USKO APKO ERP_CONVERTED_2 WALE FORMAT ME KRNA H ..FIR APKO USME DATE WALE COLUM ME IS TARH KRNA H JO DISBURSEMENT DATE H SAME ACCOUNTS KI WO EK SATH OLDEST TO NEWEST AAE AND COLL KI B ISI TRAH SE AAE FIR APKO ISKO UTILITIY WITH DROPDOWN WALE FORMAT ME VITRAN VASULI KI SHEET WALE FORMAT ME LEKR AANA H OR USME ACC NO WISE AARANGE KRNA H OR SAME ACCOUNT KI JHA DISURSMENT DATE KI ROW H OR COLL YANI KI VITRAN DATE USKE BAAD KI YA SAME H USI ROW ME ARRANGE KRNA H ...EXE ME GUI DE DO OR 2 SE 3 STEP ME KR DO MAXIMUM BUDGET 2000 RS H OR MUJE30 MIN TO 1 HOOUR ME DE DO

see the attached excel dashboard I need the followings: Combine the Address book and task list with following fields: Customer, Contact Person, Phone, Email, Account Manager, Status, Long description. Rename Process Pipeline to Quote Pipeline with the following fields: Quote Type (Active, Expiring), Status (Won, Lost), Reason for Loss

Our entire pricing catalogue currently sits in a single Excel workbook, but we have a new CMS system that contains a new spreadsheet structure that will serve as the future-proof version of our pricing system. I need every element moved across—product and service descriptions, image links, materials, equipment, labour rates, and any related look-ups—while reshaping the data to fit the new column order, field names, and calculation logic that lives in our new program. Because the new template differs from the old one, this is more than a simple copy-and-paste job; it calls for significant data transformation. You may need to: • split or merge fields, • convert formulas into more efficient functions, • normalise units and naming conventions, and • ...

I have roughly one thousand JPEG images named. Each filename matches a numbered row already laid out in my Excel/Numbers workbook, and every image needs to land in the specific cell that carries its number. I also need every photo resized so it fits cleanly inside its cell without overflowing. I will pass you the folder of JPEGs plus the workbook. You return the same file, now populated with the images in their correct positions and neatly scaled. Accuracy is critical here, so please be comfortable with bulk image insertion and cell-sized resizing in either Excel or Apple Numbers—whichever you prefer as long as the final file opens perfectly on both Mac and Windows. Deliverables: • Updated workbook with all 1,000 images placed in their matching cells • Images resized to...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I have an existing Excel workbook that I use for staff rostering. At the moment every step is manual, so I want the entire process wrapped into one push-button VBA routine. When I click the button the macro should: • Allocate each employee to the required shifts • Detect any conflicts such as overlapping hours or breaches of contracted limits • Check every assignment against the applicable awards and internal policies, preventing non-compliant rosters from being published The file is already structured; your job is to build the automation logic, wire it to a clearly labelled button, and return a macro-enabled workbook (.xlsm) that produces the finished roster on demand. Please comment the code so I can maintain it later and include a brief note or screen recording th...

I need help formatting an Excel sheet that contains novel scenes and chapters. The project is urgent and needs to be completed ASAP. Requirements: - Format Excel for novel scenes and chapters - Use of cell styles and borders Ideal Skills and Experience: - Proficiency in Excel - Experience with cell styles, borders, and organization of complex data - Ability to work quickly and meet tight deadlines

I need an Excel workbook enhanced with VBA that can pull sales data directly from our database, crunch the numbers automatically and present clear, on-demand reports. The focus is pure analysis and reporting—no manual copy-pasting, no repetitive filter steps—just hit a button and the figures are there. Here is what I’m after: • A reliable VBA routine that connects to the database, refreshes the data set, and stores it in well-structured worksheets. • Automated calculations for common sales KPIs—revenue by product and region, period-over-period growth, averages, and any additional measures you suggest that add quick insight. • Polished summary views (pivot tables or a lightweight dashboard) that update whenever the refresh runs, so management can ...

I have an Excel workbook waiting for a fresh set of numeric records. Each figure must be entered exactly as provided—every value is in decimal form—so preserving precision is non-negotiable. Beyond typing, I also need you to run a quick error-check: use whatever light-touch Excel techniques you prefer (COUNTIF, conditional formatting, cross-totals, etc.) to flag blanks, obvious outliers, or mismatches. No elaborate validation rules, just a reliable sanity sweep so I receive a clean, trustworthy sheet. The source file will be in your inbox as soon as we start, and I need the finished workbook back within 48 hours. Accuracy and a sharp eye for inconsistencies are essential; solid experience with Excel data entry will make this task straightforward. Deliverable: • Complet...

I have a set of printed documents that must be transferred into a clean, fully-formatted Excel workbook. Every detail—text, numbers, dates, even blank rows—needs to appear exactly as it does on paper, so the sheets in Excel mirror the originals line for line. I will supply: • High-resolution scans of each printed page. • A short guide listing the precise column headers and sheet names I want used. Your job is to: • Key all data into Excel accurately. • Recreate the printed layout (tables, spacing, bold headers, subtotal rows, etc.) so the file feels like a digital twin of the hard copy. Deliverables 1. A single .xlsx file containing all pages in order. 2. A brief note confirming you have double-checked totals and obvious typos. Accuracy and faithfu...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I have an existing spreadsheet that already holds the framework for one song’s sales performance. Please check the song below Each day I receive fresh numbers that must be copied accurately into the correct rows and columns and saved back to the same file so my reports and charts stay current. Before submitting your proposal please check the references song first this is very important then we can discuss everything exactly what you have to do thank you

I already have an Excel system with a Measurement Sheet (input) and Dashboard. I need a small automation to generate an RA Bill sheet automatically from the measurement data. Requirement: RA Bill should be generated automatically based on the selected RA number. Each Item No. should appear as a heading with its BOQ description. Under each item, the measurement rows should appear automatically from the Measurement Sheet. The table should have these columns: Description | Unit | N1 | N2 | Length | Width | Depth | Qty The Description column should show location/sub-item from the measurement sheet. When entries for the same Item No. end, the system should automatically show Total Quantity. After the total row, the next Item No. section should start automatically. The number of rows under each ...

I need support with a sizeable Excel file that must be reorganised, cleaned and formatted according to the templates I will supply. Your task is to follow those guidelines precisely, arrange the data into the correct column order, remove inconsistencies, standardise dates and numbers, and consolidate multiple sheets into one well-structured master workbook. Accuracy is critical—every cell has to comply with the rules before the project is considered complete—and I expect a quick yet careful turnaround. Deliverables: • Updated, fully formatted Excel workbook in .xlsx • Brief changelog outlining any issues spotted and fixed Let me know your estimated completion time and any questions you may have so we can begin.

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...