| 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 |
| 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) | |||
Threaded Mode
