I'd like to define various groups of cells, then conditionally display them elsewhere. Is this possible and if so how?
For example, I might define two groups of cells:
GROUP A:
A1
A2
GROUP B:
B1
B2
Then ask some basic questions using pull-down menus to determine which groups to display elsewhere:
QUESTION 1:Do you use group A? Yes/No
QUESTION 2:Do you use group B? Yes/No
Then based on the answers to these questions the grouped cells are displayed or not displayed in a different part of the worksheet.
So for example, if I selected YES for both group A and B then the following is displayed elsewhere:
A1
A2
B1
B2
Or if I select YES for group A, but select NO for group B then the following is displayed:
A1
A2
Or if I instead select NO for group A, but select YES for group B then the following is displayed:
B1
B2
Anyone that help me out it would be very much appreciated!
Thanks!
John
Bookmarks