Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Experts kindly help
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Experts kindly help
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? ------------------------------------------------ ~~ 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Experts kindly help
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" wrote in 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? ------------------------------------------------ ~~ 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Experts kindly help
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 -- ~~ Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to appy the formular with different cell parameters~kindly hel | Excel Worksheet Functions | |||
vlookup doesn't work consistently (I think), kindly help | Excel Worksheet Functions | |||
kindly help me w/mail merge in xcel;40recipients1 text | Excel Discussion (Misc queries) | |||
Help - Need experts help! | Excel Discussion (Misc queries) | |||
another for the experts | Excel Discussion (Misc queries) |