Excel VBA Jobs

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

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.

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

Excel Project Description I have an existing Excel spreadsheet used to track field production, and I need help cleaning it up, updating some information, and building a dashboard with automated reporting. Updates Needed 1. Update Hourly Rate Update the hourly rate across the entire workbook to $65.00. Ensure all formulas and calculations reference this updated rate correctly. 2. Update Field Supervisor Names Replace the current supervisor names with the following: Steve Brent Shane Buzz These should be set up so they can be easily filtered and used in reporting. 3. Update Labor Names Replace labor names with: Anthony Marcus Ricky Levi Caleb Chase Gabe These should also work properly with filtering and reporting. Spreadsheet Cleanup The current sheet needs to be cleane...

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

I need a clean, well-structured Excel workbook that lets me plug in every expense tied to an electrician and instantly see the true labour recharge rate we should be billing. Core costs to be captured • Labour and wages (hourly rates only) • Overhead and administrative costs, specifically the software and tools we use to run the business • Insurance premiums • Vehicle hire fees and ongoing vehicle costs Functionality The sheet must let me update each of these figures quickly, apply any on-cost percentages I specify (super, holiday pay, etc.), roll everything into an annual total, then divide back to an accurate hourly charge-out rate. A separate section should let me add a profit margin so I can test different mark-ups without touching the underlying cost model....

I have an Excel sheet that contains Customer Payment information, and I’m using Pabbly Connect to push that data into QuickBooks. I need a specialist who can jump into Pabbly with me and create the exact field-to-field mapping so every payment record lands in QuickBooks accurately. You’ll review the current Excel column structure, identify the corresponding QuickBooks payment fields, and configure the workflow in Pabbly Connect. Once the mapping is in place, I’d like a quick test run to confirm that a sample payment posts to the correct customer account in QuickBooks without errors. A brief hand-off showing me where to adjust the mapping in the future would be appreciated as well.

I have a spreadsheet whose dates now appear in a mix of styles—some show “12/05/23”, others “05-12-2023”, a few are stored as text strings, and a handful are genuine serial numbers. I need the whole column cleaned so every entry follows one consistent, true-date format that Excel recognises natively. Your task is strictly data cleaning: standardise every date, verify the change with a quick formula check (COUNT, MIN, MAX—whatever you prefer), and hand back a file that requires no manual fixes from me. Feel free to tap Power Query, formula tricks, or simple formatting commands; I only care that the resulting dates sort, filter, and calculate correctly. Deliverables • The cleaned workbook with a single, uniform date format (I’m happy with yy...

I have an existing Excel VBA workbook that is already developed and mostly working fine. However, sometimes it hangs or becomes slow when using buttons in the first sheet. I need a freelancer to review the existing VBA code, fix the issue, and improve the file’s performance and stability without changing the current working logic. This is mainly a small debugging and optimization task, not a full development project.

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'm seeking an Excel expert to resolve AUTOMATION ERROS! errors in my spreadsheet. The cells involved contain a mix of text, numbers, and dates. Ideal Skills & Experience: - Proficient in Excel formulas and error troubleshooting - Experience with handling data types: text, numbers, and dates - Attention to detail and problem-solving skills Please provide examples of similar work done.

I have a collection of Excel/CSV files that need to be consolidated, checked, and polished so they are ready for analysis and reporting. The raw sheets contain a mix of blank cells, occasional typos, uneven date and number formats, and some possible duplicate records. Your job is to: • Enter any missing rows or columns from scanned notes I will supply as images or PDFs. • Review every field, correcting obvious spelling or numeric errors. • Standardize dates, currencies, percentages, and other formats so each column is consistent throughout the workbook. • De-duplicate the data while preserving the first complete record when matches appear. • Return a single, clean Excel file plus the original, unaltered copy for reference. I’ll share the files...

I already have a working Excel workbook in daily use, but its current macros are slow, brittle, and hard to maintain. I need an experienced VBA developer to dive into the existing code, streamline the logic, and add any missing functionality so routine tasks run reliably at the click of a button. Although the immediate scope is limited to Excel, I would like the code written cleanly enough that it could later be adapted for Access or Word–based reporting if the project grows. After an initial review of the file, we can agree on the exact touch-points, but my priorities are: • Refactor or replace outdated VBA modules • Optimise speed and eliminate manual steps wherever possible • Add clear in-line comments and a brief user guide sheet • Leave the workbook f...

I want a single Excel file that lets me drop in fresh sales and purchase data and instantly see what’s happening in the business. The heart of the job is an interactive dashboard—clean, professional, and easy for anyone on my team to grasp at a glance. Here is what I need the file to do: • Automatically refresh whenever I upload a new data file, so no manual copy-pasting. • Display bar, line, and pie charts that highlight both sales trends and purchase trends. • Use pivot tables and slicers to let me drill down by product, date, or supplier without breaking the layout. • Track current inventory levels in real time, flagging low-stock items. • Surface the two KPIs I care about most—product-wise performance and overall revenue growth&mdas...

I need an Excel dashboard to analyze my sales and purchase data. The dashboard should provide insights on sales trends, purchase trends, and inventory levels. Requirements: - Visual elements: charts, graphs, tables, and pivot tables - Periodic data updates Ideal Skills and Experience: - Proficiency in Excel, especially in creating dashboards - Experience with data visualization - Ability to set up periodic data updates Looking forward to your proposals!

I’m approaching my last assignment, an online exam that will test my overall proficiency in Microsoft Excel, and I want an experienced Excel specialist to guide me through the preparation process. The goal is to make sure I can complete every task confidently during the live assessment, from structuring data correctly to using core features without hesitation. Here’s what I’m looking for: • A short, focused review session to pinpoint any weak spots in my workflow. • Targeted practice questions that mirror the typical exam format. • Clear explanations of why each solution works so I can replicate the steps on my own. • Live walkthroughs—screen-sharing or annotated screenshots—demonstrating the fastest, most reliable methods inside Exc...

I need an Excel expert to fix formula errors in my resource management workbook. One worksheet isn't correctly pulling hours required by employee type from other sheets. Requirements: - Excel proficiency - Experience with complex formulas - Problem-solving skills Please provide relevant experience in your application.