Excel VBA Jobs

My financial-report templates rely on several nested IF, AND and OR formulas that should pull figures from other sheets in the same workbook, yet the numbers stay frozen when the source data changes. I need someone who can open the file, trace the internal links, correct any reference errors or circular logic, and make sure every total and subtotal refreshes instantly after data entry. You will be working only inside this one workbook—no external files or databases—so the focus is on sheet-to-sheet connections, range naming, and any settings (calculation mode, table expansion, etc.) that might block recalculation. Once the logic is solid I would like the templates cleaned up: remove any redundant helper columns, lock the finished formulas, and confirm the output matches a shor...

I need a freelancer to verify and update a spreadsheet of company contacts. The task involves checking if companies still exist and if the contacts are still valid. If a contact is no longer valid, please replace them with someone of a similar title. Requirements: - Utilize online search and validation for verification. - Preferred sources: Company website, LinkedIn, Industry directories. Ideal Skills & Experience: - Proficiency in using LinkedIn and industry directories. - Attention to detail. - Experience with online research and data validation. - Familiarity with spreadsheets for updating information.

I have a picture of an existing network layout that I need redrawn cleanly in Microsoft Visio. The final diagram must clearly show the servers and computers, routers and switches, plus the firewalls and other security devices exactly as they appear in the image, keeping their relative positions and connections intact. Please replicate the iconography with standard Visio stencils (or equivalent custom shapes where needed) so the diagram is editable later. I’ll supply the source photo in high resolution; you return a fully editable .vsdx file, logically grouped and neatly labelled. Deliverables: • Editable Visio (.vsdx) file reflecting the picture That’s all I need—accuracy, clarity, and tidy layer organisation so future tweaks are simple.

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I want to replace a string of repetitive, error-prone steps in my workbook with a clean, well-documented VBA macro. The end result should run at the click of a button or a keyboard shortcut, carry out every step automatically, and leave the sheet ready for review without any manual fixes. Deliverables • The Excel file containing your fully commented VBA code • A short note (or Loom/video) explaining how to install, edit, and trigger the macro in Excel 2016, 2019, and Office 365 • Clear documentation of any external references or libraries you use Acceptance criteria • Macro executes from a single action with no run-time errors • Code is logically structured and easy for me to tweak later • Operation remains consistent across all three Excel v...

I need assistance to get my Excel macro working for report generation tasks related to rates. Requirements: - The macro is already created but currently non-functional. - It should automate the generation of reports based on specified criteria. Ideal Skills and Experience: - Proficiency in Excel and VBA (Visual Basic for Applications). - Experience in creating and troubleshooting Excel macros. - Strong understanding of report generation processes in Excel. Please provide a brief overview of your experience with similar projects.

Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.

I'm seeking an experienced VBA developer to create an Excel macro. The primary goal is to automate reporting tasks to save time and reduce manual effort. Key Requirements: - Develop a VBA macro to automate repetitive reporting tasks. - Ensure the macro is user-friendly and well-documented. - Provide support for any troubleshooting post-deployment. Ideal Skills and Experience: - Proficiency in Excel and VBA. - Strong experience in automating tasks, particularly in reporting. - Problem-solving skills and attention to detail. Please provide examples of past work and relevant experience in your application.

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I’m looking for a mentor-consultant who can help me blend two worlds that normally sit apart: solid financial-accounting practice and persuasive mobile-phone sales. My immediate priority is to deepen my grasp of financial accounting—closing entries, reporting logic, ratio interpretation, and the everyday Excel workflow that underpins them—while, in parallel, mastering product-level knowledge of smartphones so I can explain specs and value propositions with genuine authority. Here’s how I picture the engagement: • Build a concise learning roadmap that alternates between financial-accounting concepts and mobile-device product briefings, so the two skill sets reinforce one another instead of competing for time. • Provide live or recorded walkthroughs o...

I have a batch of customer information locked away in several PDF files that needs to be brought into a clean, well-structured Excel workbook. Your job is to extract every required field, place it in the correct columns, format it consistently, and double-check the results so that the sheet is error-free. Source material • Native and scanned PDFs containing names, addresses, contact details, account numbers and a few date fields. • Some documents include multiple records per page, others just one. What I need from you 1. Convert the PDFs to Excel, making sure each customer record sits on its own row. 2. Standardise text (capitalisation, date formats, phone number structure, no trailing spaces). 3. Run quick validations—spot duplicate records, flag missing mandat...

