Self-generating sequenced number each time a sheet is opened

Ask a question kevdoc 1Posts Tuesday October 3, 2017Registration date October 3, 2017 Last seen - Last answered on Oct 3, 2017 at 04:58 PM by ac3mark
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
plus moins
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!

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!