If you are going to use the macro, make sure you read through it carefully to understand what it is doing first - and save a copy of your workbook in case you find a problem. Note that it includes a 'delete all sheets loop' so that you can rerun it after tweaking the code.

This code is a working draft and could do with some refinements. For instance, you should probably add some formatting flourishes to make the result look better and maybe you also want the shirt numbers, location/court/field?, date, time etc. I would probably want to include some page setup info in the code too so all the sheets can be printed without having to do a lot of repetitive page setup fiddles.



I believe that Excel doesn't have a hard number limit to how many sheets it can hold but that could be an issue. I haven't ever used a workbook with 200+ sheets so maybe that will be a bit hard to manage but I expect it will work.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Good suggestions. I already had broken the games down into blocks of 50 or so (just to make changes/reprints easier) and everything worked well. I did add the shirt numbers (I'm using that term from now on, everyone here uses "jersey number" and "shirt number" is way cooler) but I didn't mess with any formatting. We have a fancy mail-merge score card with time/location/teams/score data. This sheet is used just to confirm the players are registered on the team. For our purposes, it's perfect. Thanks again for all your help, it is greatly appreciated.