template

[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

 

[Jay]

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?

One way: in the template, use "Paste Special" instead of "Paste".

Paste Special has a "Skip Blanks" check box that should leave your formula
in column B undisturbed.

If the "data" worksheet has formulas in it, you might also want to choose
"Values" in the Paste Special dialog box.