I tried really hard to find this myself, but failed.

I have a worksheet containing 5 separate blocks of data (own headings,
column titles, etc); some of the cells contain formula.

I want a macro that wll insert a row when a block is filled ( in column "H"
actually), copying the formula as well. This needs to work on all the blocks
when the same condition is met.

Can anyone help me?

Many thanks
David