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