Comparing two worksheets

A

andrewk73

Every day I recieve an updated spreadsheet and I have to check throug
and look at what has changed in the spreadsheet from the day before.

I was looking to automate this process so I can easily see if somethin
has changed.

Any Suggestions??
 
R

raymondsum

Hi Andrewk73,

Sheet1 = new records (A1..A20)
sheet2 = old records (A1..A20)

Try:

In sheet 1, Cell B1, type

IF(ISERROR(VLOOKUP(A1,Sheet2!A:A,1,FALSE)), "","duplicate" )

HT
 
B

bobelliot

Please, try Compare Suite (http://www.comparesuite.com).

It is a powerful comparison utility, which inludes two features you
need:

1) It allows compare excel files (.xls)
2) It allows to do it automatically, so on every comparison you will
get a comparative report with changes details.
 
A

andrewk73

Thanks bob.

I love the comparison tool. I tried it, very useful. However
understand what it is doing, and the report is clear to me, however th
people who will be using this report are not very computer literate
and they are scared of even auto filter(The devil).

I have designed a tool that uses lookups and if statements to compar
all the cells and the rows. I just finished it yesterday and am i
final testing. Just sorting out the protection so they don't destro
it.

It is great when you develop something that works. :) Feeling good a
the moment.

Thanks for your help

And
 
L

Lonely

Hi AndrewK,
I am stuck in a similar problem. Please can i have a look at the too
that you have created.
Thanks,
Lonel
 
Top