Help with the if/then function and hide/ unhide

[Brandyw]

So, I have four different spreadsheets that I compiled into one excel sheet. What I need to do, is create a dropdown menu of what do you want to do: Option A, Option B, Option c, or Option D. So far I had created the drop down menu.

However, I can't figure out how to make it so when a user selects lets say option C, all the spreadsheets informatgions for the other options stay hidden, while the 4 columns and 20 rows of info for that option C pops up.

I've tried to play with the if/ then function and other hide or grouping functions and none of them are doing what I'd really like to do with this. Please help!

 

[VoG]

Have you looked at AutoFilter http://www.contextures.com/xlautofilter01_2003.html

 

[Brandyw]

I did look that over, but thats not quite what I'm looking for.

I need it to be simply a spreadsheet with that one question and everything hidden, and depending on customer selection, thats what spreadsheet pops up