Results 1 to 11 of 11

Drop Down List For Schedule

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2013
    Location
    Hermiston, Oregon
    MS-Off Ver
    Office 365
    Posts
    14

    Drop Down List For Schedule

    I am an extreme novice with Excel (Other than basic functions).

    I am in the military and run Military Police section that I schedule 3 shifts (Days / Swings / Midnight).

    I have developed an Excel spreadsheet to keep track of the schedule. I am trying to create a drop down list to select the person who will be working the shift.

    The range of the row I am selecting is several columns long.

    I would like to add 70+ workers and be able to select the the row of the worker I am assigning to the shift.
    If you look at the spreadsheet this may make more sense.

    I have lost many nights sleep over this and any help would be appreciated.

    Thanks in advance for any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  2. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  3. Replies: 3
    Last Post: 04-16-2012, 10:14 PM
  4. Employee Excel Schedule Drop Down
    By Nigel1985 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-17-2008, 01:36 PM
  5. Replies: 5
    Last Post: 10-27-2005, 01:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1