Auto Generation of Numbers in single cell

[debmalya]

I have created an Invoice format in excel. I need to generate the bill numbers automatically every time I open the file in cell no: C1 as 00001, 00002, 00003 and so on. Is there any formula by which I can create this?

Attchd a sample of the invoice.

[kvsrinivasamurthy]

See the attached file.workbook event is used.

[:) Sixthsense :)]

Format the c1 cell as Custom>>00000

Add the below code in ThisWorkbook Code window.

Please Login or Register  to view this content.