VBA Code to Count & print Dulplicates from One Excel to Other

[parth007]

Scenario - VBA Code to Count & print Dulplicates from One Excel to Other

Input Number
A 1
A 2
A 3
B 1
B 2
C 1
C 2
D 1


Below Output Should be copied to other excel workbook


A B C D
3 2 2 1

Please provide a VBA code.. i am Newbie

[parth007]

Anyone have got the code