template

  • Thread starter Thread starter Kyle
  • Start date Start date
K

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
 
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?
Click to expand...

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.
 
Back
Top