Populating Filters from Columns in Other Workbooks

[rob737]

Hi Forum

Hope all is well. I have a question on how to populate a selection filter from a column in a another worksheet

Sheet 1 I have three columns

Name Type Status


Sheet 2 I have three lists

List of Names
List of Types
List of Status

In Sheet 1, When I select the first cell under Name it turns on the Filter arrow and shows me a list of all names in Sheet 2 (List of names) I would like to be able to do this for the Type and Status columns, however I don’t know how it was done initially for Names.

As always any help would be greatly appreciated.

Many thanks
Regards
Rob

 

[Fazza]

hello, Rob

Is it data validation? https://www.contextures.com/xlDataVal01.html

HTH. Regards, Fazza

 

[rob737]

Hi Fazza

Great Link Thanks

 

[Fazza]

you're very welcome, Rob

there is lots of very well presented data at that excellent site - it is by Debra Dalgleish, a Microsoft Excel MVP