I am trying to make a drop down list where user can choose a category and sub-category and simply display it.
Could someone point me in the right direction or show me an example please?
Thanks
Greg
I am trying to make a drop down list where user can choose a category and sub-category and simply display it.
Could someone point me in the right direction or show me an example please?
Thanks
Greg
Hi GregH,
I believe you're looking for what's known as a 'dependent drop-down list'. This can be done very well using Data Validation. The following website goes through the process step-by-step:
http://www.contextures.com/xlDataVal13.html
I hope that helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks