L
LadyGriffon
I have designed an invoice on Excel but I need the Invoice number to
automatically generate a number. Any ideas?
automatically generate a number. Any ideas?
M
Max
L
LadyGriffon
Thank you for the tip. One small problem... I don't understand a word
of it....is there anything more simple?
of it....is there anything more simple?
M
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
---------------------------------------------------------
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
-------------------------------------------------Ruud said:
M
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
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
-------------------------------------------------Ruud said:
G
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
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
M
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
--------------------------------------------------
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
--------------------------------------------------
G
Guest
Is there a way to lock in this number so it won't change as the time changes without having to retype it?
J
Jonathan Rynd
You have to use Visual Basic for that. This was one of the original
messages in the thread.
http://tinyurl.com/sijt