Advanced Column Sorting in Excel 2003?

I should be able to write some VBA that will accomplish this if that will work for you. How many rows of data are we referring to and is this something that you do often?