Tracking\Rolling up Workbook Changes

  • Thread starter Thread starter MEI
  • Start date Start date
M

MEI

We have a document which multiple people work on. They will take a copy of
the document, make changes, add worksheets then submit the document back to
a member of our administrative staff who needs to figure out what changes
were made then roll all of the changes back up in to a master version. This
is a very laborious process for the administrative staff member. Is there
any built in function in Excel which will handle this automatically?
Thanks,
JP
 
It sounds like sharing the workbook isn't feasible?

This would allow multiple users to update it at the same time (and you could
keep track of changes). But the workbook would have to be kept where all could
have have access (network share??).

If that isn't possible, what kind of changes?

If they're just entering data into existing rows/columns and never adding
deleting rows or columns, you may be able to compare one worksheet to another
using a program that Myrna Larson and and Bill Manville's wrote:


Here's a link to the program (kept at Chip Pearson's site):
http://www.cpearson.com/excel/whatsnew.htm
look for compare.xla

It does an address by address comparison: A1 with A1, x92 with x92.

Once you insert/delete a row/column, it falls out of sync really fast.
 
Back
Top