Hi,
I need to be able to create a counter so that when a value is entered into a
cell (for the number of copies to be printed), excel adds this number
incrementally to a base value so that each sheet printed (all of which are
identical except for their reference number) have a different number.
For example...
Base value = 100
Copies printed = 3
So the first sheet prints with a value of 101, the second 102, the third
103.
I then need excel to remember that the last sheet number was 103, so that
next time the workbook is opened, the base value will start at 103.

Any suggestions?
Regards
Colin Foster