Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I compare two workbooks that are not shared? | Excel Discussion (Misc queries) | |||
compare different workbooks | Excel Worksheet Functions | |||
How do I compare FORMULAS in two workbooks | Excel Discussion (Misc queries) | |||
Compare 2 different workbooks with the result in a 3rd | Excel Discussion (Misc queries) | |||
how do I compare columns in two different workbooks? | Excel Discussion (Misc queries) |