Thread: sorting problem
View Single Post
  #1   Report Post  
Colargol
 
Posts: n/a
Default sorting problem

Hi!

I have problems generating a rutine that will automatically sort my
sheet.
The sheet is in this format (always 2 columns only the rows may vary)

a 1
a 2
a 3
b 2
b 1
c 7
d 1
d 3
d 4
d 6
d 7
e 7


I want it to look like this:

a b c d e
1 2 7 1 7
2 1 3
3 4
6
7

Anyone know what vba code to use to get this done?

/Colargol