Assuming your sheet names are just numbers like 29, 30, 31 etc. the posted
formula does work.

If your sheet names are something other please let us know.


Gord Dibben MS Excel MVP


On Tue, 2 Dec 2008 17:05:01 -0800, dorinn
wrote:

hello again

this is not working

i will explain the formula better

='29'!$H$39 ='nameofsheet'!$column$row
='30'!$H$39
i need the name of sheet which is number to go up
"David Biddulph" wrote:

=INDIRECT("'"&ROW(A29)&"'!$H$39")
and copy down.
--
David Biddulph

"dorinn" wrote in message
...
i have an problem with formula

i am trying to copy formula down but it seems it is not working

='29'!$H$39 in row 47 and i need
='30'!$H$39 in row 48 and so on

thanks