interdependent drop-down cells with user input

tjhsu

Board Regular
Joined
Apr 30, 2003
Messages
103
i just asked a related question earlier, but let me ask it now in full context:

i have 2 columns, for example:
col A:Food Group
col B: Food

When a user goes to enter a value in col A, I want them to see predefined values of: meat, carbs, fruits, veggies
the user can select any of those values, or they can enter their own value

When a user goes to enter a value in col B, I want them to see predefined values of: steak, chicken, bread, cereal, apple, orange, spinach, broccoli
The user can select any of those values, or they can enter their own value

If a user selects meat in col A, col B only shows steak, chicken (or they can enter their own value)
If a user selects steak in col B, then col A only shows meat (or prepopulates with meat).

how do i do this? seems complicated.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

tjhsu

Board Regular
Joined
Apr 30, 2003
Messages
103
OK - so i figured it out, if anyone wants me to try and explain let me know. otherwise i won't bother.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,116
Messages
5,570,273
Members
412,316
Latest member
JabirS
Top