Dynamic Multiple Sorting with Criteria

[Mike2]

Hello,

Can someone please help to suggest how to do dynamic multiple sorting with criteria in VBA?

I have a data table with header title : LOCATION, ITEM#, CATEGORY in different columns that i would like to sort the table in the following column sequence.

1st sort : LOCATION
2nd sort: CATEGORY
3rd sort : ITEM#

The Header Title is dynamically in different column on each report when the data table was extracted from the database.

Thank you for your help in advance.

 

[Akuini]

Hi, Mike2
Why are you create 2 threads with the same question?
https://www.mrexcel.com/forum/excel-questions/1084320-sorting-criteria.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).