Please Help me.............

[scarp71]

I have been running a NASCAR Fantasy League for several years. I use excel
for calculating the scores each week for each team, but I have to enter the
driver's points individually on all 85 teams.
On the sheet that I use, each team has 8 columns for the drivers and 36
rows for all of the races. How can I enter the race points only once on some
type of master list which will then plug the points into each individual
team, instead of having to enter each individual driver's points 85 times?
I hope this didn't completely confuse you.
Thank you in advance for your help!!!

 

[bj]

try making a named range for each drivers score and just reference the name
in each data set

 

[ufo_pilot]

check out the VLOOKUP or HLOOKUP formulae

 

[Don Guillett]

IF the data goes to the SAME cell on each worksheet>select all sheets>enter
data on one.