Hi Neo,
Try the Compare add-in, created by
Myrna Larson and Bill Manville, which
can be downloaded from the
Downloads page on Chip Pearson's site:
http://www.cpearson.com/Excel/download.htm
---
Regards.
Norman
"potentus" wrote in message
...
Hi,
I have 2 excel sheets generated daily :
Daily a
Daily b
I need to compare column A in "Daily a" to Column a in "Daily b" and
show all items that dont appear in both (deltas)
So for example the number 1 only appears in "Daily a" it would be
listed, but if it was in both daily spreadsheets it would not
Thanks
Neo