This relates to a triple yahtzee score sheet. Each player, anywhere
from 2 to 5 players has a range of cells where their scores are
recorded (39 scores per game). What I'm trying to do is have excel
first ask how many players, and then determine the order by which range
gets a value entered first, second, etc. and then use that order for
the rest of the game. Each time it is the next person's roll, the
score can only be recorded in their range. I hope this is clear. The
attached .xls file has a color for each player. So if there are two
players, green and yellow for example, then whichever range the first
score gets entered, the order of the game is determined and each time
it is the next persons roll, the only place a score can be entered is
in their range. If yellow goes first, then the order is yellow, green,
yellow, green, etc. until the game is over. After a score gets entered
in the yellow range, then the only place a score can go is in the green
range, after that score is entered then the only place a score can go
is in the yellow range, and so forth. If you could also email me
directly with any suggestions you might have I would appreciate it as
I'll be travelling for the next few months and usually have to scrounge
up access wherever I can. Thanx!



---
Message posted from http://www.ExcelForum.com/

You didn't post your file

--
Regards,
Tom Ogilvy

mdeever wrote in message
...
This relates to a triple yahtzee score sheet. Each player, anywhere
from 2 to 5 players has a range of cells where their scores are
recorded (39 scores per game). What I'm trying to do is have excel
first ask how many players, and then determine the order by which range
gets a value entered first, second, etc. and then use that order for
the rest of the game. Each time it is the next person's roll, the
score can only be recorded in their range. I hope this is clear. The
attached .xls file has a color for each player. So if there are two
players, green and yellow for example, then whichever range the first
score gets entered, the order of the game is determined and each time
it is the next persons roll, the only place a score can be entered is
in their range. If yellow goes first, then the order is yellow, green,
yellow, green, etc. until the game is over. After a score gets entered
in the yellow range, then the only place a score can go is in the green
range, after that score is entered then the only place a score can go
is in the yellow range, and so forth. If you could also email me
directly with any suggestions you might have I would appreciate it as
I'll be travelling for the next few months and usually have to scrounge
up access wherever I can. Thanx!



---
Message posted from http://www.ExcelForum.com/