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 I (the user) only want to show Apple and Grape so checkbox them so these are the only 2 fruits that appear in the drop down list in the 2nd tab.
Obviously the earliest option is to just delete the fruits I don't want in the list but I want the list to stay the same, so it can be reused time and time again without having to reproduce the list.
I have attached an example sheet with the contents that I am looking to use.
