Case Study 249: Automated Formatting for a Master Winelist

Background: The Creative Bottleneck

A high-end restaurant group approached Bright Triangle because their master wine list had become an operational bottleneck. The sommelier maintained hundreds of active vintages across a multi-tab Excel workbook, where each tab represented a single printed page of the wine list. 

Over time, as the sommelier added new arrivals, removed depleted vintages, and adjusted sections, the formatting on the pages repeatedly broke. Margins drifted, font families became inconsistent, and column widths shifted. Every manual update introduced a high risk of "visual chaos" when printing—forcing the sommelier to spend hours manually fixing individual cells instead of managing inventory. 

The goal was simple: we needed to reset the visual formatting of every tab instantly, while allowing the sommelier to add, remove, or rearrange tabs at will.

The Automation: Designing a Custom VBA Engine

Instead of writing a rigid macro that would break the moment a new wine section was added, we built a flexible, dynamic system:

1. Row Tagging: We added a hidden identifier column to each worksheet tab. The sommelier simply tagged each row based on its content: Heading, Subheading, Note, or Wine.

2. The Control Panel: We created a clean "Formatting Settings" tab at the front of the workbook. Here, the sommelier can easily input the exact row heights and font sizes they want applied to each of the four categories.

3. The Global Macro: We engineered a robust VBA macro that loops through every worksheet tab in the workbook. The script reads the sommelier's desired formatting rules and automatically applies the perfect font sizes and row heights in a fraction of a second.

The Impact: Hours of Guesswork turned into "I Couldn't Be Happier"

By decoupling the formatting rules from the VBA code, the sommelier can easily change the entire design of the wine list (such as increasing font sizes for a seasonal menu) by typing new numbers into the Settings tab and clicking "Run."

The macro completely eliminated the formatting headache, saving hours of manual labor every week and guaranteeing printed consistency. Recently, when we visited the restaurant, the sommelier greeted us with a massive smile, saying: "I couldn't be happier with this macro!"