Selective data validation list

[Mike Clemens]

I have data validation applied to a cell using a list that's on another
worksheet in the same workbook. This was done with a dynamic named range and
works fine.

Now I want to change things so that items only appear in the drop down list if
the value of a another column in the worksheet with the list items is set to
"Yes". Each of the possible list items has either "Yes" or "No" in the column
next to the list item.

Is there a way to accomplish selection of the items to appear in the drop down
validation list based on the value of a column next to each of the possible list
items?

Thanks

Mike Clemens

 

[T. Valko]

You would have to extract those items into a separate list and use this new
list as the source for the drop down.

Or, if you can sort the data on "Yes" so that all items that correspond to
"Yes" are grouped together then you can use a formula to get the correct
items for the list.

Need more detail to suggest anything more specific.