+ Reply to Thread
Results 1 to 4 of 4

Show employee data from another sheet for current month

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    Nunavut, Canada
    MS-Off Ver
    Excel 2013
    Posts
    41

    Show employee data from another sheet for current month

    Hi,

    I have a work schedule and I want to show everyone coming in and out for the month.

    On sheet 'fly days' it shows employee name, site, # of days, in/out bound fly days and start of rotation. I want to have the in/out bound and site shown for each employee on sheet 'month view' in order by date. I need some direction on how to do this.

    I've attached a sample of the workbook. 2015 Schedule Template.xlsx

    Thanks in advance,
    Last edited by earthandbody; 07-09-2015 at 02:41 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,709

    Re: Show employee data from another sheet for current month

    Why there is 2 displays in sheet "Month View" ?
    Have you had a look on the use of the Pivot Table?
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    03-29-2014
    Location
    Nunavut, Canada
    MS-Off Ver
    Excel 2013
    Posts
    41

    Re: Show employee data from another sheet for current month

    There's two because one is for inbound and the other outbound.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,709

    Re: Show employee data from another sheet for current month

    See file attached with Pivot Table and comment
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Show employee data from another sheet for current month
    By earthandbody in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2015, 08:09 AM
  2. [SOLVED] Macro to cut and paste current month sheet into the relevant month chosen by a drop down
    By scotty22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2015, 09:07 AM
  3. userform combobox to show current month
    By losmi8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2014, 04:45 AM
  4. Show Current Month
    By howardjo in forum Excel General
    Replies: 2
    Last Post: 02-27-2008, 05:45 AM
  5. Show week number in current month
    By DKerr in forum Excel General
    Replies: 4
    Last Post: 02-23-2006, 05:25 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