Hi dudes, i m wondering how the follow situations is solved using VBA.

Say,

A
A1 3lke
A2 het, her
A3 3kle
A4 8
A5 90

And i wanna get the result as follows:

A
A1 3lke
A3 3lke

A2 het,her

A4 8

A5 90

Meaning i wanna sort the rows according to the 2nd column, the sam
data are sorted together then leave a blank b4 a different data. Tak
note that alphabetical sequence is not important in this case.

To provide more info, there will be unknwon rows and i need to do thi
on several sheets.

Can anyone gimme some guidelines?

Thks and have a nice day ahead

--
Message posted from http://www.ExcelForum.com