VBA for Insert Rows based off Matching Values

Hi! I am attaching a file to help better explain -

I have a sheet that I am trying to figure out - After I run a quick macro to clean up the data, I am left with all of these values that I need to go thru and sum for a report

First, I need to insert cells based off 2 columns matching so I have an IF Statement ( I have this done on the sheet in col Q), the IF Statement produces the word "DELETE" when False which tells you when to insert a row below. If Col G2 matches Col G3 and if D2 matches D3 then keep going, if not then insert row below delete (since the code and desc are no longer the same). I will prob eventually try to convert that IF statment to insert via VBA

Next after rows are inserted, I need to sum all values from Col F but only for those that are within the groups based off the inserted rows (seen on Sheet2)

You will see on Sheet 1 how this looks "raw" and on Sheet 2 you will see how I inserted rows/summed

Any help would be greatly appreciated
EXample Book.xlsx

Hi! Sorry, could you provide a little detail and explanation to help me understand what is going on specificlly.

I see the match for Col D but also needs to match Col G

My apologies, my vba is a little weak.

With this macro you don't need the formulas in column Q or the data in column R.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.