View Single Post
 
Old 05-15-2020, 09:20 AM
mthwi mthwi is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2017
Posts: 5
mthwi is on a distinguished road
Default Sort Excel table using a list.

I have a long list that I want to use to sort my excel sheet.

I know that Excel has a solution for this onboard but my list and the table is 350 terms long and I cannot create a custom sort in this size. Excel does not allow this.
If anyone knows how to do this with such a large list, I'd be happy to help.

I'm looking for a VBA that I can use to sort the table.

In the example table in the link is a list in column A of the spreadsheet T1.
The table in T2 (also column A) should be re-sorted using this list.

This table is an extract. The original is longer.

I am happy about a code that can help me.

Thank you very much.

Example
Reply With Quote