copying data from one sheet to another

[tmiller85]

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

[MarvinP]

Hi Ted and welcome to the forum.

You need the VLookup formula. In E2 put this formula

Please Login or Register  to view this content.

It will look at the name in B3 and find it in the stats table and return the 3rd column from the left, exaxtly matched.

After you do this one formula and Set some dollar signs for $A$1 and $G$5 you can pull the formula down the whole column. Do similar formulas for your other stats. It should take you less than 3 minutes instead of a few hours.

[tmiller85]

Marvin, thank you so much! Works like a charm. You just saved me countless hours of time, not to mention an accurate system as opposed to the error prone manual process we've used in the past. Thank you!