Indirect function
 

=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

Indirect function
 

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

Indirect function
 

$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

Indirect function
 

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

"Eden397" wrote in message
...
=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

Indirect function
 

"Bernard Liengme" wrote:

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

"Eden397" wrote in message
...
=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


LIFE SAVER!!

Indirect function
 

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

Tyro

"Eden397" wrote in message
...
=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

Indirect function
 

=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