Need Filtered Pick List

[ssGuru]

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]

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

 

[Mike Fogleman]

This could be a good use of a Pivot Table.

Mike F

 

[ssGuru]

This could be a good use of a Pivot Table.














- 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

 

[ssGuru]

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





ssGuruwrote:










--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks Dave. That is a great resource. I just looked briefly but the
first samples I saw use simple named database ranges and I do
understand that type of linking. I will review the site more
extensively soon to see if there is an example that will help with my
design.
In this case however I have certain "filtered" fields in a dynamic
recordset data sheet that I want to use as the limiting criteria. So I
am not sure how to create a formula or code to use for my dropdown
list. I need to have the validation or code just display the dates
that a certain course has been played to allow the user to choose a
date and then allow the "report" to complete other calculations based
on which course and which date. I suppose I can create a separate
dynamic sheet to use for my dropdown list that gets populated each
time a course is played. But that seemed like redundancy that I should
be able to do without.

DBMaster

 

[Mike Fogleman]

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

This could be a good use of a Pivot Table.














- 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