Let me describe my Excel workbook.
Sheet1 = a drop-down box to select a country.
Sheet2 = a list of countries with address and other details.
Sheet3 = A place to display the correctly formatted address and other details, selected by country on Sheet1.
Can someone guide me as to the magic I need to display the correct info on Sheet3?