Hi!
I have a sheet that prints out the stats for each member in my soccer team.
The values in this sheet constantly change based on the VALUE in the Name of Player cell. Basically I choose the first player's name from a dropdown list and then click on PRINT. After it finishes printing, I have to select the next player's name so that the values in the sheet change again and click on PRINT again. I have to manually do this till I finish printing everyone's report.
Is there a way that this list can "increment" itself to the next value and then print the sheet automatically, something like a mail merge.

Thanks in advance...
Have fun...