I have a template to generate batch tickets with batch ticket numbers in a
cell. I like to be able to have a formula that would increase the batch
ticket number by "one" everytime I print a batch ticket. Right now, I start
with a number, print the batch ticket, change the batch ticket number, print
and so on...

Any ideas, any one?