Advanced Filter - Copy matching records in two worksheets
I have attached an example of what I am trying to do with an Advanced filter.
I am trying to find a way to filter using Advanced filter to copy into Sheet3 records from Sheet1 that do not appear in Sheet2, based on comparison of only Col2 (as details in Col1, etc.... may change).
Any ideas/help?
|