Auto Numbering System
 

I need to set up an auto numbering system on a quote template.

Is there anyway that each time that template is opened at the auto numbering
increase by one?

With thanks

Auto Numbering System
 

Smurf

You will need to employ a little VBA.

See John McGimpsey's site for code.

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


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 16:19:02 -0700, Smurf613
wrote:

I need to set up an auto numbering system on a quote template.

Is there anyway that each time that template is opened at the auto numbering
increase by one?

With thanks

Gord Dibben MS Excel MVP