If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > help on advanced filtering

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-19-08, 17:18
Chanyeehon Chanyeehon is offline
Registered User
 
Join Date: Oct 2006
Posts: 39
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
Reply With Quote
  #2 (permalink)  
Old 11-19-08, 18:26
Chanyeehon Chanyeehon is offline
Registered User
 
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 22:29.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On