Hi,
I would like to get some advice before I give up and apply something less automatic to my problem.
I am creating a workbook that will provide an out put to the user based on the checkboxes selected. I would like the output format to change based on the selection.
In the attached is an example. The "Selection" worksheet contains the possible check box options
The "Selection Detail" contains the information that can be displayed for each checkbox.
The "Output" is the worksheet I would like to present to the user showing the detail of their selections.
In the attached scenario only EU 27 Only and LATAM have been selected so the output shows this. However, if North America was also selected, I would like th output to add North America in between the current EU27 and LATAM view.
Is this possible or should i result to lookups and conditional formating?
As always, the excel forums help is greatly appreciated.
Bookmarks