Hi
On sheet1
I have named ranges "men", "women" and "children"
On sheet 2,
In Cell A1 I input "male", "female" or "minor". In B1 I need the data validation to show the names from the named range "women" if A1 contains "female", and so on,
is this possible?
thanks