Excel/VBA Label System Build
Budget: $750 – $1,500 AUD
Project summary
Bourke Street Bakery is moving from Foodstorm to Flex Catering as its new catering platform. Under the Foodstorm process, daily labels are exported as an .xlsx and processed by a VBA macro that applies store colours, abbreviations, layout, and print settings before printing onto Winc 49700012A A4 label sheets (24 labels per page, 3 columns x 8 rows, 70 mm x 36 mm each). Flex Catering exports labels as a PDF instead of an Excel file, so we need to recreate and future-proof the existing workflow with PDF as the input. The output requirements (Winc label sheets, colours, abbreviations, layout) remain identical.
What needs to be built
1. PDF extraction. Pull label content out of the Flex Catering PDF while preserving page breaks, label order, label grouping, and line structure.
2. Store colour and abbreviation formatting. Each store gets its configured colour and abbreviation. Palette and abbreviations must be used exactly as supplied (see below).
3. Configurable settings interface. A simple in-workbook settings area so staff/admin can add stores, change colours, abbreviations, font sizes, bold rules, and line/item formatting without touching VBA.
4. Label layout and print alignment. Output must land cleanly inside every physical label position on Winc 49700012A sheets, across multiple pages. Must be tested on real label stock and our actual printer before sign-off.
5. Working-file clean-up. Any temporary sheets/files created during PDF extraction are tidied or hidden so staff only see the parts of the workbook they need.
Required deliverables
• Clean, macro-enabled Excel workbook with a simple staff-facing flow: select PDF, run, print.
• Commented VBA module(s).
• Configurable settings area for stores, colours, abbreviations and formatting rules.
• Print-ready output aligned to Winc 49700012A label sheets, verified end-to-end on a real Flex PDF export, our printer, and real label stock.
• Short written instructions for staff/admin and a short technical summary of how it was built.
Bourke Street Bakery is moving from Foodstorm to Flex Catering as its new catering platform. Under the Foodstorm process, daily labels are exported as an .xlsx and processed by a VBA macro that applies store colours, abbreviations, layout, and print settings before printing onto Winc 49700012A A4 label sheets (24 labels per page, 3 columns x 8 rows, 70 mm x 36 mm each). Flex Catering exports labels as a PDF instead of an Excel file, so we need to recreate and future-proof the existing workflow with PDF as the input. The output requirements (Winc label sheets, colours, abbreviations, layout) remain identical.
What needs to be built
1. PDF extraction. Pull label content out of the Flex Catering PDF while preserving page breaks, label order, label grouping, and line structure.
2. Store colour and abbreviation formatting. Each store gets its configured colour and abbreviation. Palette and abbreviations must be used exactly as supplied (see below).
3. Configurable settings interface. A simple in-workbook settings area so staff/admin can add stores, change colours, abbreviations, font sizes, bold rules, and line/item formatting without touching VBA.
4. Label layout and print alignment. Output must land cleanly inside every physical label position on Winc 49700012A sheets, across multiple pages. Must be tested on real label stock and our actual printer before sign-off.
5. Working-file clean-up. Any temporary sheets/files created during PDF extraction are tidied or hidden so staff only see the parts of the workbook they need.
Required deliverables
• Clean, macro-enabled Excel workbook with a simple staff-facing flow: select PDF, run, print.
• Commented VBA module(s).
• Configurable settings area for stores, colours, abbreviations and formatting rules.
• Print-ready output aligned to Winc 49700012A label sheets, verified end-to-end on a real Flex PDF export, our printer, and real label stock.
• Short written instructions for staff/admin and a short technical summary of how it was built.