Comparing data on two sheets

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top