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

Try this

=INDIRECT("'" & ROW(A29)&"'!$H$39")

Mike

"dorinn" wrote:

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

=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

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

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

Hi,

Try this, in A1 enter 29 and in A2 enter 30
then in B1 enter the formula

=INDIRECT(A1&"!A1")

and copy it down

This should also work

=INDIRECT(ROW(A29)&"!A1")

This is the same idea as the previous posts but a little simplier

If this helps, please click the Yes button.

Cheers,
Shane Devenshire



"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