Then you would want some code to loop through your data using the current
Criteria of the Filtered list (CourseID). As it finds a match to the ID, it
would AddItem to a dynamic list created on the fly. The item to add would be
an Offset from the CourseID in the Date column. This new list could be
presented on a UserForm. Once a date is chosen, that value can be put in a
cell for formula calculation, or stored in a variable for code evaluation,
or both.

Mike F
"ssGuru" wrote in message
...
On Dec 24, 6:29 am, "Mike Fogleman" wrote:
This could be a good use of a Pivot Table.

Mike F"ssGuru" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks. Remember that I am going to "report" a single score card with
some calculations and other stats based on selecting a course played
iand THEN on which date. I just want to limit the user to seeing ONLY
those dates in a dropdown in the criteria cell for a course was played
AFTER selecting the course in another criteria cell.
I have done lots of pivot tables which do a great job of reformating
data views.

DBMaster