Transfer data into new worksheet as summary with Sums and counts

Hi..

I know what I want to do just don't know how. I can do something similar to what I want in a pivot table but I'd rather have code to do it.

Basically in column N I have different UserIDs.
In Column D I have "Match Codes" which repeat going down.

I want to automatically open a new workbook and place the data in with new format.

I want to do.. For each User in column N

Summarise the match codes to give a quantity for each one.
Summarie column G to give a total amount for each match code
with addional total

And i want it once its done one user to do the next user below.


I have attached my sample data with a sample result for the first user of how I'd like it to display.

If anybody who is good at this sort of thing could help I'd really appreciate it
Kaz

Thats done the job! Thanks for your time