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...

Group	Name	Number
G1	ASJ	2
	ATT
G2	AMM	4
	MKK
	TST
	ST2
G3	RT4	3
	YT4
	MK

<tbody>
</tbody>

And So forth....



Any ideas?

 

[shelim481]

Perfect Friend, thank you for your help, much appreciated

 

[Fluff]

My pleasure & thanks for the feedback