Posted to microsoft.public.excel.programming
|
|
Comparing data on two sheets
Hi
see:
http://www.cpearson.com/excel/duplic...#InOneNotOther
-----Original Message-----
I need to be able to compare data on sheet1 with sheet2
and either highlight differences or create a new file.
My problem is as follows:
My user has sheet1 with his data on, sheet2 is downloaded
from a database. The sheets will not contain the exact
same details, I need to lookup the value in column A on
sheet2 and if found in column A of sheet1 check if
details
on both rows are identical.
Is this possible?
Any help gratefully received.
Gareth
PS
I got Chip Pearsons compare add-in but it doesn't do
exactly what I need.
.
|