Are you familiar with the vlookup command?
It would take 2 minutes to do, but then, if you were familiar with it, you would not be asking
First the hitters.
Open up the HIT CVRC and the START, I assume you have run values. if you are pulling in values from the common league worksheet, the idea is the same.
In START, on the hitter's page, put the cursor in cell S7, the first open one with Abreu. Type in
=vlookup(C7,
at this point, DO NOT HIT RETURN and you go over to the HIT CVRV spreadsheet and go to the VALUES page.
Put the cursor on the A in column A and drag to the K and let go, the function should now look like
=vlookup(C7,[HIT_CVRC_021512.xls]VALUES!$A:$K
Now type in ,11,0)
making the whole thing to be
=vlookup(C7,[HIT_CVRC_021512.xls]VALUES!$A:$K,11,0)
if you are feeling frisky,and have the hit cvcc opened and have not changed its name, you can actually just copy and paste that line into S7 from here. The name of the CVRC has to match or it will confuse your program.
Then you grab onto S7, fill down to the last player. You now have pulled in the values. The final step is getting rid of the formula. Highlight all of column S by clicking on the S, then right click -copy, right click paste special and choose values. You are now down with the hitting.
To do pitching, open up the PIT CVRV and in cell Q7 (you can grab onto the column to make it wider), type in =vlookup(C7,
then go to the pit cvrc, go to values, highlight columns A to I, making the string
==VLOOKUP(C7,[PIT_CVRC_021512.xls]VALUES!$A:$I
then type in ,9,0)
making it =VLOOKUP(C7,[PIT_CVRC_021512.xls]VALUES!$A:$I,9,0)
Again, you can paste it in directly if this is the name of the CVRC you are using.
Do the same fill down, copy, paste special
In words, what vlookup does is looks at C7, which for hitting is Abreu, Bobby
Then it goes over to the values page on the hit cvrc and finds abreu in column A and scoots over 11 columns (note the 11 in the formula) and copies that value into the cell. Pitching is similar, except the $VAL is in the 9th column, hence the number "9" in the formula.
Please let me know if that works.