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
Bookmarks