How do I copy only cells with formulas in another row?

[Guest]

I have a table with multiple formulas on each row. I need to be able to copy
on the formulas when I insert a new row. I've tried the paste special
formulas and that copied the whole row, data included. I only want the
formulas to be copied.

Any suggestions...?

 

[PCLIVE]

Soozy,

After copying and pasting the cells, press F9 to calculate. My guess is
that calculation for this workbook is set to Manual. You can set to
automatic by going to Tools->Options->Calculation.
The sheet just needs to be recalculated. However, if your formulas are
using constant cell references, then the formulas will not adjust when
copying to another location. Constant cell references in a formula would
be, as an example: =$A$1+$A$2
Dollar signs will keep the column and or row reference the same when copying
the cell to another location.

HTH,
Paul

 

[Yakman]

Create a macro, to insert a new line then copy the required formula down a
row.