Automated Generated Numbers

[Madiha]

I have to create invoices on Excel. How should i make certain that when the
invoice is opened, a new invoice number is generated? SO that there are no
duplicates.

 

[Niek Otten]

Look here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have to create invoices on Excel. How should i make certain that when the
| invoice is opened, a new invoice number is generated? SO that there are no
| duplicates.

 

[jlclyde]

Look here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have to create invoices on Excel. How should i make certain that when the
| invoice is opened, a new invoice number is generated? SO that there are no
| duplicates.

If you are storing invoices on another spreadsheet for future use. I
know my company does. You can use the Max() +1. You type =MAX(
Then choose the spreadsheet and array that you want to compare it to
close parenthases) and off you go.

Jay