Thread: Multiple lists
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Multiple lists

Hi,
Take a look to Debra web

http://www.contextures.com/xldataval02.html


"Gambit-6" wrote:

Hi hope you can help

I am trying to work out a way of creating a second drop down list dependent
on the results of an initial drop down
I am trying to set up basically a front sheet that will bring up the data
based in other sheets in the work book, trying to avoid having to use Access
if I can!

I have tried to set up dependent lists based on the info on the Contextures
site but as the data is in the other sheets Ive got lost!

Basically if I select (from the drop down) Org 1, I want a second list with
all the available options (i.e Surnames, then I can go from there)

A B C
1 Smith Org 1 Director
2 Jones Org 2 Director
3 Bloggs Org 1 Assistant

Thanks in advance