Hi,
I have a filtered array result of text that appears in sheet 2. I want sheet 1 to display those results as a data validation list.
In the past I have used a table for the drop down list, but in that instance I had data that was manually entered, I wish to use data that will change dynamically.
Can a filtered array be added to a table? That would be my first preference - for all my formulas link to a table.
Otherwise how can I get the results of a filtered array to be available as a data validation list?
Thank you for your time,
I have a filtered array result of text that appears in sheet 2. I want sheet 1 to display those results as a data validation list.
In the past I have used a table for the drop down list, but in that instance I had data that was manually entered, I wish to use data that will change dynamically.
Can a filtered array be added to a table? That would be my first preference - for all my formulas link to a table.
Otherwise how can I get the results of a filtered array to be available as a data validation list?
Thank you for your time,