Excel - Data validation from a subset?

Hi all,

I've got a simple sheet here:

On a different sheet, I need this to happen:

In cell A1, If I choose either "Apple" or "Orange", I need a data validation type drop-down in cell B1 that only shows the type of that fruit.

So for example, if i choose "Apple" in cell A1, I can only choose in cell B1: "Granny Smith", "Red Delicious", or "Fuji".

Thanks in advance.
Who is Participating?
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
I've made a version of my example workbook from the previous EE question with your data as a guide.  

It does require a separate table for each input cell.  There is a dynamic range name called "TypeList" that will select the correct fruit types based on the value in cell B1 on the "Inputs" sheet.

Glenn RayExcel VBA DeveloperCommented:
You're looking for a conditional drop list that uses data validation.  To make it work, you'll need to create dynamic range names that will select the dependent data.

This EE question has both a link to an online article and an example solution that I provided that demonstrates it.

Go-BruinsAuthor Commented:
Worked beautifully. Thank you.
Glenn RayExcel VBA DeveloperCommented:
You're welcome.  Dynamic range names are very useful.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.