compare worksheets

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

i am not sure what you mean by "Different"
compared to what?
If you are lucky, track changes has been selected and you might be able to
identify them that way. otherwise, unless you have something to compare
against, I think you are out of luck.

"Ivano" wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

Ivano wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

--

Dave Peterson

Hi bj,
we have an orginal excel file and then every month create a copy of it for
archival purposes. So there is the "working copy" which everyone should be
updating daily and then the "monthly archive" copy which is there just for
referece purposes. But, as it turns out the archive copy was being updated
as well. so now i need to find out what changes were made to the archive
copy and transfer them over to the working copy. It's a big workbook with
many tabs. So I need something to compare each cell of the workbook and
point out the different values.


"bj" wrote:

i am not sure what you mean by "Different"
compared to what?
If you are lucky, track changes has been selected and you might be able to
identify them that way. otherwise, unless you have something to compare
against, I think you are out of luck.

"Ivano" wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

HI Dave,
Thanks for the suggestion but the compare.xla link doesn't work. Can I get
the add in anywhere else?

"Dave Peterson" wrote:

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

Ivano wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

--

Dave Peterson

It works fine for me.

I'd try to get another copy.

Ivano wrote:

HI Dave,
Thanks for the suggestion but the compare.xla link doesn't work. Can I get
the add in anywhere else?

"Dave Peterson" wrote:

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

Ivano wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

--

Dave Peterson


--

Dave Peterson

Ok. that is different question than my initial interpretation.

here is a brute force method

first make a list of all the sheets

insert a new sheet at the beginning of the book
and select a max row, max column size pair which would cover all the data in
all of the sheets (rmax, cmax) and enter these values in the macro

enter the book names into the macro as needed
use a macro such as

Private Sub finddif()
'list of sheet names starting at A1
Dim rng As Range
dim rmax as integer
rmax = ' enter rmax here
dim cmax as integer
cmax = 'enter cmax here
dim r as integer
dim c as integer
dim rr as integer
Dim i As Integer
i=1
Set rng = Range("A1")
For Each Sheet In ActiveWorkbook.Sheets
rng.Offset(0,i).Value = Sheet.Name
shn = Sheet.Name
if i = 1 goto 99
rr = 2
for r = 1 to rmax
for c = 1 to cmax
if books("book1").sheets(shn).cells(r,c)
books("book2").sheets(shn).cells(r,c)then cells(i,rr)="("&r&","&c&")":rr=rr+1
next c
next r
99 i = i + 1
Next Sheet
End Sub


this will place a set of sheet names across the first row of the new sheet
and under each will list the cells which are different
..

Like I said a brute force method


"Ivano" wrote:

Hi bj,
we have an orginal excel file and then every month create a copy of it for
archival purposes. So there is the "working copy" which everyone should be
updating daily and then the "monthly archive" copy which is there just for
referece purposes. But, as it turns out the archive copy was being updated
as well. so now i need to find out what changes were made to the archive
copy and transfer them over to the working copy. It's a big workbook with
many tabs. So I need something to compare each cell of the workbook and
point out the different values.


"bj" wrote:

i am not sure what you mean by "Different"
compared to what?
If you are lucky, track changes has been selected and you might be able to
identify them that way. otherwise, unless you have something to compare
against, I think you are out of luck.

"Ivano" wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

Hi Dave

Can you please mail me a copy of this compare add in?

Thanks
Rajula

"Dave Peterson" wrote:

It works fine for me.

I'd try to get another copy.

Ivano wrote:

HI Dave,
Thanks for the suggestion but the compare.xla link doesn't work. Can I get
the add in anywhere else?

"Dave Peterson" wrote:

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

Ivano wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

--

Dave Peterson


--

Dave Peterson

Wouldn't it be easier to just download it from the source?

Rajula wrote:

Hi Dave

Can you please mail me a copy of this compare add in?

Thanks
Rajula

"Dave Peterson" wrote:

It works fine for me.

I'd try to get another copy.

Ivano wrote:

HI Dave,
Thanks for the suggestion but the compare.xla link doesn't work. Can I get
the add in anywhere else?

"Dave Peterson" wrote:

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

Ivano wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

The link does not work.

Rajula

"Dave Peterson" wrote:

Wouldn't it be easier to just download it from the source?

Rajula wrote:

Hi Dave

Can you please mail me a copy of this compare add in?

Thanks
Rajula

"Dave Peterson" wrote:

It works fine for me.

I'd try to get another copy.

Ivano wrote:

HI Dave,
Thanks for the suggestion but the compare.xla link doesn't work. Can I get
the add in anywhere else?

"Dave Peterson" wrote:

If you wanted to look at a cell by cell comparison to compare two worksheets
cell by cell (A1 with A1, x99 with x99...), you could try this addin developed
by Myrna Larson and Bill Manville.

http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

If you think that a row or column was added or deleted, this kind of comparison
soon loses its effectiveness.

Ivano wrote:

Hi,
I have an excel file which is updated regularly and then a backup was made.
unfortunaltely the orginal as well as the backup have been updated. is there
a utility or formula etc. that I can compare the workboor or worksheets and
tell me which cells are different. I don't even need to know what the
differences are since I can do it manually, but that that would be nice.

Thanks,

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson