I am creating a sheet with an individual serial number for each one printed.
I would like excel to pop up with a dialogue box asking how many copies I
would like and depending on the number, it would increment the serial number
by one for each copy printed.

Can anybody help