Hiding rows based on choice in a listbox

[robhargreaves]

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

[Dave Peterson]

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