|
Copying Formula
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 |
Copying Formula
=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 |
Copying Formula
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 |
Copying Formula
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 |
Copying Formula
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 |
Copying Formula
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 |
Copying Formula
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 |
Copying Formula
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 |
Copying Formula
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 |
| All times are GMT +1. The time now is 07:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com