Automatically copying a row containing formula
 

Hi
I have developed a worksheet with lot of formulas in it. I want to provide
at lease 6000 Rows to update. If I write formula in every cell it consumes
memory.
Can I have a way to copy the formula on Next 10 row automatically when I
finish adding a record.
I also don't want user to press any button for macro. It should be done
automatically without users knowledge.

Can somebody suggest.....??