Macro code to count number of unique rows in a sheet.

Hi Forum,

I was trying to design a macro which should count the unique rows in the sheet and should display them accordingly. (Possibly in second sheet).

I'll just give a quick example for this scenario

Sheet 1:

String	Age
str1	5
str1	5
str1	3
str1	3
str1	3
str2	5

When I run a macro now I should get the results as follows in sheet 2:

Sheet 2:

String	Age	Count
str1	5	2
str1	3	3
str2	5	1

Can anyone help me in designing macro for this. Thanks for your help.

Thanks for the prompt reply Sir. The thing is I am a newbie to the VBA and pivot. Can you please explain the steps so that I can follow it accordingly.

Thanks Sir.