grouping inside a macro
 

dear everyone,
I have 3 columns say
colA colB Col C
row1 1 A pen
row2 2 B sit
row3 1 A read

now i want my output to be like

colA colB Col C
row1 1 A pen
row2 read
row3 2 B sit

that is i want to group all the As in the column B and allow it to display
only once for howmany ever rows we have in col C.
The main thing is that these rows get filled from another sheet. therefore
they are dynamic, i may have any number of rows in this sheet.
I want to do this kind of grouping inside a macro. kindly help

grouping inside a macro
 

Why not just sort it?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"deepika :excel help" wrote in
message ...
dear everyone,
I have 3 columns say
colA colB Col C
row1 1 A pen
row2 2 B sit
row3 1 A read

now i want my output to be like

colA colB Col C
row1 1 A pen
row2 read
row3 2 B sit

that is i want to group all the As in the column B and allow it to display
only once for howmany ever rows we have in col C.
The main thing is that these rows get filled from another sheet. therefore
they are dynamic, i may have any number of rows in this sheet.
I want to do this kind of grouping inside a macro. kindly help