Excel VBA Jobs

I have a large, multi-tab Excel file that drives our internal expense-tracking workflow. The workbook contains more than eight interconnected sheets and hundreds of linked formulas. By April 16 - 2026, I need absolute assurance that every reference, calculation, link, and format is correct. Scope • Trace every formula across all sheets—constants, nested IF statements, array formulas, lookups, named ranges, hidden rows, and any pivot elements you uncover. • Compare totals, subtotals, and roll-ups to spot discrepancies between tabs. • Stress-test the model with sample data to confirm balance and integrity. • Optimise or repair anything you find: circular references, broken links, or inefficient logic. • Preserve the existing structure; do not alter t...

I need an Excel expert to fix some issues in my spreadsheet. The project is urgent and I require it to be completed ASAP. Key Issues: - Difficulty with macros - Conditional statements in formulas not working correctly - Colour coding if employees aren't inducted on a particular project - Formulas page where employees have their site and project inductions displayed and easily edited by excel basic users - Fix convoluted formulas within the spreadsheet - If Employees are scheduled for a particular day they disappear from the list to avoid double ups. - Have a tiered system that references project first, site second and job third - Jobs Merge and center under their selected site and sites merge and center under their selected project so they can be all seem in the same area of th...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

I am looking to develop a professional Excel-based system to manage and track daily, weekly, and monthly tasks across multiple departments within our company. Departments include: - Human Resources - Finance - Logistics - Projects - Administration The system should be user-friendly and designed to support management-level monitoring and decision-making. Key Requirements: 1. Main Dashboard: - Total number of tasks - Completed tasks - Delayed tasks - Tasks in progress - Task distribution by department - Completion rate per department 2. Central Task Input Sheet: Should include the following fields: - Department name - Task title - Short description - Assigned person - Start date - End date - Priority (High / Medium / Low) - Status (Not Started / In Progress / Completed / Delayed / On Ho...

I need help getting my Excel macros to work. They don't run at all, and I haven't changed my Excel version or disabled macros. Ideal skills and experience: - Expertise in Excel and VBA - Experience troubleshooting Excel macros - Ability to work on older Excel versions

I have a collection of Excel sheets filled with raw numbers that need to be brought up to date, checked for accuracy, and turned into something I can actually use for decision-making. Your first task is straightforward numeric data entry: complete any missing figures and confirm existing totals with simple cross-checks so everything balances. Once the numbers are rock-solid, I’d like you to move straight into data analysis inside the same workbook—think pivot tables, descriptive statistics, and clear charts that highlight key trends. Please keep all work native to Excel (Office 365 or compatible) and avoid external add-ins so the file remains easy for me to open and audit. Deliverables: • Updated workbook with verified numeric entries • Separate analysis sheet c...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

Détails du projet Descriptif de la mission : Création d'un Tableau de Bord de Gestion Financière sur Excel Objectif : Concevoir un fichier Excel automatisé, professionnel et visuellement attrayant pour le suivi des recettes et des dépenses, avec mise à jour en temps réel des soldes et des graphiques. 1. Structure du fichier : Le document doit comporter au minimum trois onglets distincts : Configuration : Pour lister les catégories de revenus et de dépenses (ex: Salaire, Ventes, Loyer, Fournitures, etc.). Saisie des données : Un tableau propre pour enregistrer chaque transaction (Date, Description, Catégorie, Type [Recette/Dépense], Montant). Tableau de bord (Dashboard) : Une page de synthèse v...

I need an advanced Excel expert to assist with a independent capstone project. The project requires proficiency in: - VBA, Macros, Formulas, and Functions - Data Visualization, specifically Bar Graphs - Creating Custom Functions Ideal skills and experience would include: - Advanced knowledge of Excel and its functions - Experience in automating tasks using VBA and Macros - Strong data visualization skills, particularly with bar graphs - Ability to create custom functions to meet specific project needs Please provide examples of similar work done.

I have raw customer-focused data coming in from several marketing platforms (think Meta Ads, Google Ads, and similar). I need that information cleaned, modelled, and turned into an interactive Excel dashboard that lets me monitor customer acquisition in near-real time. Here is what I’m looking for you to deliver: • A well-structured Excel file that imports the marketing-platform exports, applies repeatable cleaning steps, and stores the tidy tables on separate, clearly named sheets. • Dynamic calculations that surface the key acquisition metrics we care about (cost per lead, cost per customer, conversion rate, and any other ratios you typically track for this goal). • An intuitive dashboard tab: slicers, drop-downs, and visually appealing charts so I can filte...

I have a collection of CSV and native Excel files that need to be merged into one clean, well-structured workbook. The source material already sits in digital form, so no manual transcription from scans is required—just careful extraction and organization of the mixed data (both numbers and text). Here’s what I need from you: • Import each CSV/Excel source, preserving every value exactly as it appears. • Standardize column headers and align the datasets into a single master sheet (or a set of logically separated tabs if that proves clearer). • Run quick checks—basic formulas, filters, or conditional formatting—so obvious discrepancies or mis-typed entries surface immediately. • Deliver the final .xlsx file plus a brief note summarizing an...

I have an existing Excel file that lists product quotations, but its layout is messy and makes quick pricing reviews difficult. I need it turned into a clear, professional template—with tidy column headers, consistent currency and percentage formatting, built-in totals, and space for my logo and client details—all by tomorrow. You will receive the current workbook plus a short style guide. Please keep every price and SKU exactly as they are while improving readability and adding any formulas needed for automatic subtotals, taxes, and grand totals. When finished, send back the polished .xlsx and a ready-to-print PDF version. Acceptance criteria • No data loss or price changes • Formulas work when I add new rows • Headings, fonts, and cell styles match the ...

I’ve built our social-media content calendar in Excel and now need a clear, scroll-friendly timeline inside the same file. The goal is to glance at the sheet and instantly see which posts are scheduled, which channel or format they belong to, and how they line up across the coming days. Here is what I need you to deliver: • Insert an in-sheet timeline (think lightweight Gantt) that automatically pulls from the existing rows. • Display two data points on every bar: the scheduled post date and its content type (e.g., Reel, Story, Blog-link). • Keep it dynamic—when we add or shift a row, the visual updates without extra steps. The workbook is already structured; you can add helper columns, named ranges, or PivotCharts if that speeds things up, but please a...

I have the numbers but need them organized into a clear, reliable annual budgeting model in Excel. The file should let me input or update assumptions quickly while flowing those changes through to projected revenues, expenses, and ending cash balances for the full year. Key things I am looking for: • Solid financial-modeling technique—clean, auditable formulas and no circular references. • Logical structure with separate input, calculation, and output sections so anyone can follow the trail. • Summary dashboards and simple charts that highlight the key variances at a glance. • Straightforward cell naming and consistent formatting. Good written English is important because I will be asking questions and may need brief documentation explaining how each sec...

I need someone long term to help me and be compensated weekly for filling out 100 contact forms a day and completing to perfection one excel document a day or filling out 200 contact forms a day . All forms require before and after screenshots and initial pay is $5 a week with a $1 a week raise per week until $35 a week is achieved in compensation, must meet all goals, and may take either Saturday or Sunday day off weekly

I need a sharp-turnaround assist for my upcoming Business Analytics laboratory exam that is entirely Excel-based. The exam will require me to build the underlying formulas that drive the analysis and then translate the results into a clear line graph, so I want a ready-to-use workbook that I can study and replicate during the test. Here is what I must walk away with: • A single Excel file containing the clean, well-labeled data range. • All core formulas and functions already in place—no array tricks or VBA, just efficient native functions that can be retyped quickly under exam conditions. • A professional-looking line graph that dynamically updates when any value in the data table changes. I will share a sample data set the examiners provided; please use it so I can...

I need an existing PDF invoice template converted into an Excel format for Mac. Requirements: - Must include: - Company logo - Table of items and prices - Payment terms and conditions - Formatting must match the PDF exactly - Automatic calculations are required Ideal skills and experience: - Proficiency in Excel on Mac - Experience with PDF to Excel conversions - Attention to detail to match formatting accurately - Familiarity with setting up automatic calculations in Excel

I have a set of records labelled “Data emtry” that must be transferred into a clean, well-structured Excel spreadsheet. You will receive the raw files and a template workbook with predefined columns; your task is simply to key every value into the correct cell, maintaining the original text and numbers exactly as shown. Accuracy is critical, so please double-check each entry before saving. When you finish, return the completed .xlsx file and keep the source material confidential. Let me know your estimated turnaround time and any clarifying questions you may have so we can get started right away.

I need a clear, practical walk-through of Excel that focuses first on feeling at home with the Tabs—how to locate key commands quickly and move between the different groups inside each tab. Once that foundation is solid, I want to practise routine data entry so I can drop text, numbers, and date values into the right cells without slowing down. The last piece is basic but essential formatting: switching fonts, shading or colouring cells for emphasis, and adding crisp borders so my sheets look tidy and professional. Please guide me step by step, share best-practice shortcuts as we go, and make sure I can repeat every action confidently on my own by the end of the session.

I need a solution to automate the generation of financial reports using data from Excel spreadsheets. Requirements: - Automate report generation process - Utilize Excel spreadsheets as data source Ideal Skills: - Expertise in Excel and automation tools - Experience with financial report generation - Familiarity with integrating Excel with automation software

I need an existing PDF invoice template converted into an Excel format for Mac. Requirements: - Must include: - Company logo - Table of items and prices - Payment terms and conditions - Formatting must match the PDF exactly - Automatic calculations are required Ideal skills and experience: - Proficiency in Excel on Mac - Experience with PDF to Excel conversions - Attention to detail to match formatting accurately - Familiarity with setting up automatic calculations in Excel

I need a solution to automate the generation of financial reports using data from Excel spreadsheets. Requirements: - Automate report generation process - Utilize Excel spreadsheets as data source Ideal Skills: - Expertise in Excel and automation tools - Experience with financial report generation - Familiarity with integrating Excel with automation software

I need a seasoned strategist to sit with me—virtually—and help sharpen my company’s operational efficiency. During our consultation we will map the current workflow, spot bottlenecks, and outline practical, low-friction improvements I can put in place right away. I’m comfortable sharing metrics, process maps, and any back-office data you need to make the session effective. The engagement is deliberately lean: a focused call of about an hour, followed by a brief written summary (bullet points are fine) highlighting quick wins, longer-term recommendations, and any relevant benchmarks or tools you suggest. Think of it as donating your expertise; I will reciprocate with a donation for the time you invest. If you thrive on turning tangled ops into smooth, efficient sys...

Excel VBA was working properly until last month. But currently not working. I am looking for a VBA developer. I think 30mins or 1 hour is enough to resolve.

I need an automated order book organized by product type. The data should include: - Product details - Order status It should be adaptable to a 4-inch printer in a compact list format. Ideal skills and experience: - Experience with automation tools - Ability to design printer-friendly layouts - Familiarity with order management systems Looking for a clean, efficient solution.

I’ve already mapped out an 8-tab workbook and listed every header, so the structure is locked in. What I don’t have is the final layer of polish that will let a virtual assistant jump in without breaking anything. Here’s what I need from you: • Re-format each sheet so fonts, row heights, column widths, colours, and freeze panes are consistent and tidy. • Add validation rules and dropdowns where blanks or typos would cause problems, making it simple for a VA to “drop tabs and columns” or add new rows without touching protected formulas. • Build light conditional formatting (traffic-light alerts, alternating row shading) to guide the eye. • Set up easy-to-read summary rows or a lightweight dashboard on the first tab—nothing t...

I need a specialist who can build robust, reusable Excel 365 formulas for an existing workbook. The work centres on creating truly advanced logic rather than simple cell references. In practical terms, every formula you write must: • include reliable error handling so any #N/A, #DIV/0! or similar issues are gracefully managed • use nested functions where they provide the cleanest, fastest solution • trigger conditional formatting rules that instantly flag results requiring attention I will supply a sample file with annotated targets and a brief “business-rules” document describing what each output should show. Your job is to translate those rules into efficient formulas, test them in Excel 365, and return the updated file together with a short explanation...

I have a collection of Excel (.xlsx) files containing text-only records that need to be copied, verified, and placed into a new master spreadsheet I will provide. The job is straightforward yet demands close attention to spelling, spacing, and column alignment—no numerical fields, formulas, or calculations are involved. You will receive the source workbooks via a shared drive link. Your tasks are to: • Open each sheet, copy the text exactly as written, • Paste it into the matching columns of the template I supply, and • Double-check for any accidental truncation or hidden characters before saving. A quick turnaround with zero introduced errors is my priority. When you return the completed master file, I will spot-check several rows; if everything matches the ori...