Subtotal only group duplicates if value in column

Y'all, I'm stumped. I am trying to format daily bank activity and I can't figure out how to do this last part. I have the data sorted the way I want, but now I need to get insert two rows under every change of value in column G where if there are duplicate values and then sum column D (debits) in one of new rows enter image description hereonly if there is a value in it. Then I need to do the same thing for column E (credits). For any unique values in column G, I just need to insert a line. I do this on a daily basis, so the solution needs to be for a macro. The format must match what the results picture looks like. Can someone please point me in the right direction?

Try the attached.

Please Login or Register  to view this content.

Holy cow! This worked! Thank you so much, you are incredible!

Thank you Jindon for putting this macro together in the spreadsheet and including a button. That was a nice touch. Unfortunately, when I ran it the unique values were also summed. I do have another project that this will work for though. Thank you again!

OOps, of course...
typo

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.