Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I produce consecutive invoice numbers in Excel?
18 views
Skip to first unread message
Z@discussions.microsoft.com John Z
Nov 4, 2009, 1:43:01 PM11/4/09
to
I am trying to produce consecutive numbering on a bill of sale type
worksheet, Can anyone help me?
worksheet, Can anyone help me?
T. Valko
Nov 4, 2009, 2:06:38 PM11/4/09
to
See this:
http://mcgimpsey.com/excel/udfs/sequentialnums.html
--
Biff
Microsoft Excel MVP
"John Z" <John Z...@discussions.microsoft.com> wrote in message
news:039D4286-B197-4211...@microsoft.com...
ryguy7272
Nov 4, 2009, 6:10:03 PM11/4/09
to
Can you elaborate? Show an example.
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
Geoff_L
Nov 5, 2009, 3:59:01 AM11/5/09
to
Is there a particular point of time or 'event' when you want it to increment?
E.g. when you go to print? If so then the incrementation is quite simply
added as part of the code that runs this. Even if you have recorded the
macro, you can simply add as a last line before the 'End Sub':
E.g. when you go to print? If so then the incrementation is quite simply
added as part of the code that runs this. Even if you have recorded the
macro, you can simply add as a last line before the 'End Sub':
Range("B2") = Range("B2") + 1
Substitute the range that represents the cell where your invoice number lies.
Alternatively you can attach this code to a button etc.
Helpful? Then click Yes.
"T. Valko" wrote:
> .
>
John Z
Dec 11, 2009, 2:03:01 AM12/11/09
to
Thank you Very much. That is exactly what i was looking for!
"T. Valko" wrote:
> .
>
0 new messages