If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare workbooks
I have several huge workbooks that I update regularly. Most of the people
simply print out the new and discard the old, however some have asked for "changes only" since the workbooks can take a ream to print out, while each worksheet is usually only 1-5 sheets and there can be changes on a only few of the worksheets; but I don't keep up my changes. My question is this: How can I easily compare two workbooks so I can create another workbook with only the "changed" worksheets? Thanks Scafidel Louisiana |
#2
|
|||
|
|||
Compare workbooks
Hi,
Well you can compare you sheets by VLOOKUP function so if you give me an example then i can send you the formula. Thanks, -- Farhad Hodjat "Scafidel" wrote: I have several huge workbooks that I update regularly. Most of the people simply print out the new and discard the old, however some have asked for "changes only" since the workbooks can take a ream to print out, while each worksheet is usually only 1-5 sheets and there can be changes on a only few of the worksheets; but I don't keep up my changes. My question is this: How can I easily compare two workbooks so I can create another workbook with only the "changed" worksheets? Thanks Scafidel Louisiana |
#3
|
|||
|
|||
Compare workbooks
The two workbooks, (old, new) have the same named sheets which near 90; but
the updated "new" could be an addition or deletion of information on the sheets, i.e., a name, an address, a phone number, a calculation. I don't need the actual differences, only a list of the worksheets with at least some change. With this list, I could easily delete the unchanged pages making another workbook. I want to end up with a third workbook with the sheets that have been changed. Scafidel Louisiana "Farhad" wrote: Hi, Well you can compare you sheets by VLOOKUP function so if you give me an example then i can send you the formula. Thanks, -- Farhad Hodjat "Scafidel" wrote: I have several huge workbooks that I update regularly. Most of the people simply print out the new and discard the old, however some have asked for "changes only" since the workbooks can take a ream to print out, while each worksheet is usually only 1-5 sheets and there can be changes on a only few of the worksheets; but I don't keep up my changes. My question is this: How can I easily compare two workbooks so I can create another workbook with only the "changed" worksheets? Thanks Scafidel Louisiana |
Thread Tools | |
Display Modes | |
|
|