Howdy,

I need to create a drop down list. The cell used to create the
data/validation in is on "Sheet 1". The list is on "Sheet 2".

Here are the specifics:
Sheet 2 list contains the following columns: column 1 = Structures,
column 2 = Guyed
The list can grow or shrink and the values can change.

Example data:
Structure Guyed
1
2 Y
3 Y

When filtered for "Guyed" structures only, the list becomes:
Structure Guyed
2 Y
3 Y

Now on Sheet1 I have a single cell that I want users to be able to
click and select a single Guyed structure. Thus, the drop down list
must only contain those structures with a "Guyed" value = Y (and don't
forget, those values can change along with the structure numbers and
thus, it must be dynamic not static).

I appreciate any guidance.
Best regards,
Brady