LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
in excell lists choosing quickly from the list shubb1 Excel Discussion (Misc queries) 1 November 6th 08 10:27 AM
CHOOSING FROM OFFERED LIST OF FUNCTIONS-XL2007 FARAZ QURESHI Excel Discussion (Misc queries) 3 July 19th 08 06:51 AM
Choosing multiple items in a drop down list Shad Excel Discussion (Misc queries) 9 July 7th 08 06:38 PM
How do I populate an entire row by choosing one cell from a list jumpmaster_france Excel Discussion (Misc queries) 2 August 27th 06 01:45 AM
Auto Fill Cells, When Choosing From Drop-Down List... doc1975 Excel Worksheet Functions 1 January 11th 06 02:36 AM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"