ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Choose from list to fill in a cell (https://www.excelbanter.com/excel-worksheet-functions/220976-choose-list-fill-cell.html)

ppidgursky

Choose from list to fill in 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.


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com