View Single Post
 
Old 03-28-2013, 01:59 PM
morgantobin morgantobin is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Mar 2013
Posts: 1
morgantobin is on a distinguished road
Question 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?
Attached Files
File Type: xlsx Ex.xlsx (9.2 KB, 10 views)
Reply With Quote