+ Reply to Thread
Results 1 to 2 of 2

How to populate a second worksheet based on multiple criteria from another worksheet

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    STL, MO
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to populate a second worksheet based on multiple criteria from another worksheet

    Here's my dilema. I've attached a scheduler program we're working on in a simplified format.

    Sheet 1 "Scheduler" is the comprehensive scheduling tool. I would like to be able to popluate sheet 2 "Schedule" based on input criteria of a specific date or preferrable a range of dates that will buildout the schedule for that day/week etc in a more usable format for the supervisors to know who is supposed to be at work and on what shift/function.

    I've manually created what I want sheet 2 to look like but haven't a clue where to start parsing the data on sheet 1.

    Bruce
    Attached Files Attached Files

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: How to populate a second worksheet based on multiple criteria from another worksheet

    See attached wb.

    In cell G3 on the Schedule ws is a data validation dropdown. It uses ws Scheduler Range B4 to H4 to add the dates to dropdown.
    Very Important that Schedule headers are spelled the same as you use them on the Scheduler ws. I noticed that header Teir 2 LPO is misspelled and on the Scheduler ws its spelled Tier 2 LPO.
    Attached Files Attached Files
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

+ Reply to Thread

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