If I transfer a cell from sheet 1 to sheet 2 and then change the cell on #1 it does not chg on #2.

asked 2019-09-18 15:51:43 +0100

mike100 gravatar image

I trans cell from sheet #1 to sheet #2. Then change cell on #1. Cell on sheet#2 does not change.

edit retag flag offensive close merge delete


Why do you expect the cell to change on sheet#2? (It will only change if there is a reference similar to =$Sheet1.A1

Opaque gravatar imageOpaque ( 2019-09-18 16:06:59 +0100 )edit

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.

HerCorns gravatar imageHerCorns ( 2019-09-19 14:33:53 +0100 )edit