see Insert a Row using a Macro to maintain formula
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

You will have to modify your formulas to use OFFSET
as described.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"belvy123"
I need to create a macro to add 10 rows to my sheet at the end of the rows
where I enter my production data., I need this to carry my function into
these new rows as well.
Any ideas would be greatly appreciated