[HELP] Automatically transfer data from A workbook to B workbook

[nitrogen_pp]

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

[gmr4evr1]

Have you tried this?
Under the Data tab, Click From Other Sources, then click From XML Data Import. You might have to change the file type to All Files to show the file (Workbook A) you want then select it.
This will link the 2 workbooks and anytime Workbook A is opened it will automatically update with the new data that has been entered.