Fix Crew Management VBA Macro

₹1500-12500 INR

Closed

Posted 16 days ago

₹1500-12500 INR

Paid on delivery

My Excel-based crew-management workbook relies on a fairly large VBA macro to prepare the final roster sheets. Everything runs smoothly until the very last step, then the macro simply stops producing the expected data—no error message, just blank output. Because of this, the completed sheets show missing data and the file can’t be distributed. The job is straightforward: trace the code path that fires during the final output phase, locate whatever is blocking the data transfer, and clean up any related logic so the macro finishes normally every time. You will have full access to the workbook, all modules, and a short sample dataset for repeatable testing. Deliverables • Repaired workbook with the macro running end-to-end, producing complete, correctly populated output sheets • Brief change log outlining what was fixed and why (comments inside the code are fine) • Confirmation that the solution works on standard desktop Excel versions from 2016 onward, with macros enabled Once the roster exports without omissions, the task is done.

Excel VBA

Excel Macros

Excel

Project ID: 40412877

About the project

7 proposals

Remote project

Active 12 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

7 freelancers are bidding on average ₹6,929 INR for this job

@MamukaB

Hello, I can help with the job. Can do within 2-3 days maybe or faster. I have checked attached workbook and what I see workbook contains many sheets and many from them with no data. And have I have very good experience in excel reporting. I'm working in big distribution company and doing reports from big data sets. I will do using excel VBA and will do fast. I will generate 3 workbooks with data of items, vendors and customers. Regarding my experience you can check in my reviews with 100% feedback I have 17+ year experience of Python, Excel, Excel VBA and Have 100% feedback So, you can trust me result will be as you need Best Regard

₹9,000 INR in 3 days

5.0

(79 reviews)

5.9

@nareshk44

With a five-star rating and a commitment to fast, accurate, and on-time delivery, I'm confident in my ability to fix your crew-management VBA macro. My vast experience in Excel, specifically with Excel Macros and VBA, makes me particularly well-suited for this task. Over the years, I've been involved in numerous projects where I've created and debugged complex macros. I'll bring this same level of dedication, meticulousness, and focus to fixing your macro. Moreover, my proficiency with functions, formulas, formatting, timelines, pivot tables, charts and graphs in Excel further equip me for success in this project. I have an intuitive understanding of Excel's inner workings and will not only be able to trace the code path causing the issue but also clean up any related logic contributing to it. Lastly, as an office professional who prides himself on his 24/7 availability and steadfastness in meeting tight deadlines without compromising quality; you can expect a rapid turnaround time while still maintaining the highest standard of work. Your satisfaction is my utmost priority; thus I'm committed to ensuring that the solution I provide works flawlessly on standard desktop Excel versions from 2016 onwards. Let's work together to restore continuity and efficiency to your crew management workbook!

₹5,000 INR in 1 day

5.0

(14 reviews)

4.6

@sstock935

Hello! I can debug your Excel VBA macro by tracing the final output stage and identifying exactly what is stopping the data transfer. I will clean up the logic so the macro runs end‑to‑end and reliably produces fully populated roster sheets. You’ll receive the repaired workbook along with clear in‑code comments explaining what was fixed and why.

₹5,500 INR in 2 days

5.0

(11 reviews)

2.6

@Sahyadri96

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.

₹7,000 INR in 7 days

5.0

(2 reviews)

2.4

@tnowsolutions

Hi! I’ll debug your macro step by step, fix the broken output logic, and make sure your roster sheets generate correctly every time. Best regards

₹11,000 INR in 1 day

5.0

(1 review)

2.1

@TimSou1

Hello, I specialize in debugging and stabilizing complex VBA workflows. Based on your description, the issue likely occurs in the final output phase due to: • A suppressed error (e.g., On Error Resume Next) • An object reference not being properly set • A filter or range resolving to empty before transfer • Calculation or screen update state affecting final output I will: 1. Trace the execution path during the final export stage 2. Identify where the data flow stops 3. Repair the blocking logic 4. Clean up related code for stability 5. Add protective checks to prevent silent failure in the future You will receive: • Fully repaired workbook • Complete working end-to-end export • Clear change log with comments • Confirmation tested on Excel 2016+ I can begin immediately once I review the workbook. Let’s get your roster exporting reliably again. Best regards

₹4,500 INR in 5 days