Need Filtered Pick List
 

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

Need Filtered Pick List
 

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

Need Filtered Pick List
 

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

Need Filtered Pick List
 

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

Need Filtered Pick List
 

On Dec 24, 5:33*am, Dave Peterson wrote:
I'd start with Debra Dalgleish's site:http://contextures.com/xlDataVal02.html





ssGuruwrote:

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- 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

Need Filtered Pick List
 

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