View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Comparing two worksheets

look at Chips stuff on duplicates at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ps.com...
I have seen that there are already other discussions regarding this and
I have gone through quite a few but couldn't quite make sense of it or
use the assistance provided there.

I have two worksheets. They have multiple columns and I need to compare
the two sheets to look for any data thats missing in either sheet or
any row that has different info for an employee and then highlight
where the difference is arising. Can anyone help about me with this?
Thanks in advance.