I'd start with Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

ssGuru wrote:

I think I want to develop a pick list based on a filter. Maybe
not...? Maybe some other method to limit one criteria selection based
on another.
Could use some suggestions on how to approach the problem.

Have a golf data sheet containing lots of fields with defined range
names and hole by hole records.
For example, DataCourseID, DataDatePlayed, DataHolePlayed and others.

I have a report ScoreCard sheet that I wish to populate after a user
picks criteria fields on the ScoreCard sheet choosing a course played,
(SCCourseID) and THEN picks a play date, (SCPlayDate). However, I
want the SCPlayDate picklist to be filtered to just a list of those
unique dates a round was played on the already selected SCCourseID.

I have the SCCourseID picklist working just fine using a validated list
(unique) pointing to a named range on the Courses sheet.

I can create a filter on the data sheet that displayes the info in a
useful sorted and filtered manner;

Filter by unique CourseID/DatePlayed,
sorted by DataCourseID, DataPlayDate and DataHolePlayed.

But, I need a suggestion for code that will accomplish the same thing
and just list those dates that that course was played which I can use
for my Score Card SCPlayDate picklist.

Any general or specific input is appreciated.

DBMaster

--

Dave Peterson