Auto Filter one short list vs another very long list
It just occurred to me that the link is a single sheet.
In reality the yellow list will be on one sheet and the column G, J & N will be on another sheet, in the same columns, G, J & N.
Not sure if autofilter is okay with two sheets.
The returns need to be on the sheet with the yellow list.
Hoard
|