ExcelBanter - auto-numbering for invoices

I used a cell on the spreadsheet that contained the number i wanted to
start with in my case 1. I set this line to hidden so it wouldn't
appear when I printed.

so let's say Z1 = 1

I then wrote a script that would pull this number on open in the sub
below. I then had it add one to this number

Let's say B1 is your invoice number field on your sheet

store the value of z1 in a variable

take that value and add one to it storing that value in another
variable

i then stored the new z1 value back in z1 and had it resave the file
over the original file with the new z1 number.

I then changed the value of B1 to the invoice I wanted to work on and
then had it save this file based on the invoice number. Create a folder
called invoices and it will save every one for you.

You can tell it where you want it to save and create a file name based
on a variable.

Private Sub Workbook_Open()

End Sub

I wish I had the code for this easily accessible, but I don't. I hope I
helped.

--
tdecker81
------------------------------------------------------------------------
tdecker81's Profile: http://www.excelforum.com/member.php...o&userid=36938
View this thread: http://www.excelforum.com/showthread...hreadid=566477