I'm working on a project to keep a live, updated workbook of MLB stats for each player. I am using a web query to pull the stats into a specific worksheet, and that is the easy part.
http://i.imgur.com/2rc8t2c.png
There is a picture of the data I have right now from 2013 that I am trying to set up everything with. My goal is to have Excel send the data for a players column to their team's specific worksheet.
For example, I want Dustin Ackley's stats (more specifically his entire row) to be copied to the Seattle worksheet based on the SEA in the TM column.
Now, I've used vlookup and drop down lists to say "If Dustin Ackley is chosen in the drop down, have his OPS put here" but that is impossible to do in this situation since a drop down doesn't organize/remove duplicates easily.
Is there a way to essentially say "If the Player in Row 83 has a value of ARI in column B, send Row 83 to specific cells in the ARI worksheet."
In my head it seems like it'd be simple, but it isn't proving that!
Bookmarks