+ Reply to Thread
Results 1 to 4 of 4

Searching Other Sheets in Workbook for a Result

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Searching Other Sheets in Workbook for a Result

    I need helping writing code. Attached is my data file. Here is what I'm trying to do:

    In the first worksheet (Draft11), I want to search for a players name in the rest of the workbook, and have it return 3 results when it finds that player.'

    For example: I want to search the rest of the workbook for 'Cam Newton' (Cell E2). When it finds 'Cam Newton' in another worksheet (located in cell B2 of panthers), I want it to return the contents of A1 of that worksheet into G2 of my main worksheet. I also want it to return the row heading (A2) into H2 of my main worksheet, and column heading (B1) into I2 of my main worksheet.


    I feel like this is somewhat simple (searching for a players name and returning 3 corresponding results to it), but understand this could be very difficult given I want to do it for all players in my main worksheet (Draft11)

    Thanks in advance for any help. depth charts.xlsx

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Searching Other Sheets in Workbook for a Result

    I included a macro to fill the needed fields. Watch out for blanks spaces at the end of the players' names
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Searching Other Sheets in Workbook for a Result

    Another one.
    Some Draft Players don't find a match because their names are spelled differently on the Team sheets.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Searching Other Sheets in Workbook for a Result

    Thanks guys. I fixed a few little things except one thing.

    How can I blank out the filled cells if they're not found. Right now it seems to be putting random information into my program. Can't imagine it needs more than a simple line of coding.

    Thanks again in advance.

    depth charts.xlsm

+ 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