Hello,
I'm trying to build a fantasy baseball spreadsheet. I have a list of players that I'm hoping to fill in each roster spot for each team.
The player's name is in Column B.
The player's position is in Column C.
On the same tab, I'd like to place each player into a roster spot which is the following for 23 spots:
The first position "C" is in B30. The last position "Bench" is in B52.
C
1B
2B
3B
SS
OF
OF
OF
Util
Util
SP
SP
RP
RP
P
P
P
P
Bench
Bench
Bench
Bench
Bench
So if a player qualifies for the C position, I'd like them to go in that row.
If a position is full (example the C spot is filled and another C is drafted), I'd like the player to go to the Bench.
To further complicate things, not sure if there is a way to handle multiple positions. For example if a player has multiple positions such as 2B and 3B, is it possible to move them to first open spot they qualify for?
Thank you so much for looking.
I'm trying to build a fantasy baseball spreadsheet. I have a list of players that I'm hoping to fill in each roster spot for each team.
The player's name is in Column B.
The player's position is in Column C.
On the same tab, I'd like to place each player into a roster spot which is the following for 23 spots:
The first position "C" is in B30. The last position "Bench" is in B52.
C
1B
2B
3B
SS
OF
OF
OF
Util
Util
SP
SP
RP
RP
P
P
P
P
Bench
Bench
Bench
Bench
Bench
So if a player qualifies for the C position, I'd like them to go in that row.
If a position is full (example the C spot is filled and another C is drafted), I'd like the player to go to the Bench.
To further complicate things, not sure if there is a way to handle multiple positions. For example if a player has multiple positions such as 2B and 3B, is it possible to move them to first open spot they qualify for?
Thank you so much for looking.