Insert new row and add Title for new row

[ETracker]

I am looking for some code that will insert a new row in a spreadsheet that has been subtotaled. I need to be able insert a new row after the subtotal which looks like 10 Total, 12 Total, DM Total and so on. After inserting this row I need to add a Title in Column A. I will be using a Vlookup for the correct title based on the subtotal heading. I just don't know how to locate where to insert the lines and how to get to column A to insert the title.

The subtotal will always be in column Q.

ETracker

[mdmackillop]

Are you looking to do this as each total is inserted, or to the "finished" sheet.

[ETracker]

Yes, I think it would be best to insert the new row and the title at each sub total as it is being inserted, but if it would be better to perform the insert first and them go back and add the titles that would be OK.

E-Tracker

[mdmackillop]

Ok. Can you post a sample layout?

[ETracker]

Attached is a before and after copy of the data sheet. The first tab is before and the second tab is the results after inserting the row and title.

Thanks for you help.

ETracker

[ETracker]

Any more comments as to how to insert row and title on the inserted row.

ETracker:dunno