+ Reply to Thread
Results 1 to 2 of 2

Working Schedule

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    7

    Working Schedule

    Evening Folks,

    I have a schedule that several people fill out called Days & Nights.
    Lately, folks have been filling out the wrong cells and I need to prevent it.
    I came up with a splash worksheet that the person can come in and select their name from a drop down and fill out the schedule thus insuring that they only fill out there schedule.
    I created a Temp worksheet to store data.
    I've been able to write to the cells across the splash and temp worksheets.
    I've been bale to copy that data to what will eventually be the final schedule.

    The problem I am having is the data keeps changing every time I change the value of the drop down menu.
    I fill out the data for the first individual... it writes it to all the appropriate places... when I change the drop down to another person all the data is overwritten.
    How do I prevent it from changing.

    Thanks
    Spart
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-28-2013
    Location
    United states
    MS-Off Ver
    Excel2007
    Posts
    11

    Re: Working Schedule

    This is what I tried, see if it will work for you.

    bsmill


    The revised file wouldn't upload. May have to try alternative method....
    Last edited by bsmill; 10-31-2013 at 06:31 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 07-15-2013, 07:13 PM
  2. Replies: 0
    Last Post: 06-14-2012, 12:09 PM
  3. Working Schedule
    By Tim Hobbs in forum Excel General
    Replies: 17
    Last Post: 04-26-2012, 08:36 PM
  4. Schedule updating formula stopped working
    By Bred0061 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-16-2008, 10:00 PM
  5. [SOLVED] Working Merchandiser Schedule...
    By MissUnPunctual in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2006, 08:25 AM

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