Adding Multiple Rows w/ Formulas (x800)

Hello,

This forum looks like a great resource, and if it isn't too much trouble for it's members to take a look at my problem I would be much indebted for their help. It's not really a problem, just a time saving technique that I'm not sure how to employ.

Attached is a workbook I have been working on. I needed to calculate some formulas for Turnover values based on Monthly Sales and Average Inventory Quantities. If you look on Sheet 1 (Monthly Sales) you'll see I've completed the first 6 entries, and everything after that (starting with Item 01-000008) is still in the format of how I received the information. Basically it only has the Monthly Sales (Price and Quantity Sold in Column C).

So as you can probably tell, my dilemma is how to most efficiently fill in the formulas and rows for the rest of the ~800 items. I simply filled in the first 6 entries manually by inserting rows and copying the formulas, but completing 800 more would require more time than I would like to spend on this task. If some experienced Excel user has a technique to share, I would very much appreciate the effort.

Thanks in advance.

- Mark