I have a spreadsheet with different information for several countries.

I'd like to create a dropdown of all the countries, so when a country is
selected only that inforamtion appears.

I do not know if this is possible, or how to go about doing it, but anything
information would be extremly helpful.

Thanks

I'm using Excel Vista