VB Script Code needed for Grouping Rows
 

Hi,

I have an excel worksheet in which i need to group rows based on
column 1. For E.g.

Col1 Col2 Col3
Row1: ABC XY IJ
Row2: ABC TT RR
Row3: ABC GG ER


I need to group Rows 1,2& 3 having same col 1 value i.e. ABC.

I am aware of Group & Outline property available in excel, but i need
to implement the same using a macro.

Can you please help

Thanks.