M
Markus F. Robinson
Objective: populate a cell with the contents of another cell by reference
using the '=<cell_location' paradigm
It works when populating from a cell on the same worksheet. e.g. A3=A2
operates correctly.
However a reference from another worksheet is populated to the wrong cell.
with the wrong contents! And it seems to be a function of how many rows of
data are in the worksheet being referenced...
Microsoft Excel 2000 9.0.6926 SP-3
Sheet One has 1, 2, 3 entered into cells A1, A2, & A3.
Correctly C1 = A1 will return 1, C2=A2 will return 2, etc.
However...
Sheet2 A1=Sheet1!A1 results in Sheet2 C1 being populated with Sheet1!C1 &
Sheet2 B1=Sheet1!B1 results in Sheet2 C1 (yes the same cell as before) being
overwritten with =Sheet1!B1
and ... arbitrarily, Sheet2 A3=Sheet1!A3 results in Sheet2 E6 being
populated with =Sheet1!E6
Go figure... This is all running on a new DELL M70 workstation laptop
running the lattest BIOS
using the '=<cell_location' paradigm
It works when populating from a cell on the same worksheet. e.g. A3=A2
operates correctly.
However a reference from another worksheet is populated to the wrong cell.
with the wrong contents! And it seems to be a function of how many rows of
data are in the worksheet being referenced...
Microsoft Excel 2000 9.0.6926 SP-3
Sheet One has 1, 2, 3 entered into cells A1, A2, & A3.
Correctly C1 = A1 will return 1, C2=A2 will return 2, etc.
However...
Sheet2 A1=Sheet1!A1 results in Sheet2 C1 being populated with Sheet1!C1 &
Sheet2 B1=Sheet1!B1 results in Sheet2 C1 (yes the same cell as before) being
overwritten with =Sheet1!B1
and ... arbitrarily, Sheet2 A3=Sheet1!A3 results in Sheet2 E6 being
populated with =Sheet1!E6
Go figure... This is all running on a new DELL M70 workstation laptop
running the lattest BIOS