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