Ascending and descending multiple columns with macro

Several possibilities here since you didn't provide a sample sheet to show us what hurdles there are to overcome.

1) IF the AAA and GGG and PPP columns only exist once and you want to sort both tables based on what you've found prior, just expand the range to include the whole range including the columns in between:

Please Login or Register  to view this content.

2) It the ranges represent different tables with duplicate AAA and GGG and PPP that must be found, then you'll have to run the macro for each range:

Please Login or Register  to view this content.

Please explain the lines of code where you are searching for the columns with "aaa" and "ppp" and "ggg" in them. They have no relevance in the workbook you posted.

The second macro I posted should work if you search for the correct strings and adjust the second range from L:Q to J:O since your uploaded workbook has the second table there.

Originally Posted by JBeaucaire

Please explain the lines of code where you are searching for the columns with "aaa" and "ppp" and "ggg" in them. They have no relevance in the workbook you posted.

What dummy data are you saying to ignore? I see nothing to ignore. And you didn't answer my question above. Your original macro refers to generic strings that don't exist in the uploaded workbook. What should the actual search strings be?

I couldn't get that second table to sort either, no idea why. But there's no reason to complicate the macro. A simple "custom range sort" does the job nicely and is easy to edit if you ever change the layout of your tables.

Please Login or Register  to view this content.