VBA to subtotal by test and highlight the subtotal row with light gray

good morning,

I have an excel worksheet which is link to a simple access database. I would like to be able to subtotal by agent name (column A) using Total Shipped Price (Column L) and then highlight each subtotal row with light gray. Here is the twist, Each month I will open this worksheet and hit refresh button to bring in new agent names and amount. I need the worksheet continue to sub total using an agent name and Total shipped Price.

I have attach an example and the first tab is the raw data (download from link query) and the second tab is what worksheet should look like after the agent name is group and total.

I will have split this data from the master into four tabs within this worksheets AOEC, AOCC, AOWC (colunm N)

My customer does not want me to use the tool outline and group command (the side bars confuse them). The second tab is what is sent to my customer.

Thank you

That is most coolest macro You just save me hours of work with a push of a button. Thank you so much.

I have one more request: Is it possible to have add all of the subtotal amounts or a total of individual lines (which every is easiest for you) under the column called "Total Shipped Price" (Column L) for worksheets master, AOEC, AOCC, AOWC? See attachment for example.

I would love to be able to use excel to the full capability. It work on the master worksheet but not the other worksheets called AOEC, AOCC and AOWC.

I understand now, thank you and have a great day