Data Validation question

L

Lost

ok i have a list of people from 1st, 2nd and 3rd shifts. I have a drop down
box to select the shift(A2), and a drop down to select names(B2). One
workbook per shift. Is it possible that if i select 1st shift(in A2) that ill
get the list of names( in B2) that matches 1st shift and the select 3rd(in
A2) and get the list of 3rd shift names(in B2)?

1st - marry, bob, jim
2nd - juile, brayn, kim
3rd - jason, eddy, jerey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting formula help needed! 2
automate data entry on Excel? 1
Restrict choices in one drop down list by response to another 4
populate time field based on field 8
Indirect function and data validation dropdown box 2
stumped on creating dependent data validation lists 1
Help with drop down selection and populating related data... 9
Data Validation and drop-down list using IF, AND and what else? 8

Top