Hi,
Look at the following which explains how to create dependent Data
Validation lists.

www.contextures.com/xlDataVal02.html

HTH

"AERIF" wrote:


I need help with this situation.
lets stay column A has drop down menu where I can select 5 countries,
depending on what country I select in A I want the corresponding cell
in column B to allow me to select only from a list of cities of the
country selected in A.

Thank you



--
AERIF
------------------------------------------------------------------------
AERIF's Profile: http://www.excelforum.com/member.php...o&userid=28395
View this thread: http://www.excelforum.com/showthread...hreadid=479867