hi all,


I use excel 2007

I have a dropdown menu, created with the values of some cells in my sheet (i.e.: A1, A11, A21, A31).

I'd like, when one of those values is selected, to show only a particular cell range.

examples:
if the cell value A11 is selected, i would like to show the cells range A11, Z20
if the cell value A31 is selected, i would like to show the cells range A31, Z40

the other cells to be hidden...

do you know it is possible? and how?

thanks a lot for your help!