P
picktr
I don't know but I may need a macro?
This is a golf league
There are the regular players and the substitute players
On worksheet1, I enter scores for individual players and the
substitute players.
On worksheet2, the scores are transfered from worksheet1,
and further calculations are made.
Under perfect conditions, if no substitute players are playing,
all the scores I entered on worksheet1, transfer to worksheet2,
and all is right with the world, my work is done, all I have to do is
print.
However, If a regular player is "MIA", that transfers to worksheet2 a
"MIA", calculations are NOT made. I have to
then manually go in and replace everything for that row.
I'm trying to cut down the keystrokes.
My Wish:
After I'm finished entering scores on worksheet1, including
any "MIA's". I then go to worksheet2, and the cell where the "MIA" is
shows a drop down list where I can chose the
substitute player, whom I've already entered a score.
I choose a player, hit "enter", their score is now in the box,
the calculation is made, my work is done.
I hope this helps.
To
This is a golf league
There are the regular players and the substitute players
On worksheet1, I enter scores for individual players and the
substitute players.
On worksheet2, the scores are transfered from worksheet1,
and further calculations are made.
Under perfect conditions, if no substitute players are playing,
all the scores I entered on worksheet1, transfer to worksheet2,
and all is right with the world, my work is done, all I have to do is
print.
However, If a regular player is "MIA", that transfers to worksheet2 a
"MIA", calculations are NOT made. I have to
then manually go in and replace everything for that row.
I'm trying to cut down the keystrokes.
My Wish:
After I'm finished entering scores on worksheet1, including
any "MIA's". I then go to worksheet2, and the cell where the "MIA" is
shows a drop down list where I can chose the
substitute player, whom I've already entered a score.
I choose a player, hit "enter", their score is now in the box,
the calculation is made, my work is done.
I hope this helps.
To