template formatting

[Kyle]

Is there a way to have a formula programmed into a
template and then copy data onto the template to get an
output? For example:

((C8*D8)/$A$7)+C8*E8

is programmed into the template and then dragged down the
columns (output is in column B). Could I then copy data
from another worksheet (columns A-H; column B is empty)
onto the template and keep the desired template formula,
thus getting the calculations in column B?

Thanks

 

[Dave Peterson]

You could either do two copy|pastes (avoiding column B in both cases)

or

do one copy|paste and reapply the formula in column B.