Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 05, 07:35 PM
Jacqui
 
Posts: n/a
Default formula to have each new invoice automatically have the next numb

When opening a new invoice or page, what is the formula to get the next
number in sequence to appear in a cell? This would be simular to having
todays date appear (=today())

  #2   Report Post  
Old January 15th 05, 08:12 PM
Paul B
 
Posts: n/a
Default

Jacqui, have a look here and see if this will work for you
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

"Jacqui" wrote in message
...
When opening a new invoice or page, what is the formula to get the next
number in sequence to appear in a cell? This would be simular to having
todays date appear (=today())





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
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 10:02 PM
How do I automatically pull a new invoice number into an excel te. Hube Excel Discussion (Misc queries) 3 December 29th 04 12:27 AM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 04:38 AM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 12:29 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017