Insert 2 blank rows and sum columns based on cell value change

Hi,
Need to insert 2 blank rows and sum columns (Columns B & D; range varies) based on cell value change (Column A).
Regards,
Pete

Hi Pete
You give no indication how or when or where you need to

insert 2 blank rows

However, if you use this formula in Cell B5 (see sheet2)

Please Login or Register  to view this content.

or this formula in cell B5 (see Sheet3)

Please Login or Register  to view this content.

you can insert lines in your sub categories and the totals will self adjust.
Hope this helps. John