VB Script Code needed for Grouping Rows

A

Abhi_Rise

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting blank rows 5
grouping inside a macro 1
Match based on a lookup and then flag 4
Duplicates are GOOD: How to find the most duplicated values? 1
Good at Macros? I'm Trying to find duplicate entries. 3
Conditional Formatting HELP 2
Copy, Transpose and Paste Values for a Large Data Set 0
Replace all non blanks in a column with column header 3

Top