Naba

Use a VLOOKUP function on each set of data, like

=VLOOKUP(A2,Sheet2!$A$1:$A$10000,1,FALSE)

and then any #N/A errors will be where data does not exist in the lookup
table (In this case A1:A10000)

You can then autofilter and copy the data elsewhere, repeat for the other
data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Naba via OfficeKB.com" <u23570@uwe wrote in message
news:62d40bec186bf@uwe...
Hi all,

Recently i was given an excel workbook with two worksheet, both contain
the
same data up a 10000 records each, i want to compare the two work sheets
and
than copy the missing data to another worksheet using macro, if anyone
can
help me with this please i would be grateful.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200607/1