Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible in Excel to link two cells together (in different workbooks) so that a change in either is reflected in the other cell?

The one-way linking whereby one cell is a view of the value in the other cell is easy. I'm after a two-way linking so that a user could update either cell and have the value reflected in the other.

share|improve this question
In different work books or work sheets? The prior can only be solved using VBA, the latter can be done using some simple formulas. – Breakthrough Aug 18 '11 at 16:08
It was workbooks I was looking to get an answer for. – Dave Potts Sep 9 '11 at 14:45
To reference a cell or range in a different workbook, you can follow this guide. – Oliver Salzburg Feb 6 '12 at 18:29

Across workbooks is not possible, but across worksheets in the same workbook is:
For this private sub, right click the Excel button and hit view code

Private Sub Workbook_TwoWayMatch(ByVal Sh As Object, ByVal Target As Range) 
    If UCase(Sh.Name) = "sheet1" Or UCase(Sh.Name) = "sheet2" Then 
        If Not Application.Intersect(Target, Range("A1")) Is Nothing Then 
            Application.EnableEvents = False 
            If UCase(Target.Parent.Name) = "SHEET1" Then 
                Sheets("Sheet2").Range("A1") = Target 
                Sheets("Sheet1").Range("A1") = Target 
            End If 
            Application.EnableEvents = True 
        End If 
    End If 
End Sub 
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .