See this link:

'Excel -- Data Validation -- Dependent Lists'
(http://www.contextures.com/xldataval02.html)


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109444