Indirect function

[Eden397]

=INDIRECT($A$3&"!B53")

I want to autofill down my column but have the B53 change to B54, B55, etc.
How do I set that up. I think it has something to do with "rows"? Thanks,
Eden 397

 

[Mike H]

Hi,

Possibly

=INDIRECT("A3")&B54

Mike

 

[Eden397]

$A$3 is the cell containing the tab name that I want to pull B54 from so I
need it to stay as is but was wondering if I could use the "row" function to
autofill my B54 with the next cell down.

 

[Bernard Liengme]

=INDIRECT($A$3&"!B"&ROW(B53))
best wishes

 

[Eden397]

=INDIRECT($A$3&"!B"&ROW(B53))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email




LIFE SAVER!!

 

[Tyro]

Perhaps =INDIRECT($A$3&"!B"&ROW(B53))

Tyro

 

[Gord Dibben]

=INDIRECT($A$3&"!B" & ROW(53:53))


Gord Dibben MS Excel MVP