Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding rows based on choice in a listbox
Hi I have a list box provided with values found in a range A14:A502 There are calculations at the top of the page and i would like to filter the data based on two list boxes - start date and end date. Start date and end date are both supplied with values for the list from A14:A502. So I would like to if the user picks start date of 01/02/05 hide any rows prior to that date If the user picks a date of nothing it will not hide any rows at the more recent end of the scale or vice vera. In clearing the cell holding the list the records return. If they picked 22-Jul-05 the list would not show rows with any more recent dates than that. I cant delete the data but I dont mind putting it somewhere temporarily. I have the list boxes in place but how do you make their change reflect the hiding of the rows? Thanks if you can help. Rob -- robhargreaves ------------------------------------------------------------------------ robhargreaves's Profile: http://www.excelforum.com/member.php...o&userid=25519 View this thread: http://www.excelforum.com/showthread...hreadid=389688 |
#2
|
|||
|
|||
It sounds like you're trying to recreate data|filter|autofilter.
You can use custom (under that dropdown arrow) and tell excel to show data between two dates. robhargreaves wrote: Hi I have a list box provided with values found in a range A14:A502 There are calculations at the top of the page and i would like to filter the data based on two list boxes - start date and end date. Start date and end date are both supplied with values for the list from A14:A502. So I would like to if the user picks start date of 01/02/05 hide any rows prior to that date If the user picks a date of nothing it will not hide any rows at the more recent end of the scale or vice vera. In clearing the cell holding the list the records return. If they picked 22-Jul-05 the list would not show rows with any more recent dates than that. I cant delete the data but I dont mind putting it somewhere temporarily. I have the list boxes in place but how do you make their change reflect the hiding of the rows? Thanks if you can help. Rob -- robhargreaves ------------------------------------------------------------------------ robhargreaves's Profile: http://www.excelforum.com/member.php...o&userid=25519 View this thread: http://www.excelforum.com/showthread...hreadid=389688 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Hiding Rows Based on Percentile | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Hiding rows based on date | Excel Worksheet Functions |