Sync cells over multiple workbooks with VBA

Hello everyone,

I have a special request that I cant solve on my own. I searched all over the internet but could not find anything. I really want to prusue my goal because I am an intern at my company.

I have two documents ("workbooks"). One is called "Doc1", the other one is called "Doc2". Both documents comprise of one table "Table1".
I want to sync the cells A1 between Doc1_Table1 and Doc2_Table1. This needs to work in both ways, e.g. if I make changes in Doc1_Table 1 cell A1, it should sync to Doc2_Table1 cell A1 and vice versa.
I already found a way to sync cells from different tables WITHIN one document. But don't know how to change the code to sync over two documents.

WITHIN the document I can sync two cells over different tables (e.g. table1 & table2) like that:

(this is what i put into table1 to connect to table 2 - and in table two i have the same but replaced for table1)

Please Login or Register  to view this content.

Private Sub Worksheet_Change (ByVal Target As Range)
If Intersect (Taget, Range ("A1")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Sheets("Table2") .Range("A1") = Target
Application.EnableEvents = True
End Sub

Please Login or Register  to view this content.

now i need a smiliar code but OVER the two documents.. please help!

One idea was to define the location more precisely:

Please Login or Register  to view this content.

Private Sub Worksheet_Change (ByVal Target As Range)
If Intersect (Taget, Range ("A1")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Workbooks("Doc1.xlsm").Sheets("Table1") .Range("A1") = Target
Application.EnableEvents = True
End Sub

Please Login or Register  to view this content.

But this did not work either!

Your help is highly appreciated! Thank you very much!

HTML Code: 

[/HTML]

Please note that you have ignored two or our most basic forum rules you agreed to abide by when you joined.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Please repair both of these issues.