Multiple lists

G

Gambit-6

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 I’ve 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
Possible to Combine reports to's to a single box? 0
Using Drop Down list to an If Statement to another Drop Down list 3
Help with drop down selection and populating related data... 9
Filtered drop down list 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1

Top