Indirect - drag cells down

[pauldaddyadams]

Hi,

I have an indirect formula which references any other sheet:
=INDIRECT("'"&$D$2&"'!"&"D7")

Is there any way I can drag this down but then have excel automatically populate the next cell e.g. D7, then D8, then D9?

On the attached example I would like to drag the formula into D11,D12,D13 withouth having to manually correct the range.

Any ideas please?

[Ali Kırksekiz]

Please Login or Register  to view this content.

then drag down

[pauldaddyadams]

Many thanks, this worked!