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
|