Conditional display of grouped cells?

[jcteel]

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

[Pepe Le Mokko]

Hi A good place to start http://www.contextures.com/xlDataVal02.html