+ Reply to Thread
Results 1 to 3 of 3

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.

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Show employee data from another sheet for current month

    Applicable formulas are, for Inbound fly day (columns A:C)

    A
    B
    C
    3 =IF($C4="N/A","N/A",INDEX('Fly Days'!$A$2:$A$1000,MATCH($C4,INDEX('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000,0),0))) =IF($C4="N/A","N/A",INDEX('Fly Days'!$C$2:$C$1000,MATCH($C4,INDEX('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000,0),0))) =IFERROR(LARGE(INDEX(('Fly Days'!$F$2:$F$1000+ROW('Fly Days'!$F$2:$F$1000)/10000)*('Fly Days'!$F$2:$F$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$F$2:$F$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)),0),SUMPRODUCT(('Fly Days'!$F$2:$F$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$F$2:$F$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)))-ROW(A1)+1),"N/A")

    For Outbound fly day (columns E:G)
    E
    F
    G
    3 =IF($G4="N/A","N/A",INDEX('Fly Days'!$A$2:$A$1000,MATCH($G4,INDEX('Fly Days'!$I$2:$I$1000+ROW('Fly Days'!$I$2:$I$1000)/10000,0),0))) =IF($G4="N/A","N/A",INDEX('Fly Days'!$C$2:$C$1000,MATCH($G4,INDEX('Fly Days'!$I$2:$I$1000+ROW('Fly Days'!$I$2:$I$1000)/10000,0),0))) =IFERROR(LARGE(INDEX(('Fly Days'!$I$2:$I$1000+ROW('Fly Days'!$I$2:$I$1000)/10000)*('Fly Days'!$I$2:$I$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$I$2:$I$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)),0),SUMPRODUCT(('Fly Days'!$I$2:$I$1000>=DATE(YEAR($A$1),MONTH($A$1),1))*('Fly Days'!$I$2:$I$1000<=EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0)))-ROW(E1)+1),"N/A")

    Or see attached. Note, I've put in some dummy entries to test.
    Attached Files Attached Files

  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

    That worked perfectly. Thank you very much!!

+ 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. Show employee data from another sheet for current month
    By earthandbody in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2015, 03:29 PM
  3. Generate output employee data from input employee sheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:28 PM
  4. [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
  5. userform combobox to show current month
    By losmi8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2014, 04:45 AM
  6. Show Current Month
    By howardjo in forum Excel General
    Replies: 2
    Last Post: 02-27-2008, 05:45 AM
  7. 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