Self-generating sequenced number each time a sheet is opened

kevdoc Posts 1 Registration date Tuesday October 3, 2017 Status Member Last seen October 3, 2017 - Updated on Oct 3, 2017 at 08:21 AM
 Blocked Profile - 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

1 response

EXCEl is not for generating invoices. Get quickbooks for that! If a free solution is what you are looking for, check out:

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