Filtering Names By Date

  • Thread starter Thread starter Minitman
  • Start date Start date
M

Minitman

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
 
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.
 
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
 
Back
Top