Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Numbering Fortune Excel Worksheet Functions 1 January 22nd 07 03:14 PM
automatic numbering Michael1959 Excel Worksheet Functions 1 July 25th 05 08:41 PM
Automatic Numbering Javster95 Excel Discussion (Misc queries) 5 May 1st 05 07:30 PM
Automatic Numbering. Javster95 Excel Discussion (Misc queries) 0 April 30th 05 07:37 PM
automatic numbering nicola Excel Discussion (Misc queries) 1 November 29th 04 02:01 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"