JRRRJ - love all this stuff.
One question - how easy would it be to recompile your data for individual players for their four year careers - obviously currently specific to Moriah, Morgan and Breanna, but it would be fun to see for other significant players as well.
It would be fairly easy if the team members were the same each year, but they're not.
Here's the easiest way I could come up with:
1. Download and open the blank 2016 workbook
2. Make 4 copies of the Reg Season End worksheet (right click on the tab, choose "Move or Copy", click the "Create a copy" checkbox and select the Reg Season End worksheet)
3. Right-click each of the tabs you've just created and select "Unprotect"
3a. Double-click each new tab and name it for one of the years of interest. E.g. "2016".
4. Open the Full Season Summary worksheet for one of the years you're interested in.
5. Click the row number to the left of the jersey number of a player you're interested in.
6. Right-click on any cell in the highlighted row and select "Copy"
7. Switch to the new workbook and go to the worksheet for the year you just copied from.
8. Right-click on the row number of an empty row between 3 and 17 and select "Paste Special"
9. Select the "Values and number formats" radio button
10. Click "OK"
11. Do 4 thru 10 for any other players of interest.
12. Open the Full Season Summary work sheet for each of the other years of interest and repeat 4 thru 11.
Be sure that, if Breanna Stewart is on line 3 in the 2013 worksheet, she is also on line 3 in the other worksheets.
Shouldn't take TOO long ;^) If you get ambitious, I'd like to see the result.
