Daily Count Macro Repair
Budget: $30 – $250 AUD
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.
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.