how do I compare versions of an Excel worksheet
 

I have a worksheet file (of contacts information) from 1998 and another from
2006 which are the same size (25kb). I now need to update the data. I suspect
there's no change in the data between the two versions, just a change in the
way I have coded file names, but I need to be sure.

Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the Review
tab?

Alexa

how do I compare versions of an Excel worksheet
 

Hi Alexa,

Maybe this,
Say you have two sheets in one file Sheet1 and Sheet2.
Then place this formula in A1 of Sheet3 and drag across
and then down as far as needed.
=IF(Sheet1!A1=Sheet2!A1,"",1)

A one will show wherever there is a difference.

You can adapt the same principle to compare from
workbook to workbook, just adapt the references.

Or you can copy the sheets into the same workbook.

HTH
Martin


"Alexa McLaughlin" wrote in
message ...
I have a worksheet file (of contacts information) from 1998 and another
from
2006 which are the same size (25kb). I now need to update the data. I
suspect
there's no change in the data between the two versions, just a change in
the
way I have coded file names, but I need to be sure.

Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the
Review
tab?

Alexa

how do I compare versions of an Excel worksheet
 

Dear Martin

Many thanks. It worked a treat.

Alexa

"MartinW" wrote:

Hi Alexa,

Maybe this,
Say you have two sheets in one file Sheet1 and Sheet2.
Then place this formula in A1 of Sheet3 and drag across
and then down as far as needed.
=IF(Sheet1!A1=Sheet2!A1,"",1)

A one will show wherever there is a difference.

You can adapt the same principle to compare from
workbook to workbook, just adapt the references.

Or you can copy the sheets into the same workbook.

HTH
Martin


"Alexa McLaughlin" wrote in
message ...
I have a worksheet file (of contacts information) from 1998 and another
from
2006 which are the same size (25kb). I now need to update the data. I
suspect
there's no change in the data between the two versions, just a change in
the
way I have coded file names, but I need to be sure.

Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the
Review
tab?

Alexa

how do I compare versions of an Excel worksheet
 

Glad it helped Alexa, thank you for posting back.

Martin


"Alexa McLaughlin" wrote in
message ...
Dear Martin

Many thanks. It worked a treat.

Alexa

"MartinW" wrote:

Hi Alexa,

Maybe this,
Say you have two sheets in one file Sheet1 and Sheet2.
Then place this formula in A1 of Sheet3 and drag across
and then down as far as needed.
=IF(Sheet1!A1=Sheet2!A1,"",1)

A one will show wherever there is a difference.

You can adapt the same principle to compare from
workbook to workbook, just adapt the references.

Or you can copy the sheets into the same workbook.

HTH
Martin


"Alexa McLaughlin" wrote in
message ...
I have a worksheet file (of contacts information) from 1998 and another
from
2006 which are the same size (25kb). I now need to update the data. I
suspect
there's no change in the data between the two versions, just a change
in
the
way I have coded file names, but I need to be sure.

Is there an equivalent in Excel 2007 to Word 2007's "Compare" in the
Review
tab?

Alexa