# Advanced Excel Study Planner & Performance Dashboard (RRB PO, SBI PO, SSC) ## Project Overview I need a professional, full-featured study-planning workspace built entirely in Microsoft Excel (Excel 2016+ compatible) for competitive exam preparation, specifically RRB PO, SBI PO, IBPS PO, SSC CGL, SSC CHSL, and similar aptitude-based examinations. The workbook should function as a complete planning, tracking, and performance-management system, allowing me to create fully customizable study schedules (daily, weekly, monthly, or hour-based), monitor progress automatically, analyze mock-test performance, and identify weak areas through interactive dashboards. The final deliverable should be clean, professional, optimized for performance, and suitable for long-term use without requirin...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I have an Excel file that’s meant to build a self-populating work roster, but the dashboard sheet is no longer talking to the roster grid. The Generate Roster button sits there looking pretty, yet nothing happens. What it should be doing is cycling through my predefined staffing rules—roles, shift lengths, maximum hours—and auto-filling the grid instantly. The core of the job is to trace where the VBA (or assigned macros) break down, restore the link between the dashboard inputs and the roster sheet, and make sure the Generate Roster button actually produces a complete schedule every time. Once fixed, I need clean, well-commented code so I can tweak the rules later without breaking everything again. Deliverables: • Working Generate Roster button that auto-fil...

I have a collection of text-based records that must be transferred accurately into Excel and then processed with a short Python routine. Everything will be keyed in manually—no web scraping or database pulls—so precision and an eye for detail are critical. The spreadsheet should come back tidy, well-formatted, and ready for basic filtering or pivoting. Once the sheet is complete, I’d like a lightweight Python script (pandas / openpyxl are fine) that reads the file, performs simple cleaning steps I’ll specify, and exports an updated version. If any numeric fields appear along the way, just include them exactly as the client supplies; no additional analysis is required. Deliverables • Finished Excel workbook with all text data correctly entered • P...

I have a collection of text-based records that must be transferred accurately into Excel and then processed with a short Python routine. Everything will be keyed in manually—no web scraping or database pulls—so precision and an eye for detail are critical. The spreadsheet should come back tidy, well-formatted, and ready for basic filtering or pivoting. Once the sheet is complete, I’d like a lightweight Python script (pandas / openpyxl are fine) that reads the file, performs simple cleaning steps I’ll specify, and exports an updated version. If any numeric fields appear along the way, just include them exactly as the client supplies; no additional analysis is required. Deliverables • Finished Excel workbook with all text data correctly entered • P...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas a...

I have a backlog of both accounts receivable and accounts payable that must be keyed into Tally and mirrored in Excel for reporting purposes. Source documents are already scanned and organized, so most of the work is straightforward data entry and careful copy-paste, followed by a quick self-check to be sure every invoice, payment, credit note, and adjustment is represented in both systems. You can work with the column layout I already use, or propose a cleaner template if you feel it will speed things up—I’m flexible on that point as long as the final Excel sheet matches the Tally ledgers line for line. Because accuracy matters more than speed here, I will verify the first small batch before you proceed with the rest. Once we’re happy with the approach, you can take th...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I run compliance for a busy haulage company and need a single Excel workbook that keeps me ahead of every statutory obligation. The sheet must revolve around our WEEKLY TARGETS: when each licence, CPC refresher, driver medical or maintenance inspection is due, what percentage of the fleet is still outstanding, and whether we are on-track for the week. Here’s what I picture: the moment any target slips inside its warning window the cell turns amber; miss the deadline and it flips to red. At the same time an automatic email should leave Outlook so the relevant manager is warned without me lifting a finger. Formulas must update themselves from simple data entry (dates, counts, kilometres, etc.), calculate the remaining days and the KPI percentages, and feed a quick-view dashboard so I ...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

hello, I need to create a solution in Excel that I would use to print school certificates... on the first Excel sheet I would enter general information about the school, teacher's name, number of students and class and by pressing the "generate" button it would open a new Excel sheet in which I would create a table overview of all subjects and calculate average grades... the data entered on the second sheet should be used on the third sheet to print the certificate. I would like to submit an outdated proposal of how it would look and how we used to use the certificate form on which the data should be printed More details: What kind of overview do you need on the second sheet? Grades and attendance What format do you prefer for the certificate on the third sheet? Custom te...

ROYAL HOSPITAL FOR WOMEN PGD / PGT PATIENT TRACKING WORKBOOK FINAL DESIGN (VERSION 1.0) ________________________________________ SHEET 1 – LANDING PAGE (DAILY WORKFLOW) Purpose The Landing Page is the nursing team's operational workspace. No patient data is entered here. All information is automatically populated from the Master Register. ________________________________________ Landing Page Layout WL# URN Surname First Name DOB Current Age Age at Referral Referral Date Days Waiting Genetic Diagnosis Status Next Action Appointment Date Due Date Example WL# URN Surname First Name DOB Current Age Age at Referral Referral Date Days Waiting Genetic Diagnosis Status Next Action Appointment Date Due Date 1 12345 Smith Jane 15-04-1992 34 33 01-08-2025 335 BRCA1 New Referral Offer Appoi...