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