Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choosing Names From a List
I am working on a schedule. Our schedule changes often and I am trying to
simplify things. I have the schedule with Location A & B, Monday thru Sunday, AM and PM Shifts (total of 28 cells). I would like to click in a cell, have a pop up box (or something) show up and be able to choose names from a list of names and have their employee ID show in the selected cell. Usually there will be upto 7 names on a shift in one location at one time. I would like it to be displayed like "1234, 5678, 9012, 3456" I am using Excel 2003 and or 2007. Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choosing Names From a List
Consider using a Data Validation List to pick the name and, in another cell a
VLOOKUP() formula to fetch their ID. For Data Validaitons, see: http://www.contextures.com/xlDataVal01.html and for VLOOKUP, see: http://www.contextures.com/xlFunctions02.html -- Gary''s Student - gsnu200845 "ppidgursky" wrote: I am working on a schedule. Our schedule changes often and I am trying to simplify things. I have the schedule with Location A & B, Monday thru Sunday, AM and PM Shifts (total of 28 cells). I would like to click in a cell, have a pop up box (or something) show up and be able to choose names from a list of names and have their employee ID show in the selected cell. Usually there will be upto 7 names on a shift in one location at one time. I would like it to be displayed like "1234, 5678, 9012, 3456" I am using Excel 2003 and or 2007. Any help will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excell lists choosing quickly from the list | Excel Discussion (Misc queries) | |||
CHOOSING FROM OFFERED LIST OF FUNCTIONS-XL2007 | Excel Discussion (Misc queries) | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
How do I populate an entire row by choosing one cell from a list | Excel Discussion (Misc queries) | |||
Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions |