I've seen that and still can't figure out how to apply multiple dependencies...
Have you got any ideas on the data validation fomula?
"Pete_UK" wrote:
Have you seen Debra Dalgleish's notes here?:
http://www.contextures.com/xlDataVal02.html
The trick is to use named ranges for the various lists, with names
defined as the dependency chosen.
Hope this helps.
Pete
On Jun 30, 3:04 am, rlmeyers
wrote:
I'm able to to make a dependent drop down list that returns data from a list
based on one dependency, but need a drop down list that progresses and
returns a list based on two dependencies, then three, etcetera.
TYPE DATE SESSION
Attend 7/1/2008 10:30AM Attend
Attend 7/1/2008 7PM Attend
Attend 7/7/2008 7PM Attend
Pick-Up 7/1/2008 10:00AM Pick-Up
Pick-Up 7/1/2008 12:00PM Pick-Up
Pick-Up 7/3/2008 10:00AM Pick-Up
Deliver 7/4/2008 1:00PM Deliver
Deliver 7/4/2008 5:00PM Deliver
Deliver 7/5/2008 1:00PM Deliver
In the first drop down box, I chose from the type list Attend, in the second
drop down box, I chose 7/1/2008. How do I create a third drop down box that
validates data from the first two? and so on?