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!!!

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

"scarp71" wrote:

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!!!

check out the VLOOKUP or HLOOKUP formulae


"scarp71" wrote:

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!!!

IF the data goes to the SAME cell on each worksheetselect all sheetsenter
data on one.

--
Don Guillett
SalesAid Software

"scarp71" wrote in message
...
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!!!