Dear All,

I was wondering if there is a way of connecting 2 separate workbooks (A & B) so that when a certain range of data is being updated in B, it will automatically update the ones in A as well.

Attached image for your reference.

Say initially there is no serial# on workbook A, when new serial# is being entered to workbook B, workbook A will automatically being updated as well, is this doable?

Excel.jpg

Thanks in advance