Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel Check two spreadsheets against one another for changes?
I have two spreadsheets one an original and the other has been revised by a
second party. Is there a way that Excel can go through the original and highlight any additions, subtractions, changes, etc... Thank You, Judd Sandstrom |
#2
|
|||
|
|||
It depends.
If the changes do not include removing rows or columns (or inserting rows or columns), then you could use a program written by Myrna Larson and Bill Manville. You can find a copy on Chip Pearson's site: http://www.cpearson.com/excel/whatsnew.htm look for compare.xla But remember this does a cell-by-cell comparison against two worksheets--not workbooks. A1 compares to A1, x99 to x99, etc. (So if you insert/delete a row/column, the comparison goes south very quickly.) Another option could be to save the worksheets (not workbooks) as a couple .CSV files. Then use some text comparison file to find the difference. (MSWord has this ability.) But this compares text (current values of formulas). Not the formulas themselves. And if you have a single unique key in each worksheet that should be compared, you could have a program that looks for matching keys and if found, does a comparison between the cells on those rows. (Or adds it as a new key--or marks it as a deleted record.) jbsand1001 wrote: I have two spreadsheets one an original and the other has been revised by a second party. Is there a way that Excel can go through the original and highlight any additions, subtractions, changes, etc... Thank You, Judd Sandstrom -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Words In Excel Spreadsheets & Word Documents | Excel Discussion (Misc queries) | |||
importing excel spreadsheets into web-based applications | Excel Discussion (Misc queries) | |||
Excel should have a function to verify the check digit on UPC num. | Excel Discussion (Misc queries) | |||
Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) | |||
Viewing Excel spreadsheets | Excel Discussion (Misc queries) |