Newbie- Awesome site - sort items and insert line below and total

[Jody23]

Great site! Im retired and a bit rusty regarding excel

Need macro to insert a row and Auto sum the quantity "sold" of that particular item, then continue on to the next Items automatically.
I'm unsure of the terminology and where to begin.
Any help would be appreciated

Attached is the spreadsheet with the first two items completed...

Once again thank you!
Stay safe

 

[AlanSidman]

Use the Subtotal function on the Data Tab

 

[Jody23]

Alan

You rock!!!!!

Thanks so much!