Forum Discussion
Select specific cells for data validation
Is there a way to select specific cells from a list that only show within a data validation set? For example: I have a list of fruits (Apple, Pears, Grape, Banana), but for this data validation ...
Hi Carlos2750,
You could try using a Dependent Drop Down List to do this. There is a blog post on Trump Excel (https://trumpexcel.com/dependent-drop-down-list-in-excel/) that explains how to do this.
I hope this helps!