Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
falcp
 
Posts: n/a
Default How to automtically increase a number every time a file is used

With Excel, is it possible to generate automatically a sequence of number
that would increse by one (1) each time the file is used? As an example
generate a new invoice number increasing by one (1) for each new invoice. If
so, how is it done? Thank you for your help.
--
Merci et bonjour
falcp
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default How to automtically increase a number every time a file is used

falcp, A simple way would be to use something like this, you could assign it
to a button, an open or before print event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1

For other ways to do this or if this is going to be used in a temple have a
look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"falcp" wrote in message
...
With Excel, is it possible to generate automatically a sequence of number
that would increse by one (1) each time the file is used? As an example
generate a new invoice number increasing by one (1) for each new invoice.

If
so, how is it done? Thank you for your help.
--
Merci et bonjour
falcp



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
Display a number as Kilometers and k/hr & as Time Gonzo Excel Discussion (Misc queries) 6 November 25th 05 10:15 AM
Links picking up values from an older version of linked file Cate Links and Linking in Excel 4 October 20th 05 01:53 PM
number of fields exceeds 256 when importing from a dbf file Chris Excel Discussion (Misc queries) 5 July 14th 05 09:49 PM
Time as number Howard Excel Discussion (Misc queries) 4 June 23rd 05 09:12 PM
Convert text file to MS_Excel Aqua Flow Excel Discussion (Misc queries) 1 November 30th 04 03:55 AM


All times are GMT +1. The time now is 09:16 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"