Can anyone help me with the following problem?

I have a dropdown list, e.g. with 4 options.
Each option is represented by a row of data below the cell with the
list, and each cell in each row is to be entered by the user. (That
means I have 4 rows of data.)

How do I unhide a certain row that is selected via the drop down list
whilst hiding the rest of the 3 rows?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements