Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Drop Down List if cell meets criteria
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Drop Down List if cell meets criteria
Hi,
yes it's possible with dependent lists see Debra examples http://www.contextures.com/xlDataVal02.html if this helps please click yes thanks "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Drop Down List if cell meets criteria
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation Drop Down List if cell meets criteria
Hi,
Thanks for all your help. I decided to go with the Val 13. It took a while but finally got it. I do have one more question. Can there be another validation off of employee (meaning dept breaks down to employee, employee breaks down to the task at hand and then the task breaks down to a specific task - example accounting, Mary, receivables, posting cash)? Not sure if I picked the correct html. Any suggestions. Thanks again, very much appreciated. -- clueless "Jacob Skaria" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - In cell drop Down List | Excel Discussion (Misc queries) | |||
Adding data in a list that meets a specific criteria | Excel Worksheet Functions | |||
Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) | |||
Retrieving an Item from a List that Meets Multiple Criteria | Excel Worksheet Functions | |||
Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) |