|I'm not sure what you mean by "what i require is to auto sort that block of data, column '18','9','6','3','2','1',"|
In Excel, columns are usually designated by letters, rows are usually designated by numbers.
"i then need to be able to move to the next block of data..."
What block of data?
I think you need to post an example of the data in your workbook and the desired result based on that data. Please click on the following line and read the instructions found via that link before posting your data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.