Link to home
Start Free TrialLog in
Avatar of joyacv2
joyacv2Flag for Puerto Rico

asked on

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
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

>>"This cannot be done with a formula"

Can I ask why not?
Avatar of joyacv2

ASKER

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!
Oh sorry - I misread the last part of the question. You will need code for this - is that OK?
Avatar of joyacv2

ASKER

Ok, no problem, perfect
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of joyacv2

ASKER

Works perfect! Exactly what i want!
Avatar of joyacv2

ASKER

Excelent