dependent this

Hello,
There is a  source sheet that has the relationship between –
Region, country, state, county, city.

How do I do a dependent drop down from this data for the above?

Thank you
dependentThis.xlsx
RayneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Naresh PatelTraderCommented:
in your source there are many duplicated entries.

Thanks
0
Naresh PatelTraderCommented:
you can do it by your self. follow this link Drop Down


Thanks
0
Naresh PatelTraderCommented:
if I understand properly .....do you want this? see attached.
dependentThis.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

RayneAuthor Commented:
Hello itJockey,

thank you for your help so far. I want it to read directly from raw data that has that relationship. Example of raw data is similar to here >>
http://www.contextures.com/xlSampleData01.html


Now how do i set it up - i am staying away from any manual creation as this report will be daily and needs to be refreshed for the 5 drop down metrics.

Also your data has only one city under any given condition - whereas in real world  - its one to many
0
Naresh PatelTraderCommented:
you can achieve this process by just applying Filter.ScreendependentThis.xlsx
0
Naresh PatelTraderCommented:
or I guess I dint understand what you want exactly.
0
Naresh PatelTraderCommented:
let me know what you exactly want?
0
Rob HensonFinance AnalystCommented:
Am I right in thinking that you want the successive dropdown lists to be shortened by the previous selection? For example you choose Americas in the Region and the Country list is filtered for only those Countries in Americas region. Then the State list is filtered for only those states in the Country, and onward for county and city.

Thanks
Rob H
0
Rob HensonFinance AnalystCommented:
Also, by the way in the UK we do not have States; we only have counties. So straight away there is going to be a problem with you lists. Then again it could be a potential saving as you could combine the two lists into one, "State/County".

Thanks
Rob H
0
Rob HensonFinance AnalystCommented:
See below for a couple of examples of the equivalent structure in the UK.

Where I am currently sat:
Region:    Europe
Country:  UK (or would it be England; as opposed to Wales, Scotland or Northern Ireland)
County:   Somerset
District:  South Somerset
Town:     Yeovil

Where I live:
Region:    Europe
Country:  UK
County:   Somerset
District:  Sedgemoor
Town:     Bridgwater

Thanks
Rob H
0
RayneAuthor Commented:
Thank you All, I will follow up later :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.