Filtering Names By Date
 

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

Filtering Names By Date
 

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

Filtering Names By Date
 

Thanks Debra,

This looks like it may work (I am still trying to see how it works so
that I can convert it to my project - this is way beyond what I know
at present). One thing that looks like is missing is a way to
increase the ending date.

Is there a way to check the ending date to see if it is within 30 days
of a reference date and if it is, to change the existing end date to
equal the reference date. This would make the ending date into the
last service date.


On Mon, 16 Feb 2004 16:52:14 -0500, Debra Dalgleish
wrote:

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

Filtering Names By Date
 

Thanks Debra,

This almost works. I am having problems with two things. One is that
it looks like there is no way to increase the ending date (which is
actually a "Last Service Date").

Is there a way to check the ending date to see if it is within 30 days
of a reference date and if it is, to change the existing end date to
equal the reference date.

The other item is that I have multiple Filtered Data sheets (one for
each year) which is messing with the formula in the Current column.
I can't seem to get the formula to look at more then one sheet and
that sheet is hardwired into the formula.

How can I use the Data sheet for more then one Filtered Data sheet?

-Minitman

On Mon, 16 Feb 2004 16:52:14 -0500, Debra Dalgleish
wrote:

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