# Show employee data from another sheet for current month

1. ## 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.

2. ## 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.

3. ## Re: Show employee data from another sheet for current month

That worked perfectly. Thank you very much!!

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

#### 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