| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choose from list to fill a cell
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" Any help will be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Choose from list to fill a cell
You need a data validation pull-down:
http://www.contextures.com/xlDataVal01.html -- Gary''s Student - gsnu200833 "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" Any help will be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Choose items from a list and add to a string in a cell | Excel Discussion (Misc queries) | |||
| Choose from a list | Excel Worksheet Functions | |||
| Fill a cell by selecting a value from a list | Excel Worksheet Functions | |||
| How can I get more colors to choose from for Fill? Use Excel2003 | Excel Discussion (Misc queries) | |||
| can excel choose a name from a list when I am typing in a cell | Excel Worksheet Functions | |||
Linear Mode
