ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   automatically generate unique serial numbers for invoices (https://www.excelbanter.com/excel-worksheet-functions/204779-automatically-generate-unique-serial-numbers-invoices.html)

nhlanhla

automatically generate unique serial numbers for invoices
 
i would like excel to automatically generate unique reciept /invoice numbers
which i are sequencial. i can then pass word lock. i do not have Access on my
computer.

Pete_UK

automatically generate unique serial numbers for invoices
 
This link:

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

gives two ways of doing it.

Hope this helps.

Pete

On Oct 2, 12:39*pm, nhlanhla
wrote:
i would like excel to automatically generate unique reciept /invoice numbers
which i are sequencial. i can then pass word lock. i do not have Access on my
computer.




All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com