Copying Formula

  • Thread starter Thread starter dorinn
  • Start date Start date
D

dorinn

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
i need the name of sheet which is number to go up
 
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
 
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
 
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
 
Make sure that you've got your calculation mode set to automatic, not
manual.
 
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
 
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.
 
Back
Top