assign an incremental number to a cell, for each new spreadsheet

=?Utf-8?B?TWFya1dhdHNvbg==?=

Guest

Posts: n/a

21st Jun 2007

Can someone advise as the formula required to be entered into a cell, that
allocates a new incremental number each time a spreadsheet of the same name
is opened (like creating a new invoice individual invoice number for each
spreadsheet)

« Vlookup with Multiple criteria and multiple sheets | Prompt for update »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
assign next serial number based on contents of another cell	clint	Microsoft Excel New Users	2	26th Aug 2009 01:57 AM
How can I format a cell to automatically assign a new number?	Grant	Microsoft Excel Programming	1	9th Mar 2009 08:41 PM
Incremental number	Silvio	Microsoft Access Form Coding	2	3rd Dec 2008 10:05 PM
Excel should let me circle a cell or number in the spreadsheet fo.	=?Utf-8?B?QlRheWxvcg==?=	Microsoft Excel Misc	2	8th Mar 2005 03:00 PM
Incremental Number	PeterK	Microsoft Access Queries	0	16th Jan 2004 06:19 PM