Multi-sheet variable switching

[elevenaminla]

Hi everyone,

I was wondering if I could link cells on different sheets that when changed on one sheet, changes linked ones on others?

e.g. I type "hello" into Sheet1 A1, and Sheet2 A1 changes to "hello"

or I type "hello" into Sheet2 A1, and Sheet1 A1 changes to "hello"

Can I do that?

Thanks!

 

[pgc01]

The code is exactly as you should paste.

Please start by trying the simple test I posted

Just open a new workbook, paste the code in the first 3 (Sheet1, Sheet2 and Sheet3) and test.

 

[elevenaminla]

Worked perfectly in a new workbook.

 

[pgc01]

Worked perfectly in a new workbook.

Great!

Did you already try now to adapt it to your other workbook?

In case it doesn't work, paste the code you use, the line where the code stops, the exact error message and the current values of the variables.