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!
