ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   auto numbering an exel work book sheet everytime it opens or print (https://www.excelbanter.com/excel-discussion-misc-queries/36042-auto-numbering-exel-work-book-sheet-everytime-opens-print.html)

Rugby Al

auto numbering an exel work book sheet everytime it opens or print
 
I have a temporay invoice template, I need an invoice number to appear in one
cell, that automatically changes if the invoice is opened or printed.

Ron de Bruin

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rugby Al" wrote in message ...
I have a temporay invoice template, I need an invoice number to appear in one
cell, that automatically changes if the invoice is opened or printed.





All times are GMT +1. The time now is 10:38 AM.

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