View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
 
Posts: 70
Default How to sort number follow cell accordingly

Hi, everyone!
I need to create macro that can sort numbers as below:
Column : Before
A B C D E F
1 2 3 4 5 6
3 4 5
1 3 4 5
3 5 6
After
A B C D E F
1 2 3 4 5 6
3 4 5
1 3 4 5
3 5 6
which mean same number follow the same column but not necessary follow
column A,B,C.....
Pls help with vba code.Thanks