Ben,

In the example file, there is no worksheet named "Entry Summary". Is 'Sheet1' supposed to be named "Entry Summary"? and then I can populate cell K4 with the number of participants and create the macro? Or is "Entry Summary" supposed to be a different sheet from 'Sheet1' in your example file?