ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   automatic cell numbering (https://www.excelbanter.com/excel-worksheet-functions/164484-automatic-cell-numbering.html)

jimE

automatic cell numbering
 
have created a n excel sheet and saved it as a template.I am using it for
doing quotes and want to save the info. when i open the template i want it to
automatically input the next quote numberon saving. how can i do this . can
anyone help. Cheers

Pete_UK

automatic cell numbering
 
Have a look he

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

Hope this helps.

Pete

On Nov 1, 10:15 pm, jimE wrote:
have created a n excel sheet and saved it as a template.I am using it for
doing quotes and want to save the info. when i open the template i want it to
automatically input the next quote numberon saving. how can i do this . can
anyone help. Cheers





All times are GMT +1. The time now is 02:18 PM.

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