Welcome to the forum.
To use Excel's built-in sort feature, you'll need to create an extra column on your first table and then use VLOOKUP (or other similar function) to pull in the country from the second table. Then you can sort by that column.
If you do not want to use an extra column then I think you would have to write some VBA code to sort the data for you.
|