Insert multiple rows in specific sections of sheet?

Hello,

I'm very new to VBA, so this may be a pretty easy question...

I need to write a macro that can insert a row, and copy down all formulas from the above row, between a specific range of rows. I'm attempting to do this in multiple ranges of rows on the sheet- This is for an estimating sheet that has 50 sections. The idea is to allow other users (not very skilled with Excel) to easily insert rows and be sure that the formulas are being copied down.

I recorded a macro that seemed to work, but if too many rows are inserted in a given section, in the subsequent sections, the row recorded to be inserted can get shifted out of that particular section...

Let me know if this is confusing- I'll try to clarify!

Thanks...

perhaps you need to post your code

it could be an absolute/relative reference problem

does it do the first insertion correctly and then subsequent ones incorrectly?

your macro could search for the section heading and inserts a new row directly below it, thus keeping the newest data at the top of the list. (or put it at the end of the section)