Is it possible to sort columns horizontally?
i.e. you have 6 columns with 1,2,3,4,5 & 6 as a header number but they are not in sequential order.

Click Data Sort and then options, there is a sort left to right option.
Don't forget to select the whole area.

Brian

Spot on cheers.

Happy to help, especially as I didn't know till I looked, so I learnt something too. :D

Brian