Worksheet link

Hi, i want to know how to create a link between worksheets in the same workbook.

Example: i enter 25 in the sheet1 A1, this automatically appears in sheet2 A1 and if i enter 35 in sheet2 A1 then the value in sheet1 A1 change to 35, any idea?

This cannot be done with a formula

joyacv2

Asked: 2011-03-07

Advertise Here

Microsoft Excel

1 Solution

LVL 85

Rory ArchibaldCommented: 2011-03-07

>>"This cannot be done with a formula"

Can I ask why not?

LVL 1

joyacv2Author Commented: 2011-03-07

Because when you write in the cell A1 in the sheet 2 for example, and the cell contains a formula "=sheet1!A1", you erase the formula. The link can be done one way using a formula, but how i can do in two way. I will use this for the entire sheet. Thank you for your help!

LVL 85

Rory ArchibaldCommented: 2011-03-07

Oh sorry - I misread the last part of the question. You will need code for this - is that OK?

LVL 1

joyacv2Author Commented: 2011-03-07

Ok, no problem, perfect

LVL 85

Rory ArchibaldCommented: 2011-03-07

Right-click the tab for Sheet1, choose View Code then paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
   On Error Resume Next
   Application.EnableEvents = False
   Sheets("Sheet2").Range(Target.Address).Value = Target.Value
   Application.EnableEvents = True
End Sub

Open in new window

repeat for Sheet2, but changing the Sheets("Sheet2") part to Sheets("Sheet1")