#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I compare two workbooks that are not shared? Jonny Excel Discussion (Misc queries) 2 January 5th 07 04:04 PM
compare different workbooks kjstec Excel Worksheet Functions 1 October 17th 06 07:34 PM
How do I compare FORMULAS in two workbooks Doug Gault Excel Discussion (Misc queries) 2 May 6th 05 05:36 PM
Compare 2 different workbooks with the result in a 3rd cursednomore Excel Discussion (Misc queries) 1 March 18th 05 02:48 PM
how do I compare columns in two different workbooks? Provider98122 Excel Discussion (Misc queries) 5 March 10th 05 04:33 AM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"