Auto Numbering System

's Computer Specifications

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

's Computer Specifications

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
<(E-Mail Removed)> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto numbering without auto number field	firecop1	Microsoft Access Forms	8	4th Jul 2007 02:52 AM
How do I turn off auto numbering or auto hyperlink?	=?Utf-8?B?Z29nbw==?=	Microsoft Word Document Management	2	26th Oct 2006 10:05 AM
Auto Numbering system based on current year	zat	Microsoft Access Forms	7	1st Aug 2006 11:16 AM
Manual numbering to auto (outline) numbering	=?Utf-8?B?RHVrZSBDYXJleQ==?=	Microsoft Word Document Management	1	4th May 2006 10:27 AM
Alphanumeric auto numbering using decimal system	Ben	Microsoft Access Getting Started	3	27th Jun 2003 10:09 PM