Drag and autofill

[Andrew XJ]

I don't know whether it is a silly question but i really can't solve it.
in Sheet1:
in Cell A1 I input formula ='Sheet2'!$A1
in Cell A2, ='Sheet2'!$A4
I want to use Select and drag to autofill the subsequent. But fail. I have also added a series 1,4,7 to the series. I have used Macro to solve this problem, but how to use select and drag to auto fill the formula?

 

[Juan Pablo González]

Try with:

=INDIRECT("Sheet2!A" & (3*ROW(A1)-2))

and drag down.

 

[Mark W.]

Here's another way... that will leave the simplest formula in these cells.

1. Enter "Sheet2!$A1" (without the quotes) in cell Sheet1!A1 (or wherever).
2. Enter "Sheet2!$A4" in cell Sheet1!A2.
3. Select cells A1:A2 and drag the fill handle down the column as far as needed.
4. Select column A:A and choose the Edit | Replace... menu command replacing all instances of "Sheet2" with "=Sheet2".
This message was edited by Mark W. on 2002-02-26 06:59
This message was edited by Mark W. on 2002-02-26 07:15

 

[Andrew XJ]

Thanks!!! Juan and Mark. Both of your methods works fine!!

 

[Q]

q