Hello,

I'm in a lurch... I need to link to side-by-side drop down menus. It
goes like this:

*First column’s cells have DD menu with a list of about 180 countries
*Second column’s cells have DD menu with a list of numbers (only two
numbers: 1&2).
*Certain NUMBERS in column two go with certain COUNTIRIES from the
first column (USA gets 1, France 2, Mexico 1, Germany 2 etc...)
*As it stands, the user must first choose the COUNTRY in column 1, and
then choose the corresponding NUMBER that goes this that country in
column two. (note: There two separate columns must remain)

***I want to make it so that when the COUNTRY is selected in column
one, the corresponding NUMBER automatically appears in column 2 *


Can anyone help? I've got a deadline fast approaching!!

Best regards,
Jeff


--
jd1655
------------------------------------------------------------------------
jd1655's Profile: http://www.excelforum.com/member.php...o&userid=28540
View this thread: http://www.excelforum.com/showthread...hreadid=482013