
Completed
Posted
Paid on delivery
Project summary We have an existing Excel workbook containing VBA macros that previously worked correctly. After adding extra columns to one of the daily worksheets, several macros and the workbook's print functions have started behaving incorrectly. We need an experienced VBA developer to review the affected code, repair it, and make it more resilient so future column additions don't break the workbook again. What needs to be done 1. Review all VBA tied to the seven packerssheet worksheets and to DAILY COUNT PRINT OFF. 2. Identify and document hardcoded column references, fixed ranges, page-setup/print-area issues, and any code path affected by the inserted columns. 3. Update the code so packerssheetmonday works with its new columns, the other six days continue to work, and printing/formatting/scaling/alignment are all repaired. 4. Make the code more dynamic and future-proof — replace hardcoded column numbers with dynamic ranges or named ranges so future column additions don't break things again. 5. Fully test macro execution, print output, formatting consistency, and data alignment across all seven daily sheets end-to-end.
Project ID: 40476199
48 proposals
Remote project
Active 23 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
48 freelancers are bidding on average $126 AUD for this job

Hello Sir, I can review the VBA across all seven packerssheet worksheets and DAILY COUNT PRINT OFF, identify the hardcoded references causing the issues, and update the macros and print functions to work correctly with the new columns. I will make the code dynamic and future-proof, then fully test execution, formatting, alignment, and print output across all daily sheets.
$150 AUD in 1 day
8.8
8.8

Hi there, I understand you need an experienced VBA developer to repair and future-proof your existing Excel workbook after additional columns caused several macros, formatting routines, and print functions to fail. I am confident I can stabilize the workbook, restore all affected functionality, and restructure the VBA logic so future column additions no longer break the system. My approach will be to audit all VBA connected to the seven packerssheet worksheets and the DAILY COUNT PRINT OFF workflow, identify every hardcoded column reference, fixed range dependency, and page setup issue impacted by the inserted columns, then refactor the logic using dynamic range detection, named ranges, and adaptable worksheet references. I will repair printing behavior, formatting consistency, scaling, alignment, and macro execution across all seven daily sheets while ensuring the updated structure remains maintainable and resilient for future modifications. The deliverable will include the repaired and optimized Excel workbook, updated VBA code with dynamic handling for future column changes, corrected print and formatting behavior, and a short documentation summary outlining the issues found, fixes applied, and recommendations for maintaining workbook stability going forward. Were the new columns inserted only into packerssheetmonday, or were structural changes made elsewhere in the workbook as well? I’m ready to start immediately. Warm Regards, Aneesa.
$100 AUD in 1 day
7.0
7.0

Hi, I understand the workbook was originally functioning correctly, but the additional columns introduced into packerssheetmonday caused existing VBA logic and print configurations to fail due to hardcoded references and fixed layout assumptions. The priority now is not only repairing the affected macros and print behavior, but also making the workbook resilient against future structural changes. I have experience debugging and refactoring complex Excel/VBA workbooks involving dynamic ranges, print automation, worksheet event logic, and multi-sheet reporting systems. I can: • review all VBA tied to the seven packerssheet worksheets and DAILY COUNT PRINT OFF • identify and document hardcoded ranges/column dependencies • repair printing, scaling, formatting, and alignment issues • refactor the macros to use dynamic range detection/named references • ensure all seven daily sheets remain synchronized and functional • fully test end-to-end execution and print consistency My focus will be delivering a stable, maintainable workbook that continues working even when columns are added later.
$40 AUD in 1 day
6.8
6.8

Hello, I am an experienced VBA developer who will audit and repair your workbook by replacing all hardcoded column references and fixed ranges in the seven packerssheet macros and DAILY COUNT PRINT OFF routines with dynamic ranges and named ranges, then fix all page-setup, print-area, scaling, and alignment issues caused by the new columns ensuring packerssheetmonday works correctly, the other six days remain functional, and future column additions won't break the workbook again. I will document all changes, test every macro and print output across all seven daily sheets end-to-end, and deliver a fully repaired, future-proof .xlsm file. Regards, Zafar
$100 AUD in 1 day
6.2
6.2

I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. I can review your existing code and excel file and make it flexible for adding or removing rows and columns, along with fixing the other issues like print out issue, and validating everything is work as intentional. Please have a look at my project portfolio in my profile to have a better understanding of my experience. Lets chat and discuss the details further. Looking forward to working with you!
$100 AUD in 2 days
6.1
6.1

Hello, I have read your job description and I am interested in your job post. I am ready to start now. Please send me a message to discuss more about your project. Thanks and Regards, Everest Technology
$88 AUD in 2 days
5.6
5.6

