Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default create a template document, which when used will automate a number

Need to create a template in word or excel, that when used will give the next
number eg the first time its opened will be number one. When opened the
second time it will be number 2 etc etc.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default create a template document, which when used will automate a number

Try http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
David Biddulph

"gigglygover" wrote in message
...
Need to create a template in word or excel, that when used will give the
next
number eg the first time its opened will be number one. When opened the
second time it will be number 2 etc etc.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default create a template document, which when used will automate a nu

Looks great, but not sure what to do with it.

Should I create a template and call it Invoice then put this code on the tab
code of the sheet - in the ThisWorkbook rahter than just on Sheet 1(sheet1)

thanks for your help

"David Biddulph" wrote:

Try http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
David Biddulph

"gigglygover" wrote in message
...
Need to create a template in word or excel, that when used will give the
next
number eg the first time its opened will be number one. When opened the
second time it will be number 2 etc etc.




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
how do I create a template that gives each record a unique number? Siniss Excel Worksheet Functions 4 May 27th 07 06:15 PM
automate entries into document from a excel database Designer Lady New Users to Excel 3 March 23rd 06 09:43 PM
How to open xl and create a new document based on a template Colin Wilson Excel Discussion (Misc queries) 2 December 2nd 05 01:07 PM
Automate Export from Form Template to Seperate Table QuestDave Excel Discussion (Misc queries) 0 August 31st 05 05:25 PM
how do i create an automaticly generating number for a document? Brad Excel Discussion (Misc queries) 2 June 15th 05 01:03 PM


All times are GMT +1. The time now is 03:32 AM.

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"