Sequential numbering

**antony moseley** · 04-07-2009, 11:19 AM

Hi,

Im looking to create a form that when printed off it creates a new "form number" everytime, bascially one up from the last number.

Any ideas?

Thanks

Antony

**oldchippy** · 04-07-2009, 11:21 AM

Hi,

Take a look here

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

**antony moseley** · 04-07-2009, 11:35 AM

Hi,

Im sorry - im confused. I have tried to copy as per the link but still i am not getting anywhere....... any further help?

Thanks

Antony

**oldchippy** · 04-07-2009, 11:39 AM

Hi,

Take a look at this link on where to paste the code

http://www.rondebruin.nl/code.htm

**antony moseley** · 04-07-2009, 11:49 AM

Hi,

Ok ive cracked that bit, however when I print the form I want it to uplift the number by 1 each time -m ideally id like to print of in batch of say 50 and id get the form each having a different number from 1 to 50.

Trust that makes sense

Antony