autonumbering invoices

[Guest]

I really need to know how to make Excel sequentially autonumber invoices.
I've searched everywhere I can think of and this seems to be the best kept
secret on the planet. Can anyone please help me?

 

[Norman Jones]

Hi Shananlee,

See J.E. McGimpsey's suggestions at:

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

 

[Guest]

THANKS!!! You have saved me from driving myself insane!

 

[JRod]

Hi, Shanalee,

With the code of Mcgimpsey, you can add a little more, I say, the year (ex:
03/06).
For that, you format the entry cell as text and modify the following code to
this:

Private Sub Workbook_Open()

ThisWorkbook.Sheets(1).Range("B2").Value = NextSeqNumber & "/" &
Right(Date, 2)

End Sub

I added the code & "/" & Right(Date, 2) in order to appear the slash and
the to digits of the year.
I hope this helps to you.

--
JRod
Microsoft [MVP] - Excel
http://EXCELer.blogspot.com

______________________________________