Category/sub-category

[Luigi802]

So I have many lists like so......
[GROCERIES]___|ENTERTAINMENT|___[FRIVOLOUS]
[Drinks]_______|Family outings|_____[Snacks]
[Lunches]______|Movies|___________[Alcohol]
[General]______|Concerts|__________[Hobbies]
[Breakfast]_____|Events|___________[Apps]
[Dinner]

The 1st item in each is the main category, these categories/sub-categories correspond to a list of transactions in a table. How could I make it so that in column 1 I pick "GROCERIES" from a dropdown DATA list, then in the cell next to it it will only give me a dropdown list with the items under Groceries?

 

[StephenCrump]

If you Google "dependent drop downs" you'll find lots of useful material, e.g.

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

 

[Luigi802]

If you Google "dependent drop downs" you'll find lots of useful material, e.g.

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

OK I did what it asked me to do, but it doesn't seem to be working, how does it know where the depending list is located? There is nothing in the instructions to direct it to the "indirect" dependant list

 

[Luigi802]

If you Google "dependent drop downs" you'll find lots of useful material, e.g.

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

Nevermind, I figured it out, they never tell you to name the columns! Thank you for your help!

 

[StephenCrump]

That's great, I'm glad you were able to make it work.