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


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 12:07:01 -0800, Eden397
wrote:

$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.

"Mike H" wrote:

Hi,

Possibly

=INDIRECT("A3")&B54

Mike

"Eden397" wrote:

=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