Add a serial number to an invoice

excelledsoftware · #1 02-17-2015, 07:51 PM

This can be done using an on open command. This will be in the visual basic editor under thisworkbook.

Code:

Private Sub Workbook_Open()
  Range("E15").Value = Range("E15").Value + 1
End Sub

Now there are ways you could probably do it with a formula or even having a button that says "New Invoice" which you would just attach the middle of the code to it.

Let me know if this is what you are looking for.

Thanks

pringle747 · #2 02-18-2015, 01:36 AM

Many thanks, but unfortunately you are talking to a dumbo! I can handle Excel but have no idea what an Open command is, where and how do I insert the code you sent me etc..

What I am doing right now is opening Workbook called invoices 2015, renaming next new sheet as 101 (for example), and then manually typing 101 into E15.

New invoice.....new worksheet....and so on.

Not at all satisfactory.

Thanks for the help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting serial number to years, months and days	hannu	Excel	6	02-14-2013 09:21 PM
Increase serial number for every print	atomtm	Word	1	06-15-2012 05:39 AM
Serial Number Issue	rehan5001	Excel	1	06-08-2011 02:46 AM
Invoice Number Generation	mrphilk	Excel	2	06-08-2010 12:39 PM
Help needed using the serial number date with sumifs - whole office is stumped	FraserKitchell	Excel	3	01-06-2010 12:24 PM