Closed Thread
Results 1 to 2 of 2

Auto-populating master schedule via drop-down function

  1. #1
    Registered User
    Join Date
    04-05-2019
    Location
    Baltimore
    MS-Off Ver
    Windows 2010
    Posts
    6

    Auto-populating master schedule via drop-down function

    Colleagues,

    I would like Excel to auto-populate a master shift schedule.

    I have three office locations with three different shift schedules in worksheets named "1", "2" and "3". Another worksheet, named "master" would display shift schedules from worksheets 1, 2 or 3 based on location (the data is in cells A5 through H37). The idea is to enter location information in the master worksheet's drop-down menu ("1", "2" or "3"), which would then auto-populate schedule information from worksheets 1, 2 or 3.

    Likely, I will need to use a combination of Vlookup, Index, Match, plus set up the drop-down menu--but I am honestly feeling a little lost.

    Can anyone on this forum offer specific advice on how to best pull this off?

    Thanks in advance,
    Daniel
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Auto-populating master schedule via drop-down function

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-calendar.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto-populating master calendar
    By sturmstories in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-09-2019, 02:49 PM
  2. [SOLVED] Populating a summary schedule source changes as location is selected from drop down list
    By rydasm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2018, 12:00 AM
  3. Help populating master sports schedule.
    By lavudyar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-07-2015, 01:11 PM
  4. Creating & auto-populating rows in a master sheet from other sheets?
    By bludevil008 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-14-2015, 04:45 PM
  5. Help needed for Auto Populating from Employee Schedule
    By jmartin924 in forum Excel General
    Replies: 3
    Last Post: 01-25-2015, 07:27 PM
  6. Auto-populating shift schedule help
    By bobbylight in forum Excel General
    Replies: 0
    Last Post: 08-27-2012, 08:24 PM
  7. Auto Populating cells from a master spreadsheet
    By Steve K in forum Excel General
    Replies: 0
    Last Post: 07-01-2005, 12:05 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