LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default I need a cell to change numbers each time it is opened up.

I need the formula or path to i guess to make a template and each time it is
open it generates a new number, Like a invoice number. For example. in cell
A1 Invoice #
in cell B1 we would have the number 1. then save it and then when you open
the template again the #2 would be in cell B1 automatically? can anyone help?
 
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
Bring focus to same cell every time opened?? Rita Brasher Excel Discussion (Misc queries) 2 July 18th 08 05:57 PM
how do i have a cell number increase by 1 each time file opened DJbase Excel Discussion (Misc queries) 1 May 25th 08 04:17 AM
Saved Changes Gone Next Time Document is Opened Justin Excel Discussion (Misc queries) 2 October 24th 07 09:24 PM
have invoice # roll up, or add 1, each time document is opened Syndee Excel Worksheet Functions 3 March 28th 07 01:04 AM
Make sequential numbers each time sheet is opened Darrell Shuman Excel Worksheet Functions 1 October 19th 05 03:35 AM


All times are GMT +1. The time now is 03:55 PM.

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

About Us

"It's about Microsoft Excel"