+ Reply to Thread
Results 1 to 3 of 3

Filtering

  1. #1
    Registered User
    Join Date
    10-23-2011
    Location
    Panama
    MS-Off Ver
    Excel 2010
    Posts
    1

    Filtering

    Hi,

    Im working on a sim project that includes scheduling for a 24/7 company. In order to track the persons that are suppose to come to work on each shift i decided to make a calendar type of sheet so i can see forecast for the month

    I made 3 sheets one for morning, afternoon and night shifts and added manually the persons that needed to come each day.

    Now, i was wondering if its possible maybe to have a single drop down menu with "Shift" on it and have it display the persons per shift once i select from the list?

    Is this kind of filter even possible on excel?

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    08-01-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    182

    Re: Filtering

    Hi,

    Welcome to the forum. To best illustrate your problem, it will be great if you can attach a workbook with some dummy data. In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button.
    One must rise above the Clouds to see the Blue Sky rather than constantly trying to push them aside

    If you want to say Thank you to a member, click the little star * below.

    If your Problem is Solved, please mark the Thread as Solved

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Filtering

    Yes, its possible. Why don't you attach a sample workbook and we can help you out?

+ 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