I have a list of IDs that I would like to select in a excel sheet. I am used to using the filter function to search for 1 ID, but now I would like to filter out all the rows with that match the ID in another columns of another sheet.
So for example, I have this reference list and other column to filter on:
REF: column to filter sheet on: output sheet desired has only these rows: a a a c b c d c d z d z x ... x y z y
I am using the latest version of excel but I'm not used to using visual basic. However, any solution to this problem is highly appreciated.