I used a cell on the spreadsheet that contained the number i wanted t
start with in my case 1. I set this line to hidden so it wouldn'
appear when I printed.
so let's say Z1 = 1
I then wrote a script that would pull this number on open in the su
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 anothe
variable
i then stored the new z1 value back in z1 and had it resave the fil
over the original file with the new z1 number.
I then changed the value of B1 to the invoice I wanted to work on an
then had it save this file based on the invoice number. Create a folde
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 base
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
helped
