Hi,

I am trying to create the following:

I have a cell which contains a list which I created using Data/Validation. Now I want that certain rows in another sheet in the same file are shown or hidden depending on which item I select from the list. How can I do this?

I am new at programming in Excel, so a simple explanation would be great! Thanks!

Philip