I am trying to autonumber an packing list and I'm not having any luck. I used some code that I found but I am really very new at this. I've been using Excel for years but not VBA.
I grabbed the code from another spreadsheet that someone made and I thought it would work. The print works great but the invoice number doesn't change?
I updated my file path in the code as well. I would also like to save on close the the new packing list number as the file name such as packingList6354
If anyone wants to take a look at it and the sample the help would be greatly appreciated!
https://www.dropbox.com/s/jznrxrt6fz...%20%282%29.zip
Bookmarks