Indirect Funtion

[Guest]

Is there a way to fill down and right a cell that has the
Indirect Function in it that alters the second cell
referrence.

As an example, if the first funtion is =Indirect(A1 & "!
A2") and as I fill down I would like the A2 to change to
A3, A4, A5 ... and if across, B2, C2, D2 ...

I have a very large spread sheet and want to avoid
retypeing the formula in.

Thanks in advance

Jim

 

[Peo Sjoblom]

One way copied down or across

=OFFSET(INDIRECT($A$1&"!A2"),ROW(1:1)-1,COLUMN(A:A)-1)

 

[Guest]

Thank you! It works perfectly

-----Original Message-----
One way copied down or across

=OFFSET(INDIRECT($A$1&"!A2"),ROW(1:1)-1,COLUMN(A:A)-1)



--

Regards,

Peo Sjoblom





.