Forum Discussion

Palvendor's avatar
Palvendor
Icon for Microsoft rankMicrosoft
Feb 24, 2025

Filtering using other workbook's values

I have 2 workbooks (wb). wb1 has all records with many columns, 'city' is one of them. It includes all cities from US. wb2 has Washington cities. I want to filter city column of wb1 upon Washington cities. Means remove all records which are NOT Washington state cities. How can I do this? Please help.

Resources