Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COPY SUM FORMULAS TO SEVERAL OTHER WORKSHEETS
Hi.
I need some help with copying a formula from one worksheet to another. In the client template worksheet it goes as follows: =SUM('Client Template'!$B8*Data!$C$3+'Client Template'!$C8*Data!$C$4) I need the 'Client Template' part of the formula (which is the name of the worksheet) to automatically change to be name of the worksheet I am copying it to. For example, I copy the formula from "client template" worksheet to "Client A" worksheet. On the "Client A" worksheet the formula should read: =SUM('Client A'!$B8*Data!$C$3+'Client A'!$C8*Data!$C$4). I have several worksheet to apply this formula too. Thanks for your help! -- JULIE |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COPY SUM FORMULAS TO SEVERAL OTHER WORKSHEETS
Hi Julie,
you can use the formula : =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1))) to get the current worksheet name. Now i think it will make your life easier. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "JULIE H CPA" wrote: Hi. I need some help with copying a formula from one worksheet to another. In the client template worksheet it goes as follows: =SUM('Client Template'!$B8*Data!$C$3+'Client Template'!$C8*Data!$C$4) I need the 'Client Template' part of the formula (which is the name of the worksheet) to automatically change to be name of the worksheet I am copying it to. For example, I copy the formula from "client template" worksheet to "Client A" worksheet. On the "Client A" worksheet the formula should read: =SUM('Client A'!$B8*Data!$C$3+'Client A'!$C8*Data!$C$4). I have several worksheet to apply this formula too. Thanks for your help! -- JULIE |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COPY SUM FORMULAS TO SEVERAL OTHER WORKSHEETS
Do I insert that formula into my existing formula somewhere, or does it take
the place of my existing formula? It doesn't look anything like my current SUM formula, which works, except when copying it to another sheet. -- JULIE "Satti Charvak" wrote: Hi Julie, you can use the formula : =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A 1))-FIND("]",CELL("filename",A1))) to get the current worksheet name. Now i think it will make your life easier. -- Kind Regards, Satti Charvak Only an Excel Enthusiast "JULIE H CPA" wrote: Hi. I need some help with copying a formula from one worksheet to another. In the client template worksheet it goes as follows: =SUM('Client Template'!$B8*Data!$C$3+'Client Template'!$C8*Data!$C$4) I need the 'Client Template' part of the formula (which is the name of the worksheet) to automatically change to be name of the worksheet I am copying it to. For example, I copy the formula from "client template" worksheet to "Client A" worksheet. On the "Client A" worksheet the formula should read: =SUM('Client A'!$B8*Data!$C$3+'Client A'!$C8*Data!$C$4). I have several worksheet to apply this formula too. Thanks for your help! -- JULIE |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COPY SUM FORMULAS TO SEVERAL OTHER WORKSHEETS
JULIE H CPA wrote:
Hi. I need some help with copying a formula from one worksheet to another. In the client template worksheet it goes as follows: =SUM('Client Template'!$B8*Data!$C$3+'Client Template'!$C8*Data!$C$4) I need the 'Client Template' part of the formula (which is the name of the worksheet) to automatically change to be name of the worksheet I am copying it to. For example, I copy the formula from "client template" worksheet to "Client A" worksheet. On the "Client A" worksheet the formula should read: =SUM('Client A'!$B8*Data!$C$3+'Client A'!$C8*Data!$C$4). I have several worksheet to apply this formula too. Thanks for your help! Just remove - 'Client Template'! <- because it is referring to the current sheet. Then you can copy it to any other sheet as needed. Also, the SUM() is not necessary. Your formula should look like this: =$B8*Data!$C$3+$C8*Data!$C$4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) |