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
Bookmarks