Adding Multiple Rows w/ Formulas (x800)

[eversio11]

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

[Chef BurnsALot]

Your file is attached. Is this what you were wanting? You will notice that since you had some N/A values on your July 1, Aug 1, and Sept 1 sheets, these errors got transferred over to the Monthly Sales sheet. You also have some numbers missing. For example, you have a 01-000032 on your Monthly Sales sheet (row 120), but on the July 1 sheet that number is not there.

[eversio11]

Your file is attached. Is this what you were wanting? You will notice that since you had some N/A values on your July 1, Aug 1, and Sept 1 sheets, these errors got transferred over to the Monthly Sales sheet. You also have some numbers missing. For example, you have a 01-000032 on your Monthly Sales sheet (row 120), but on the July 1 sheet that number is not there.

Wow, Chef BurnsALot, I don't know how to convey my appreciation for your help! Besides cleaning up a few of those N/A values it looks absolutely perfect, thank you! You must tell me how you managed to complete such a herculean task.