| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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, |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
It worked for me and I was redirected to:
http://www.cpearson.com/excel/whatsnew.aspx I still had to look for compare.xla. Rajula wrote: 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 -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
Hi,
When i click on compare.xla, i get The page cannot be found error. Says this page was removed. Rajula "Dave Peterson" wrote: It worked for me and I was redirected to: http://www.cpearson.com/excel/whatsnew.aspx I still had to look for compare.xla. Rajula wrote: 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 -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
Did you click on the Contact button and describe the problem for Chip? I'm sure
he'd want to know. http://www.cpearson.com/Zips/Compare.ZIP Rajula wrote: Hi, When i click on compare.xla, i get The page cannot be found error. Says this page was removed. Rajula "Dave Peterson" wrote: It worked for me and I was redirected to: http://www.cpearson.com/excel/whatsnew.aspx I still had to look for compare.xla. Rajula wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compare worksheets
Hi Dave,
The link below worked. THanks .. Regards Rajula "Dave Peterson" wrote: Did you click on the Contact button and describe the problem for Chip? I'm sure he'd want to know. http://www.cpearson.com/Zips/Compare.ZIP Rajula wrote: Hi, When i click on compare.xla, i get The page cannot be found error. Says this page was removed. Rajula "Dave Peterson" wrote: It worked for me and I was redirected to: http://www.cpearson.com/excel/whatsnew.aspx I still had to look for compare.xla. Rajula wrote: 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to compare 2 worksheets... | Excel Discussion (Misc queries) | |||
| Compare Worksheets | Excel Discussion (Misc queries) | |||
| compare worksheets | Excel Discussion (Misc queries) | |||
| Compare two worksheets | New Users to Excel | |||
| How do I compare in between two worksheets? | Excel Worksheet Functions | |||
Linear Mode
