Auto Numbering System

[Guest]

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]

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

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