VBA Count and paste value

[shelim481]

Hi im trying to find out how to count the numbers in each group, using macro instead of formula, the group go on for as many as needed, i want it so that it does number part for me...once i have filed out group and name...



[TABLE="width: 500"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Name[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]G1[/TD]
[TD]ASJ[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ATT[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G2[/TD]
[TD]AMM[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MKK[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]TST[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ST2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G3[/TD]
[TD]RT4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]YT4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MK[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And So forth....



Any ideas?

 

[shelim481]

Perfect Friend, thank you for your help, much appreciated

 

[Fluff]

My pleasure & thanks for the feedback