Automatic numbering

[LadyGriffon]

I have designed an invoice on Excel but I need the Invoice number to
automatically generate a number. Any ideas?

 

[Max]

Try : http://tinyurl.com/sijt

where MVP Leo Heuser provides 2 subs

 

[LadyGriffon]

Thank you for the tip. One small problem... I don't understand a word
of it....is there anything more simple?

 

[Max]

Here's a non-macro way suggested by MVP Norman Harker
---------------------------------------------------------
From: Norman Harker ([email protected])
Subject: Re: invoice number macro
View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2001-08-21 04:52:34 PST

Hi Ruud!

For any given number of invoices the possibility of non-unique numbers being
generated using random numbers increases with the number of invoices.

I would suggest a non-random method:

=INT(NOW()*1000000)
returns 37124908872

This returns a number that will be unique as long as no-one generates
another invoice within 1/100th of a second (assuming their computer clock is
in synchronization with yours).

You could say that it has an advantage in that with the invoice number you
can determine the date and time of issue.

hth

can anyone tell me how te make a macro to generate unique
invoice numbers

thnx

-------------------------------------------------

 

[Max]

Ok, how about a non-macro way suggested by MVP Norman Harker
below ?

You may also wish to check out the excel template INVOICE.XLT,
usually found at path:

C:\Program Files\Microsoft Office\Templates\Spreadsheet
Solutions\INVOICE.XLT

This template has the option to generate unique sequential numbers.

---------------------------------------------------------
From: Norman Harker ([email protected])
Subject: Re: invoice number macro
View this article only
Newsgroups: microsoft.public.excel.programming
Date: 2001-08-21 04:52:34 PST

Hi Ruud!

For any given number of invoices the possibility of non-unique numbers being
generated using random numbers increases with the number of invoices.

I would suggest a non-random method:

=INT(NOW()*1000000)
returns 37124908872

This returns a number that will be unique as long as no-one generates
another invoice within 1/100th of a second (assuming their computer clock is
in synchronization with yours).

You could say that it has an advantage in that with the invoice number you
can determine the date and time of issue.

hth

can anyone tell me how te make a macro to generate unique
invoice numbers

thnx

-------------------------------------------------

 

[Guest]

Max; have you ever used the invoice template, because
the numbering option seems to be as clear as mud to me
and I can't find any pertinent help on it. Everything it
says does not appear as should be. Thanks

Arlene

 

[Max]

I've not used it, but I did check out the Invoice.xlt
before I gave the pointer in the reply. (My version's xl97)

When you open the Invoice.xlt (enabling macros, of course)
there'll be an Invoice toolbar where you can find
an button with "001" on it.

Hovering the cursor over this button reveals "Assign a number"

Clicking on the button surfaces a prompt:
"You have asked for a unique number to be assigned to this form.
Is it OK to proceed?"

Pressing OK assigns a number to the form.

Pressing the "001" icon again will surface a warning prompt:
"A unique number is already assigned to this form.
Changing it may cause bookeeping problems.
Do you really want to proceed?"

There's also a comment for the cell "Invoice No."
(near the top right corner) which says:
"This is the location for the unique identifier for each invoice.
If you would like to add a unique number to this invoice,
click the Add a Number button on the Invoice toolbar.
Remember, if you want to generate sequential invoices
from more than one computer on a network,
go to the Customize Your Invoice sheet and choose that option."

And there's also a "?" icon in the same Invoice toolbar
which says "Template Help".

Clicking on this icon gives "MS Excel Template Help"
which does contain some explanations on for example:
how to add an automatic tracking number to the form, etc
--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------

 

[Guest]

Is there a way to lock in this number so it won't change as the time changes without having to retype it?

 

[Jonathan Rynd]

Is there a way to lock in this number so it won't change as the time
changes without having to retype it?

You have to use Visual Basic for that. This was one of the original
messages in the thread.
http://tinyurl.com/sijt