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

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

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