Results 1 to 1 of 1

Populate Schedule From Shift Selection

Threaded View

mesodumb Populate Schedule From Shift... 08-01-2012, 02:59 PM
  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Populate Schedule From Shift Selection

    I have a schedule to be filled out per technician. In one column (E a shift is identified with a drop down list. I would like for it to auto-populate (H31:AI144) the shift days and times from a template (H148:AI167) once the shift is selected. The cells are currently set to only allow 1 hour increment times with Data Validation. Once the times and days are auto-populated, I still need the user to have the ability to edit each time using a drop down list. Any suggestions? I have attached an example.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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