Greetings fellow Excellers,

How do I filter the List property under Validation under the Data menu
choice.

I have a sheet with a Date column and a name column. I have applied
the Data Validation List to this column.

I have a different sheet which contains a list of names and other
information on my customers, including a start and end date. This
information changes over time. What I want to do is have the Data
Validation filter the names shown in it's drop down list box by the
value in the Date cell (if the date is within the start and end date,
then show that name).

Is this even possible?

TIA

-Minitman