Running Numbers

[AlFlo]

Hi all,
I am a novice wrt Excel. I had created a simple Invoice, to save as a
template. Would like to have the Invoice Number cell automatically in
running number, for each invoice I created. Example my first invoice will
have the number 001. Once finished and saved, opening up another new
invoice, using the template, it would now show 002, and so on.

Truly appreciate some advise to do this.

Thanks in advance.

AlFlo

 

[Norman Jones]

Hi AlFlo,

See JE McGimpseyy's Sequential Numbers page at:

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

If you are not familiar with macros, check the Quick Links at the top right
of JE's page.

 

[Bernard Liengme]

Look here for lots of ideas:
http://groups.google.ca/groups?as_q...1&as_maxd=20&as_maxm=12&as_maxy=2005&safe=off

 

[AlFlo]

Norman, Bernard,
Thanks a million.
Truly appreciate your speedy response.

AlFlo

=================================================