Self-generating sequenced number each time a sheet is opened

kevdoc 1 Posts Tuesday October 3, 2017Registration date October 3, 2017 Last seen - Oct 3, 2017 at 06:15 AM - Latest reply: ac3mark 9614 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Oct 3, 2017 at 04:58 PM
How do you create a ( for example an invoice) self-generating sequencing number so every time an excel sheet is opened it will generate the new number. I have tried to save my excel sheet in Excel macro-enabled worksheet then open the macro page using Alt F11 to no avail, can anyone help. Thanks
See more 

Your reply

1 reply

ac3mark 9614 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Updated by ac3mark on 3/10/17 at 05:00 PM
0
Thank you
EXCEl is not for generating invoices. Get quickbooks for that! If a free solution is what you are looking for, check out:
https://www.invoiceninja.com/

Have FUN!

BTW, you can do it, but it is klugy! Beside, are you planning on ever referring back to the invoice, as my EXCEL solution won't save each one!

It's kind of fun to do the impossible! -Walter Elias Disney
Respond to ac3mark