template formatting

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