grouping inside a macro

[deepika :excel help]

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

 

[Bob Phillips]

Why not just sort it?

--
---
HTH

Bob


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