View Single Post
 
Old 06-07-2012, 07:09 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Reply With Quote