Need help on a auto generating baseball lineup for my sons little league baseball team

Hi Everyone,

I was hoping someone could help me with the attached excel spreadsheet. I found this spreadsheet while looking for an auto generating baseball position and lineup card to ensure that all the kids get to play both infield and outfield during the game. However, the original worksheet was for 3 innings and 14 games, and I need it for 6 innings and 16 games. When I tried to copy and paste the formula to add the additional games and innings, it would come back as N/A.

The page has two tabs, one where we put the players names and the other that has the actual lineups for each different game. I'm supposed to be able to press print and each game will print on its own, even though they are on one spreadsheet.

If anyone can help me, I would greatly appreciate it. I have attached a copy of the spreadsheet.

Thank you!

I found the guiding tab. unhide all tabs and you will find that the selection is governed by lines 22;26 of the tab "Games by Postion". you have to extend the formulas in that to fill 16 by 6 since you only have 14 by 3 now.

Lazily I copied some of the layouts and extended it to fill all the innings necesary.

Thank you RCM.

you are welcome/// please mark it as solved if you are satisfied///