Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy from one worksheet to another is inserted into wrong cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
How do I copy a cell from one worksheet to another worksheet | Excel Discussion (Misc queries) | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |