Thanks for your suggestions. I knew there was a way to get the number of cells in a column/row but I don't know the exact code. That's why I went with the inputbox. I did make a template sheet for each team sheet, but I then transcribed it to VBA (it took forever). Because I am creating an entirely new workbook, this was the "easiest" way without having to worry about cross-copying from one workbook to another. I know that that is relatively easy, but this way I can add (in the future) something to automate the different scoring types (last year we had herding, hurdling, racing; this year we have only moon rocks, empty cells). That's something I plan do to over the summer. I'll try to make the readme a little more user friendly and I'll put that up sometime over this weekend.

That should cover everything.