Populating a data validation list based on criteria

C

Ciarán

Hi,

Is there any way of populating the data validation list of a cell
based on the selection in another list driven data validated cell?

For example:

Using the table below,

Col_A Col_B
1 Football
1 Running
2 Baseball
2 Swimming


I want Cell A2 to have the list options 1 and 2.
Then if the user selects 1 in Cell A2, I want the user to have the
options Football and Running in Cell B2.

Regards,
Ciarán
 
R

Richard Edwards

I asked that question yesterday and was given this:

http://contextures.com/xlDataVal02.html

worked well for me.

good luck

rich

Hi,

Is there any way of populating the data validation list of a cell
based on the selection in another list driven data validated cell?

For example:

Using the table below,

Col_A Col_B
1 Football
1 Running
2 Baseball
2 Swimming


I want Cell A2 to have the list options 1 and 2.
Then if the user selects 1 in Cell A2, I want the user to have the
options Football and Running in Cell B2.

Regards,
Ciarán
 

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

Can the data validation list range of one cell be driven by thecontents of another cell? 3
Data Validation List 1
Variable Validation List 2
Link a text box based on drop down box with four options MS Word 365 0
Dependent Data Validation 3
SUMIF, use List as a Range 2
Conditional Formating based on Data Validation 3
Turning on data validation in one cell based on the contents ofanother cell 1

Top