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

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

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

Make sure that you've got your calculation mode set to automatic, not
manual.
--
David Biddulph

"dorinn" wrote in message
...
Yes my formula is working but i cant copy it dowm because if i copy the
formula the
sheet name is always same it does not count
from 29 to 30 and then 31
i want that to happen because i have 300 sheets in one document and want
to
pick 10 different numbers from each document specific number and put it on
the front site
and thats why i need to copy down the formula i was sending in


"Shane Devenshire" wrote:

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

it has nothing do to with calculatiion

because whan i enter an formula that is working
='2'!$B$11
like this formula everything is working at the formula is placed in D17
when i want to copy this formula down to D18
then it should be like this
='3'!$B$11 but that does not happen she is still

='2'!$B$11 this

and i need this formula on at least 1000 places with different sheet format





"David Biddulph" wrote:

Make sure that you've got your calculation mode set to automatic, not
manual.
--
David Biddulph

"dorinn" wrote in message
...
Yes my formula is working but i cant copy it dowm because if i copy the
formula the
sheet name is always same it does not count
from 29 to 30 and then 31
i want that to happen because i have 300 sheets in one document and want
to
pick 10 different numbers from each document specific number and put it on
the front site
and thats why i need to copy down the formula i was sending in


"Shane Devenshire" wrote:

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

The formula you were advised to use was not
='2'!$B$11

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

If you have now changed your requirements from '29'!$H$39 to '2'!$B$11, the
formula should be
=INDIRECT("'"&ROW(A2)&"'!$B$11") and when you copy that down the column, the
next row's formula will show =INDIRECT("'"&ROW(A3)&"'!$B$11") and so on.
--
David Biddulph

"dorinn" wrote in message
...
it has nothing do to with calculatiion

because whan i enter an formula that is working
='2'!$B$11
like this formula everything is working at the formula is placed in D17
when i want to copy this formula down to D18
then it should be like this
='3'!$B$11 but that does not happen she is still

='2'!$B$11 this

and i need this formula on at least 1000 places with different sheet
format





"David Biddulph" wrote:

Make sure that you've got your calculation mode set to automatic, not
manual.
--
David Biddulph

"dorinn" wrote in message
...
Yes my formula is working but i cant copy it dowm because if i copy the
formula the
sheet name is always same it does not count
from 29 to 30 and then 31
i want that to happen because i have 300 sheets in one document and
want
to
pick 10 different numbers from each document specific number and put it
on
the front site
and thats why i need to copy down the formula i was sending in


"Shane Devenshire" wrote:

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