You don't need VBA - it can be done with formulae that same as you might when comparing data on two different worksheets in the same workbook. Depending on the formulae used, you might need to have both workbooks open to do any updating.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]