Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
To reference a cell or range in a different workbook, you can follow this guide. –  Oliver Salzburg Feb 6 '12 at 18:29

1 Answer 1

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 
            Else 
                Sheets("Sheet1").Range("A1") = Target 
            End If 
            Application.EnableEvents = True 
        End If 
    End If 
End Sub 
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.