VBA Macro to read worksheet and output 10% each category in one column

[david_hu_66]

Hi All,

I need VBA Macro to read worksheet and output 10% each category from one column.

Data like this
Name IDs
A 1
A 22
A 33
A 444
A 555
A 666
A 777
A 888
A 999
A 1000
A 1111
A 1222
A 2222
B

11
B 222​

B

333​

B

4444​

B

5555​

B

6666​

B

7777​

B

8888​

B

9999​

B

10001​

B

11111​

B

12221​

B

22221
B 33333
C 111111
C 222222

so summary will be
A 13 roundup(10%*13)=2
B 14 roundup(10%*14)=2
C 2 roundup(10%2)=1
​

so output to another worksheet will be like this
Name IDs

A 1
A 22
B 11
B 222
C 111111
C 222222​

Thank you!

David