Take a look at David McRitchie's INSRTRow macro:


http://www.mvps.org/dmcritchie/excel/insrtrow.htm


In article ,
"Sharon Perez" wrote:

How would someone copy the last row of data on a sheet, go
down one row, paste only the formulas, then go to the
original row and paste the values. The original row would
have the same values but no formulas and the next row
would then have the formulas. This needs to be dynamic
because the rows would increase by one row daily and the
reference would change each day. Thanks!