=INDIRECT(ROW(536:536) & "!$D$7") entered in A536 then copied down.


Gord Dibben MS Excel MVP


On Mon, 14 Jul 2008 12:56:07 -0700, BarryMart
wrote:

I have a formula in A536 that reads:
='536'!$D$7

I want the formula in A537 to read:
='537'!$D$7

and so on...

Any ideas welcomed and appreciated!

Thanks,
Barry