Re: $$Excel-Macros$$ Sorting a list; adding blanks when either side is not present

2011-02-02 Thread Natron
Wow, I like this VBA example quite a bit, the problem I provided was indeed simplistic and would need to be modified for my intended need. I'm fairly new at VBA and very much appreciate your skill and knowledge. I was wondering if an array was the way to go! Thank you Again! On Feb 2, 3:51 am, s

Re: $$Excel-Macros$$ Sorting a list; adding blanks when either side is not present

2011-02-02 Thread Natron
Very easy to understand, and just what I needed. Thank you very much for your time and knowledge! On Feb 2, 12:40 am, ashish koul wrote: > see if this helps > > Sub sort1() > > Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort > key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:

Re: $$Excel-Macros$$ Sorting a list; adding blanks when either side is not present

2011-02-01 Thread ashish koul
see if this helps Sub sort1() Sheets(1).Range("a1:a" & Range("a1").End(xlDown).Row).Sort key1:=Sheets(1).Range("a:a"), order1:=xlAscending, Header:=xlYes Sheets(1).Range("b1:b" & Range("b1").End(xlDown).Row).Sort key1:=Sheets(1).Range("b:b"), order1:=xlAscending, Header:=xlYes Dim i As Long For i

$$Excel-Macros$$ Sorting a list; adding blanks when either side is not present

2011-01-31 Thread Nathan
Hello all, I'm hoping you will have time to assist me understanding how to best tackle this comparison list shown at the following link. https://docs.google.com/leaf?id=0B7Wrlvw2fV31ODliYzkwMWYtMzRhMi00OGU4LTliZTQtMzUxZDQ5OWQ2OGUy&hl=en&authkey=CJutsIkC I'm given a range similar to ("A1:B5") an