Hi,
check out this link and you might need to modify the code in-between
http://www.exceltip.com/show_tip/Cel...Excel/476.html

regards
Kamal

"ibeetb" wrote in message
...
If I run a query to create a recordset....and then copy it to Excel....and
then later on that day, I run the SAME query..but this 2nd recordset,
based
on the same query as the first, has been updated with new items. What is
the
easiest way to just compare this new recordset with the old one (or either
compare the two resulted recordsets once they have been copied to excel).
What I want to do is extract the updated items from recordset 2 and add
them
to the results of recordset 1...would like to do in code.

Currentl;y, I copy both to excel and use array formulas to compare the
2...it takes far too loong.....