Drop down list with a sub list

A

AIT

What I would like to do is be able to have a cell in which you could pick
from a drop down box, for example, the area where a resident lived and then
have a sublist appear so you can pick the actual resident's name.

I can set it up using the indirect function as separate columns, but I want
to do this in just one column (like menu options). Is this possible? I have
looked on contextures.com, but it does not provide enough clarification for
me to understand if there is a process out there.

Please help!
 
L

Luke M

You can't do that in just a single cell. You could do it with 2 cells (using
dynamic validation - found on contextures). To get the actual appearance of
what you describe, you could try using forms and VBA (beyond my knowledge,
I'm afraid). But, if you are willing to go that route, I'd assume you'd be
willing to just use a second cell.
 

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
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Filtered drop down list 2
Print Macro w/drop down list 1
drop down list 1

Top