Assuming you mean

In Sheet1
----------
You have in A1: =Sheet2!A1
and you want to drag A1 down to produce
in A2: =Sheet2!B1
in A3: =Sheet2!C1
and so on ?

Here's one way:

In Sheet1
-----------
Put in A1: =OFFSET(Sheet2!$A$1,,ROWS($A$1:A1)-1)
Copy A1 down

This'll return the desired links to Sheet2's A1, B1, C1, etc

Note that the formula could also be placed in any starting cell in Sheet1,
not necessarily in cell A1, and then copied down for the same effect

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"BDB" wrote:

How do I use a formula dragged from above (referring to cells in another
sheet) but using the same row number as referred to in the cell to the
immediate right?