Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    39

    Unanswered: help on advanced filtering

    I need some help and advice to start using advanced flirting on a schedule

    I have worked out the questions i want to query/filter about:

    List everyone who is working at that time range on a certain day
    For instance:
    Employee / Day /Time
    Chanyeehon/ Tuesday / 9am to 3pm
    List everyone that can work on Monday that can work between 9 to 5


    -I have 22 employee first names
    -Each employee works 1 to 2 days each week
    -the time range


    Should i use a start time column and an end date column?
    What kind of format should i use?? i.e Employee / Day? / Time...
    But each employee works at least 2 shift a week
    should i use one sheet per day?
    or is it just possible to just one sheet for all days and time


    Please help

    Thanks in advance

  2. #2
    Join Date
    Oct 2006
    Posts
    39
    I got it to work


    But i want to ask how do I select more than one range from another worksheet?
    what do i type between the ranges?
    Last edited by Chanyeehon; 11-19-08 at 23:29.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •