Experts kindly help

  • Thread starter Thread starter courtesio99
  • Start date Start date
C

courtesio99

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?
 
not too sure about what you're asking for here. HAve you
tried an autofilter?
-----Original Message-----

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?


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by
Click to expand...
step guide to creating financial statements
 
What kind of dropdown list. There are three:

Dropdown box from Forms toolbar
Combobox from Control Toolbox Toolbar
Data => Validation using the list option.

What version of Excel?

--
Regards,
Tom Ogilvy

courtesio99 said:
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?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
I'm using a list via data validation. I'm sorry I know nuts about exce
programming.

Basically, I would appreciate it if someone can help code th
following..

if B1=1, hide rows 3-5, unhide row 2;
if B1=2, hide rows 2,4,5, unhide row 3;
if B1=3, hide rows 2,3,5, unhide row 4;
if B1=4, hide rows 2-4, unhide row 5;
if B1=5, unhide rows 2-5;
else hide rows 2-5;

Thanks
 
Back
Top