|
|
#1
03-28-2013, 01:59 PM
|
|||
|
|||
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? 
|
| Tags |
| advanced filter, comparison, worksheets |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need To Compare Two Worksheets, Update Current Records And Insert New | David92595 | Excel | 1 | 07-20-2012 07:00 AM |
 Need help matching text to the Character Map
|
Bobosmite | Word | 1 | 07-12-2012 08:12 AM |
| Macro for Advanced Filter | atwood121 | Excel Programming | 0 | 05-22-2012 07:47 PM |
|
Advanced Filter - Comparing Two Columns
|
apolloman | Excel | 5 | 07-27-2011 04:54 AM |
|
could you help me help me with advanced filter
|
Nora | Excel | 1 | 05-15-2009 11:10 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode