Data Validation question
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 |
Data Validation question
Hi
Take a look at http://www.contextures.com/xlDataVal02.html http://www.contextures.com/xlDataVal15.html -- Regards Roger Govier "Lost" wrote in message ... 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 |
All times are GMT +1. The time now is 12:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com