Hi Craig. Try this site. It looks like it will do what you need:
http://www.xldynamic.com/source/xld.Dropdowns.html
--
Sincerely, Michael Colvin


"Craig" wrote:

I have a very long employee list in column A with each individual listed by
country and would like to list the countries by region. I currently use the
AutoFilter command to select a country and then populate another column with
the region by dragging the information down. Is there a way to automate this
so if column A = Country1 then populate column b with Region1?

Example:

Column A Column B
United States North America
United States North America
Canada North America
Canada North America
Canada North America
Spain Europe
France Europe
China Asia
Chile Latin America

Thanks!

Craig