Excel/VBA Label System Fix-Up Engagement
Budget: $250 – $750 AUD
Project summary
We run a catering business that uses Foodstorm to export daily order labels to Excel. A VBA macro in our workbook reformats those labels (colours, abbreviations, layout) and prints them onto pre-cut Winc 49700012A A4 label sheets (24 labels per page, 70 mm x 36 mm each, 3 columns x 8 rows). The macro has been progressively patched, and most of the issues are resolved — but row alignment is still drifting on print and we want a professional to take it the last mile, lock it in, and stand behind the result.
Current state
• Colour matching is correct and stable. Each store gets the right colour stripe, no ghost colours, no substring false-positives.
• Column widths are correct. Columns A/B/C land in the right horizontal position after a print-driver workaround was added (Application.PrintCommunication = False).
• Row alignment is still wrong. Labels print roughly 2 mm out of position and the error compounds down the page — by the 4th–5th row each label has drifted into the next physical label slot.
• Print scale is currently forced to 96% to compensate for Excel/printer behaviour. This was empirically calibrated and may need to be revisited.
What we need done
1. Diagnose and fix the compounding row drift so 8 labels per page land cleanly on the Winc pre-cut sheet, every page, every print.
2. Verify the fix end-to-end on a real Foodstorm export printed to our actual printer onto real Winc 49700012A sheets.
3. Hand back a clean .xlsm + commented VBA module + short written summary of what was changed and why.
We run a catering business that uses Foodstorm to export daily order labels to Excel. A VBA macro in our workbook reformats those labels (colours, abbreviations, layout) and prints them onto pre-cut Winc 49700012A A4 label sheets (24 labels per page, 70 mm x 36 mm each, 3 columns x 8 rows). The macro has been progressively patched, and most of the issues are resolved — but row alignment is still drifting on print and we want a professional to take it the last mile, lock it in, and stand behind the result.
Current state
• Colour matching is correct and stable. Each store gets the right colour stripe, no ghost colours, no substring false-positives.
• Column widths are correct. Columns A/B/C land in the right horizontal position after a print-driver workaround was added (Application.PrintCommunication = False).
• Row alignment is still wrong. Labels print roughly 2 mm out of position and the error compounds down the page — by the 4th–5th row each label has drifted into the next physical label slot.
• Print scale is currently forced to 96% to compensate for Excel/printer behaviour. This was empirically calibrated and may need to be revisited.
What we need done
1. Diagnose and fix the compounding row drift so 8 labels per page land cleanly on the Winc pre-cut sheet, every page, every print.
2. Verify the fix end-to-end on a real Foodstorm export printed to our actual printer onto real Winc 49700012A sheets.
3. Hand back a clean .xlsm + commented VBA module + short written summary of what was changed and why.
Related categories:
Visual Basic
Excel
Software Architecture
Visual Basic for Apps
Excel VBA
Excel Macros
Data Analysis
Print Design