DataFilterAutofilter will do that for you.


Gord Dibben MS Excel MVP

On Fri, 21 Aug 2009 00:47:01 -0700, kat21
wrote:

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