Microsoft KB Archive/20809

Multiplan: How the External Copy “to:” Field Works PSS ID Number: Q20809 Article last modified on 10-17-1990 PSS database name: D_MPlan

1.x 2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

The “to:” field of the External Copy command can specify either the entire area being copied into, or just the upper-left cell of the range into which you want the external data copied. Multiplan takes care of the rest.

For example, you would do the following to copy the contents of file X, r1:5c1, into file Y, r21:25c5:


 * 1) Load file Y.
 * 2) Choose Xternal Copy.
 * 3) Enter X in the “from sheet:” field.
 * 4) Enter R1:5C1 in the “name” field.
 * 5) Enter R21C5 in the “to:” field.

If you enter the complete range of the target area instead of just entering the upper-left cell of the target area, the range of the Target area and the range of the Source area must match exactly in size and shape.

If data coming in is 5 rows x 10 columns, the area receiving the data must also have 5 (blank) rows x 10 (blank) columns available to receive data. The data will not fit into an area with 10 rows x 5 columns.

Copyright Microsoft Corporation 1990.