Hi, I can help diagnose and repair the VBA issues in your workbook and make the code resilient to future structural changes. My approach will be to first review all VBA modules, worksheet events, and print-related procedures connected to the seven PackersSheet tabs and the DAILY COUNT PRINT OFF sheet. I’ll identify every hardcoded column reference, fixed range, page setup dependency, and any logic affected by the newly inserted columns. Once the root causes are documented, I’ll update the macros so the Monday sheet functions correctly with the new columns while ensuring the remaining six daily sheets continue to operate as expected. I’ll also repair any print-area, scaling, formatting, and alignment issues currently affecting output. To prevent this problem from recurring, I’ll refactor the code to use dynamic column detection, named ranges, and flexible range handling rather than hardcoded column numbers wherever possible. Finally, I’ll perform end-to-end testing across all seven daily sheets to verify macro execution, data alignment, formatting consistency, and print output. Please share the workbook, and I’ll review the VBA structure and provide a clear summary of the issues found along with the fixes implemented. Please open the chat for further discussion. Thanks & regards, Naresh
$200 AUD in 1 day
5.4
5.4

Well defined requiremnts, clearly understood and ready to do the required fixes to the VBA macro(s).
$150 AUD in 2 days
5.3
5.3

With my extensive background in data processing, automation and analysis, I believe I am the perfect candidate for this project. As a proficient Python programmer, I am well-versed in using Pandas and other data manipulation libraries to handle large datasets - a skill that is directly applicable to your project's requirement of dealing with new columns without disrupting the established VBA macros. Additionally, my strong statistical aptitude ensures that any required amendments will not only be implemented but also tested thoroughly, guaranteeing the smooth functioning of all affected code paths. Furthermore, aside from being an Excel-centric individual, I also have substantial experience with VBA macros and data analysis in Excel. Over the years, I have routinely implemented advanced formulae and designed custom VBA macros for large-scale datasets just like yours. My expertise extends to creating dynamic ranges and named ranges to ensure the future-proofing you seek for your workbook. Therefore, as an added advantage to my programming abilities, you can be assured of an efficient codebase that will not be perturbed by any insertion or removal of columns in future.
$30 AUD in 1 day
4.3
4.3

Hi, I am a certified and experienced Excel expert. Your Excel daily count macro repair request is perfectly matching with the specialize service offering in my profile. Please feel free to ask any questions if you have. Thanks!
$100 AUD in 2 days
4.4
4.4

I understand you're looking for a VBA developer to fix your Excel workbook's broken macros and print functions after adding columns. My experience includes optimizing and refactoring VBA for similar Excel-based reporting tools, ensuring robust performance even with structural changes. I can quickly diagnose and resolve the issues stemming from hardcoded references, much like I did for a client whose automated report generation failed after a similar spreadsheet modification. My approach will involve a thorough code audit of all VBA modules associated with the seven "packerssheet" worksheets and the "DAILY COUNT PRINT OFF" functionality. I'll specifically target and eliminate hardcoded column references and fixed ranges, replacing them with dynamic methods such as `Cells(row, column)` with calculated column indices or `UsedRange` properties where appropriate. I will also investigate and adjust the print settings to accommodate potential layout shifts. To ensure long-term stability, I will implement error handling and conditional logic to gracefully manage future column additions. Would you prefer the repairs to be documented with inline comments explaining the changes, or a separate summary document detailing the modifications? I'm available for a brief call to discuss the specifics and provide a more precise timeline.
$186 AUD in 21 days
4.0
4.0

I am an experienced VBA developer and can review, repair, and future proof your workbook efficiently. I will go through all VBA tied to the seven packerssheet worksheets and the DAILY COUNT PRINT OFF functionality, identify every hardcoded column reference and fixed range that is now causing problems, document what I find, and update the code so it works correctly across all seven daily sheets including the new columns added to packerssheetmonday. Beyond the immediate repairs I will replace hardcoded references with dynamic range detection or named ranges so future column additions do not break the workbook again. Print area setup, scaling, formatting, and alignment will all be tested and confirmed across every sheet before handoff. You will receive the repaired workbook along with brief notes explaining what was changed and why. My rate is negotiable and if you can share the workbook I can give you a more accurate estimate straight away.
$140 AUD in 7 days
4.2
4.2

Hi sir, I am interested in working with you on this project. My name is Osama and I am an Excel expert with strong VBA and analytical skills. I confirm that I read and understand the requirements in the attached document. I am happy to provide a documentation/video/live session walk through. I would prefer agreeing on a fixed cost for the project, however, I would like to review the current file features and code before sending a fixed quote. If you prefer workin hourly, or want an estimate for record, my hourly rate for VBA work is 25$/h. Looking forward to hearing from you soon. Let's connect and discuss.
$40 AUD in 1 day
4.1
4.1

VBA macros breaking after an Excel update or a workbook move is usually a reference error or a deprecated method call. I can open the file, trace the issue in the macro editor, and have your daily count tracker running again within a few hours. Can start today. The bid reflects what's in the post. The real number depends on how many macros are affected, which we'll know the moment I look at the file. Want to send it over?
$150 AUD in 3 days
3.5
3.5

I have over 30 years of VBA experience. You can check my VBA tutorials at YouTube channel: 545sytes . I generally work with INDIRECT function, so fixed references are avoided and cell references are created dynamically. Resources: Windows 11, Office 2016, 2021 and 365
$140 AUD in 7 days
3.5
3.5

Hi, Fixing broken VBA after structural changes to a workbook — replacing hardcoded column references with dynamic ranges, repairing print areas and page setup, and making the code resilient to future edits — is exactly the kind of work I do well. I'll review all macros tied to the seven packerssheet worksheets and DAILY COUNT PRINT OFF, document what's broken and why, then update the code so all seven daily sheets work correctly and consistently. The goal is a workbook that won't break again when columns are added. Could you share the workbook file so I can assess the scope before confirming the timeline? Best, Ann-Christin
$150 AUD in 3 days
2.3
2.3

Hello, I understand the Daily Count Macro Repair project hinges on restoring reliable macro behavior after the recent column insertions across the seven packerssheet worksheets and the DAILY COUNT PRINT OFF. I will systematically review all VBA tied to these sheets, identify hardcoded references, fixed ranges, and print-area/page-setup issues, and then rework the code to be resilient to future column changes. My approach: dynamic ranges, named ranges or table references instead of fixed column numbers; unify printing settings; ensure packerssheetmonday adapts to its new structure while preserving the other six days; thorough end-to-end testing of macro execution, print output, and alignment. Deliverables include a documented update of references, a robust, future-proofed VBA module, and a complete test plan ensuring consistent formatting and print results across all seven daily sheets. I will provide a concise change log and be available for any iterative refinements. I am ready to start as soon as you confirm the project scope and any additional attachments beyond the Daily_Count_Macro_Repair_Brief.docx. Best regards,
$30 AUD in 3 days
0.0
0.0

Hi, I can help repair and future-proof the VBA macros affected by the new columns in your workbook. I’ll review the code tied to the seven packersheet worksheets and DAILY COUNT PRINT OFF, identify hardcoded column references, fixed ranges, print areas, page setup issues, and any logic broken by the inserted columns. Then I’ll update the code to use dynamic ranges or named ranges where appropriate, so future column changes are less likely to break the workbook again. I can also test macro execution, formatting, print areas, scaling, and alignment across all seven daily sheets before sending back the fixed workbook with a short summary of what was changed. P.S. I’ll avoid quick patching only Monday’s sheet and instead fix the underlying range/column assumptions so the workbook stays more stable going forward.
$100 AUD in 2 days
2.2
2.2

Hello, I can help you efficiently repair your VBA macros and make them future-proof. Approach: • Review all VBA tied to the seven packerssheet worksheets and DAILY COUNT PRINT OFF • Identify and fix hardcoded column references, fixed ranges, and page-setup issues • Update packerssheetmonday to work with new columns while keeping other days intact • Replace hardcoded column numbers with dynamic or named ranges so future column additions won't break anything • Fully test macro execution, print output, formatting, and data alignment across all seven daily sheets Technologies: • VBA, Excel Macros, Microsoft Office Extras: • Brief documentation of all changes made • Verification that everything functions correctly after repair Timeline: • 1–2 days Goal: To deliver a fully functional, resilient workbook to you—hassle-free. Ready to get started. Agustin
$140 AUD in 7 days
0.0
0.0

Hello I reviewed your project about fixing and future-proofing the VBA macros in your Excel workbook after adding new columns. I understand the challenge of hardcoded references breaking code when the sheet structure changes, and I’ve dealt with this many times. Here’s my plan: I’ll thoroughly audit all VBA tied to your seven packers sheets and DAILY COUNT PRINT OFF, identify every fixed column reference and print area issue, then refactor the code to use dynamic ranges or named ranges. This will ensure the Monday sheet adapts to its new columns while the other days remain stable. I’ll also test printing, formatting, scaling, and alignment across all sheets for consistency. With over 10 years of VBA experience automating complex Excel workflows and improving maintainability, I’m confident I can deliver a robust solution quickly. Could you share a sample workbook so I can assess the current setup before we start? Best regards, AbdulHamid
$30 AUD in 2 days
0.0
0.0

Sydney, Australia
Payment method verified
Member since Mar 1, 2026
€8-30 EUR
$250-750 USD
€30-250 EUR
$15-25 USD / hour
$30-60 NZD / hour
₹750-1250 INR / hour
£10-20 GBP
₹400-750 INR / hour
$10-30 USD
$10-30 USD
$10-30 USD
$250-750 USD
₹12500-37500 INR
$30-250 USD
₹600-1500 INR
$250-750 USD
$30-250 USD
£250-750 GBP
₹600-1500 INR
₹600-1500 INR