Track changes across two workbooks

  • Thread starter Thread starter Scott A
  • Start date Start date
S

Scott A

Does anyone know if changes in workbook A can show changes in workbook B if
workbook B references workbook A?

For example. Workbook A, cell A1 has Jim. Therefore, workbook B, cell A1
has Jim.

If workbook A, cell A1 is changed to James, is there a way to flag the
change in workbook B?

Reason for the question is our office gets a feeder file that we use and we
are trying to flag any changes on our workbook.

I appreciate any help.
 
I think I had answered this last week...

Anyway 'Track Changes' does not work across files. It is designed to track
changes between two versions of the same workbook.

You can write a macro or have another workbook/worksheet where in each cell
you compare the corresponding cells in the other workbook and write the value
from one of those (or both of them as per your preference) ...
 
Thank you for the confirmation. I didn't think it was possible, but I wasn't
prepared to hang my hat on it.

Appreciate the response.
 
Back
Top