Copy (Formulas and Formatting ONLY) no values to other rows
 

I have a workbook (tracker) that adds new records from a workbook called
(data). When I add a new record from data to tracker, I want to copy the
formulas and formatting from the row above the empty row in tracker and paste
them into the empty row. Then when the data is copied over it uses the
formulas and formatting as above. I do not want to have these formulas copied
into every row on tracker until there is a need for them. Every time I write
a vb script to copy and special paste formula only to the new row it copies
cells that just have values as well. Can anyone show me code that will copy a
rows formatting and formulas only to a row below it? Thanks!

Copy (Formulas and Formatting ONLY) no values to other rows
 

can anyone help me?

"Kenny" wrote:

I have a workbook (tracker) that adds new records from a workbook called
(data). When I add a new record from data to tracker, I want to copy the
formulas and formatting from the row above the empty row in tracker and paste
them into the empty row. Then when the data is copied over it uses the
formulas and formatting as above. I do not want to have these formulas copied
into every row on tracker until there is a need for them. Every time I write
a vb script to copy and special paste formula only to the new row it copies
cells that just have values as well. Can anyone show me code that will copy a
rows formatting and formulas only to a row below it? Thanks!