indirect reference across multiple worksheets

[Mark McInerney]

Hi,

I am trying to copy fill an indirect formula.

=INDIRECT("'"&B4&"'!B12") It is working fine - when I copy it down it moves the reference Cell B4 to B5 etc.

I want the cell B12 to change as I copyfill down? Is this possible?

In short, the B4 reference moves to B5, but I also want the B12 reference to move to B13 - is this possible?

Thanks for any help - Best - Mark.

 

[Toadstool]

Hi Mark,

You can use CELL with a relative address. e.g. here's my data sheet "Sheet Test"

Here's my INDIRECT copied down

 

[Mark McInerney]

Hi,

Sorry for delay in getting back to you = tried this out - works perfectly - Many Thanks - Take care - Mark.

 

[Toadstool]

You're welcome and thanks for confirming.