Column Sorting macro

[msb15]

Hello,

I'm trying to sort out some data using Auto Filter from Sheet1 to Sheet2 by a macro. The problem is that it's only sorting in Alphabetical order. Like in the code, I have hidden all columns and its showing data of A,B,C. I want the data columns from Sheet1 in order A,K,M,N,O,I,F,AF,B,C and Y.

Please help. Here is the code:

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[msb15]

Thanks man.. Worked like a charm.

[AlphaFrog]

You're welcome. Thanks for the feedback.