Check out the below articles by Debra..

http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal15.html

If this post helps click Yes
---------------
Jacob Skaria


"clueless" wrote:

Hi,
Need some help. In my spreadsheet, Column B has a dropdown list of depts.
Need to know if there is a way of making Column C show only a dropdown list
of employees in that department. For example, if the dept chosen in Column B
is management, Mary, Joe & Paul would only show on the dropdown menu in
column C. But if the dept was human resources in Column B, Kathy, Mark &
Mike would show on the dropdown menu in column C (not Mary, Joe & Paul). Is
this possible? Thanks in advance for your help!
--
clueless