Comparing two worksheets

  • Thread starter Thread starter andrewk73
  • Start date Start date
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??
 
Hi Andrewk73!

Try:

Tools > Track Changes.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Track changes will not work as i recieve a brand new spreadsheet ever
day from an outside source.

Each day I recieve on email a spreadsheet that may have extr
information or one of the cells is has changed.

If i was making the changes I would use track changes, but I'm no
making the changes
 
Hi Andrew,

If the two files have the same format and layout, I'd
suggest you to write a Excel Marco to compare every cell
and change the font color to red (if diff).

HTH,
Frankie
 
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
 
Hi Andrewk73!

You should take a look at:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm

All sorts of formulas for dealing with duplicate and unique entries.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Andrewk73!

Also see:

http://www.cpearson.com/excel/whatsnew.htm
Look 14-Jun-2000 Compare.xla

It's an Addin written by Myrna Larson and Bill Manville that does a
cell by cell comparison.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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.
 
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
 
Hi AndrewK,
I am stuck in a similar problem. Please can i have a look at the too
that you have created.
Thanks,
Lonel
 
Back
Top