Templates How to Find Next Number SOLVED A1 Idea

[ROBINSYN]

I created templates using the wizards along with database files for each templates. As new sheets are created the database updates perfectly and in Column one is a record of what numbers have been used. Is there a formula iI can put in the template to find the next number to assign automatically each time a template is used.

Thanks a million. This site has taught me so much.
This message was edited by ROBINSYN on 2002-10-05 10:00

 

[Aladin Akyurek]

On 2002-10-05 09:41, ROBINSYN wrote:
I created templates using the wizards along with database files for each templates. As new sheets are created the database updates perfectly and in Column one is a record of what numbers have been used. Is there a formula iI can put in the template to find the next number to assign automatically each time a template is used.

Thanks a million. This site has taught me so much.

=MAX(A:A)+1

would be the next number following the last ascending number in A.