Hi all,

I need help in VBA for a dynamic print area.

Setting the premise

This relates to an order form. I have 2 sheets: input and output

Input sheet has checkboxes of 10 products and field to enter quantity.

Output sheet has an invoice layout with descriptions of all 10 products (preset), prices (based on selected products) and quantity.


My question...
I want to write a VBA such that if product 1,4 ,9 (or any other sequence) is selected, the output sheet only shows that.

The catch here is that, output sheet should be print ready in a set (professional) layout no matter the number of products selected .

Anyone has an idea of how I can efficiently get the print area to change based on selections on input sheet and without having to write scripts for all possible outcomes?