I trans cell from sheet #1 to sheet #2. Then change cell on #1. Cell on sheet#2 does not change.
Why do you expect the cell to change on sheet#2? (It will only change if there is a reference similar to
If trans is copying the cell (C) from sheet #1 (S1) to sheet #2 (S2) then it creates only a copy of the cell. S1C and S2C are not linked they are two different locations in memory. If you want S2C to reflect the changed that you make on S1C then you must create a pointer from S2C → S1C. This is done by entering the formula that Opaque mentions. That formula will link S2C with S1C’s value, then your change will be carried through.