Hello All,

I have a workbook that creates a table based on external
data. When the book is opened, it updates the data,
hides two columns and sorts the data based on year and
month. The final result looks like this:

Code Description Month Year
6523 xxxxxxxxxxx Jan 2003
6545 xxxxxxxxxxx Feb 2003
6665 xxxxxxxxxxx Jan 2004

I believe I have about 6000+ records.

I would like to create a list box that changes the fill
range based on specific criteria. If the user knows the
code, that is all they need. But they may only know the
year (worst case) or they may know the month and year.

I am gessing I can use a series of drop lists, one for
the code, one for the year, one for the month and one
for the description.
If month and year are blank then select the entire range.
If year is known and month is blank, shorten the fill
range to the appropriate year.

Any help getting started would be greatly appreciated.

Thanks in advance.

Why apply an autofilter to the data and let the user make the selections
from the autofilter dropdowns?

--
Regards,
Tom Ogilvy

"Rafael" wrote in message
...
Hello All,

I have a workbook that creates a table based on external
data. When the book is opened, it updates the data,
hides two columns and sorts the data based on year and
month. The final result looks like this:

Code Description Month Year
6523 xxxxxxxxxxx Jan 2003
6545 xxxxxxxxxxx Feb 2003
6665 xxxxxxxxxxx Jan 2004

I believe I have about 6000+ records.

I would like to create a list box that changes the fill
range based on specific criteria. If the user knows the
code, that is all they need. But they may only know the
year (worst case) or they may know the month and year.

I am gessing I can use a series of drop lists, one for
the code, one for the year, one for the month and one
for the description.
If month and year are blank then select the entire range.
If year is known and month is blank, shorten the fill
range to the appropriate year.

Any help getting started would be greatly appreciated.

Thanks in advance.