Hey

Is it possible to edit a value in a cell in sheet 1, so that it also changes in sheet 2, and then if i change the value in sheet 2 then it changes back in sheet 1 again?

I have tried this macro, but it doesn't do the magic.

ThisWorkbook.Sheets("Sheet2").Range(Target.Address) = Target.Value
Does anyone have a solution to this?