Synchronize two excel workbook

Copper Contributor

Dear Community,


Would you please let me know if it is possible to synchronize two workbooks? For example, Main Workbook (Main.xlsx) has a table containing ten raw data; I would like these ten raw data with similar formatting to appear in Reference Workbook (Reference.xlsx). Whenever new row is inserted in Main Workbook, it appears in Reference Workbook, furthermore, whenever I insert in Reference Workbook, it also appears in Main Workbook.


Any advice would be greatly appreciated!

Stay safe!



1 Reply