Good day everyone,I am just starting my Excel VBA code practice. Here is one practice that I'd like to achieve. But, I just couldn't sort it out.
There are Column A "Name", column B "Point", and column C "ID" in the spreadsheet. There are several different names randomly listed under the A, and some of them are repeated. Here is what I've been trying to do.

For A
1. Sort all the name alphabeticly;
2. If the name only shows once, to insert a row right below of it.
3. If the names show more than once, to insert two rows right after them, and then type in "(Names) Total" into the first inserted row.

For B
Add all the points together which corresponded to that name when A.3 criteria happens, and shows the total point value right after them.

For C
To count how many "ID"s (on the other word, try to count how many times that specific name showed up)which corresponded to that name when A.3 criteria happens, and then have the total number right after them.


Note: based on the above state, the "(Names) Total" in A, total point in B, and total times should all in the same row.


Please let me know if there are more information needed.

Thank you in advance


Live long and prosper. \V/