Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2015
    Posts
    9
    Thanks
    4
    Thanked 0 Times in 0 Posts

    I need to Pull data from one sheet to another based off cell value

    So I need to track times over all and by employee. I created a spreadsheet to track the Over All times.

    How can I separate it out to different sheets for each individual employee?

    See the attached spread sheet.

    thank you
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    nsmjc,

    It would be helpful if you kept this to a single thread since it is a single project.

    What you need here is the same AverageIf function we used before.

    Ex for Dispatcher 1 it would be: =AVERAGEIF(Time_Entry!H7:H9,Agerage_Times!$B9,Time _Entry!G7:G9)

    The above formula can be filled down to accommodate the other dispatchers.
    averageif.JPG

    The only other thing you really need here is a Dynamic Range name for the two ranges so as you add rows the formulas will automatically adjust.

    Dynamic range names: {entered in the Name Manager on the Formulas tab}

    Dispatcher: =OFFSET(Time_Entry!$H$7,0,0,COUNTA(Time_Entry!$H$7 :$H$5006),COUNTA(Time_Entry!$H$7:$H$7))
    TimeElapsed: =OFFSET(Time_Entry!$G$7,0,0,COUNTA(Time_Entry!$G$7 :$G$5006),COUNTA(Time_Entry!$G$7:$G$7))

    With these defined your formula becomes: =AVERAGEIF(Dispatcher,Agerage_Times!B9,TimeElapsed )

    Here's a file with both sheets incorporated. Avg Disp Time.xlsm
    HTH
    Last edited by RetiredGeek; 2015-10-26 at 11:08.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •