Track changes across two workbooks
 

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.

Track changes across two workbooks
 

Changes in one workbook can NOT be highlighted in another workbook unless you
develop and run a macro. Conditional formatting does not work across
workbooks/sheets.

Of course if the two are linked by a formula then changes in one will
reflect in the other but won't be highlighted.

"Scott A" wrote:

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.