Two-Way Data Sync

Hello all

Here's a million-dollar question I cannot find an answer for anywhere. I think a lot of people (incl. me) will find the solution extremely valuable:

I wish to sync the data between two workbooks. If a change is made in either workbook, it should be reflected in the other workbook.

Basic example:
Input is typed into cell A1 in Workbook1/Sheet1. That input is then sent to cell A1 in Workbook2/Sheet1. Most importantly, it also has to work the other way around: If input is typed into cell A1 in Workbook2/Sheet1 it is reflected into cell A1 in Workbook1/Sheet1. With no maintenance needed or change of formulas.


Is this possible with VBA?
If not, do you suggest a combination of other languages (XML, Python, Java)?

I appreciate all thoughts on this!

It is possible with VBA
I'd even say it is very easy if both workbooks are open at the same time.

To help you with further investigation - have a look on Worksheet_Change event (it has to be programmed in both workbooks)

Important tip - the event handler has to contain

Please Login or Register  to view this content.

just before writing to second workbook and reenabling just after that.