Comparing 2 lists

I have a spreadsheet with 2 sheets.
Sheet 1 - 7 columns, abt 4000 rows
Sheet 2 - 7 columns, abt 2000 rows.

7 columns are the same content and format on each sheet.

I want to create Sheet 3 - again 7 columns
It must contain ONLY those rows that are in Sheet 2 and not in sheet 1
I dont think there will be many

Any any ideas how to go abt this easily - its a one ooff job so doesnt need to be particulary 'user friendly'

I use office 2007 and am happy working with macros

I have no idea how to start and would appreciate help

Thanks

Hi tsrwebman,

By saying 'those rows' do you mean the entire row contents or there are some key entries which need to be checked only.
If possible, post a sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi

One simple way is this.

For Column A, try this in Sheet3!A1

=IF(COUNTIF(Sheet1!$A$1:$A$10;Sheet2!A1)>0;"";Sheet2!A1)

Copy down. Same for the others.

.

no - thats not quite correct - it would copy all the rows
try this

for each row in sheet2
for each row in sheet 1
if (Sheet2: thisrow:cells1-7 exactly matches Sheet1:this row: cols 1:7)
mark as found and exit loop
else
mark as not found
end if
next row sheet 1
if not found copy sheeet2:thisrow to sheet3
next row sheet2