Sort different columns separately, and create combo box to filter the data.

Hi All,

I have a workbook has a "Summary" worksheet. I would like to be able to do the following:

(1) Sort columns D, G, J, M,... (the number of columns are different each time I run the macro that I have).

(2) create a combo box to be able to the data (that sorted in 1) by month (1,2,..., 12).

Please see the attached file


Thanks in advance for your help.

Hi Oeldere,

Thanks for your reply.

The above sheet is created from another workbook using VBA code.

I would like to be able to sort the data as well as to be able to select specific month (the above two points).

Thanks again

Hi Oeldere,

The sort has to be for different columns in the worksheet (and I don't want to do it manually), and also the "Summary" worksheet is created using VBA and the number of columns are different (depending on the data that I used).

Thanks again for your reply.

Hi All,

Any help please.

Thanks