On 8/21/06, Terry <[EMAIL PROTECTED]> wrote:
To prevent the cell reference changing, you will need to use absolute references
such as =Sheet2.$A$1 The $ signifies that the reference is absolute. If you
are only dragging down, only the row number needs to be absolute. If you are
only dragging across, only the column number needs to be absolute.
To get the numbers incrementing, you will need to enter them as numbers in
separate cells. Let's say you are using Sheet1. Enter 1 in A1 and drag it down
to increment it. In B1 enter =Sheet2.$A$1 & A1 and drag that down.
Hide the numbers column or enter your numbers on Sheet2 if you do not want them
to be visible on Sheet1: =Sheet2.$A$1 & Sheet2.B1 (where the numbers are in
column B on Sheet2.
Regards.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi, Terry,
Thank you very much for the reply. The method seems a little awkward
but it does solve my question.
--
WANG, Xiaoyun
Shanghai, China
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
