bi-lateral cell linking across workbooks

**excelname** · 02-16-2010, 04:15 PM

Using 2 workbooks it is simple to have cell A1 from Book2 reflect the contents of cell A1 of Book 1.

Is there a way to make it so that I can, so to speak, update cell A1 in *either* workbook and have it reflected in both? (or functionally simulate this)

If there has to be a sort of "data input" cell in each workbook, say, C1, which is reflected in A1 of both books, that would be fine. But the key is that it go both ways so that the desired value could be updated from either workbook and appear in both.

Perhaps I used the wrong terms but my search of existing solutions didn't produce anything helpful.

Thankyou

**masteff** · 02-16-2010, 07:25 PM

You need a macro in each workbook like this:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$1" Then
    Range("A1").Copy
    ActiveSheet.Paste Destination:=Workbooks("Book2").Sheets("Sheet1").Range("A1")
    Application.CutCopyMode = False
    End If
End Sub

Change the book and sheet in the destination to match your needs.