Hi. The title might not be clear, but I wasn't quite sure how to describe what I'm trying to accomplish; if it's even possible.

I participate in a fantasy baseball league and we use Excel 2007 to keep track of the statistics. Basically, we select players in 8 statistical categories. The rosters we draft are stored in a sheet named "Rosters" and the official player stats are kept on a separate sheet named "Stats" (ie. BA is Batting Average, HR is Home Runs, etc.).

I've attached a sample XLSX file that shows our current setup. We update the statistics monthly by copying and pasting the actual MLB stats from the CBS Sportsline website into the "Stats" sheet. Then, we'll manually find the BA for Joe Mauer, for example, then transfer that number to his spot on the Rosters sheet. So, in the test.xlsx file, it would require copying cell C2 from the "Stats" and pasting it into the E2 cell in "Rosters." We do that manually which takes about 3-4 hours.

I'm hoping there's a way to make this more of an automatic process. If anyone has any ideas or suggestions, I would greatly appreciate it. Thank you!

test.xlsx

Ted