+ Reply to Thread
Results 1 to 7 of 7

Summary sheet that pulls specific data when searched for

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2013
    Posts
    4

    Summary sheet that pulls specific data when searched for

    I am the head lifeguard at my local beach and am looking to make the way I place my guards more efficient. I have a sheet full of my guards and where they have been located each day. What I need is a way to use a new sheet to type in the guards name and have it pull data from the original sheet to show me where they have been located most often and least often. Attached is an incomplete version of the spreadsheet. Any help would be great!!

    Lifeguards.xlsx

  2. #2
    Registered User
    Join Date
    06-20-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Summary sheet that pulls specific data when searched for

    My request is very similar to this post. I tried to mimic the solution to that post and make it applicable to my data, but it was way too advanced for me haha

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Summary sheet that pulls specific data when searched for

    Hi and welcome to the forum

    See if the attached will help you?
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    06-20-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Summary sheet that pulls specific data when searched for

    That definitely has the information that I need, however is there a way for me to simply type in a name into a cell and have certain data pop up such as the locations they have been most and least frequently?

    It still helps a lot to have the sheet you made, so maybe if there can be a 3rd one with the search option.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Summary sheet that pulls specific data when searched for

    I'm out of time for now, I will take a look for you in a cpl of hours

  6. #6
    Registered User
    Join Date
    06-20-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Summary sheet that pulls specific data when searched for

    Thanks a lot!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Summary sheet that pulls specific data when searched for

    I added a new sheet (3) with the results. I was playing around with offset() but it became so involved that I got lost lol, so I used a helper row at the bottom of sheet2. I added a drop-down on sheet3 A2 so you dont need to type the names (and risk a typo)
    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)

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