+ Reply to Thread
Results 1 to 2 of 2

Create Individual Schedule from Master Schedule

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    CT
    MS-Off Ver
    Excel 2007
    Posts
    4

    Create Individual Schedule from Master Schedule

    I'm trying to create a lookup that uses values from a list of names in one sheet (Sheet B).
    Example:
    Sheet B
    Person 1
    Person 2
    Person 3


    This would then search for that value within a master schedule table on another sheet (Sheet A). The value will appear multiple times in the table as it's a meeting schedule. It will return the name of the person they are meeting with and the time they are meeting with them.
    Example:
    Sheet A
    1PM 2PM 3PM
    Company A Person 1 Person 3 Person 2
    Company B Person 3 Person 2 Person 1
    Company C Person 2 Person 1 Person 3


    The Values would then be placed into their individual schedules on another sheet (Sheet C). It doesn't technically have to copy the time value as it is already in individual schedule template. It just has to match the time value in Sheet A with the time value in Sheet C.
    Example:
    Sheet C
    Schedule for Person 1
    1PM Company A
    2PM Company C
    3PM Company B


    Schedule for Person 2
    1PM Company C
    2PM Company B
    3PM Company A


    Schedule for Person 3
    1PM Company B
    2PM Company A
    3PM Company C


    It would then print this sheet, then clear the contents of this sheet and then repeat the process until all values in Sheet B have been looked up and filled into their schedules.

    Thank you all so much for any help you can give me with this!

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Create Individual Schedule from Master Schedule

    Hi kscheller

    You will increase you chance of a positive response by about 1000% is you include a sample workbook with your request showing just enough of the input data AND critically, your expected results to make your end result very clear.

    You should also include any code you have already been building so we can see exactly where to concentrate any help

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

+ 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. Master Schedule separated into individual tabs, totally minutes
    By JLYGirl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2013, 06:32 PM
  2. Updating a Schedule based on a master schedule
    By Lukerich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2013, 12:18 PM
  3. create daily schedule using master task schedule
    By DCO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 01:08 PM
  4. Master schedule to individual schedule
    By barrec in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2011, 01:24 PM
  5. Replies: 8
    Last Post: 10-12-2005, 12:05 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