To display a unique data validation list for each row, you could use a
formula to extract the names, and event code to copy the date from the
active row.

There's an example he

http://www.contextures.com/excelfiles.html#DataVal

under the heading 'Dynamic Validation List'

Minitman wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html