help in a formula

Lina · Apr 23rd, 2002, 01:30 AM

I need a help in this please:

What I am trying to do is:
I have a purchase order starts with No. 1
I would like that everytime I make another order the number should be added by 1.
like as A1 = 1
next order A1 should be equal to 2 and so on...
and It's always the same .xlt file.
Thanks for you help.

Tom Schreiner · Apr 23rd, 2002, 01:41 AM

Hi Lina
How do you create another order?
That is when the value would be incremented.
Correct?
Need a few more details.
Thanks,
Tom

Peter100 · Apr 23rd, 2002, 01:44 AM

Create a file for example called ordnos.xls

in A1 enter the starting No. ie 1 and save the file

in your .XLT template,in the order No cell

enter the formula =max(pathfilenameA1:a999)+1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 01:30 AM	#1
Lina New Member Join Date: Apr 2002 Location: Lina Achkar Infantino Posts: 1	I need a help in this please: What I am trying to do is: I have a purchase order starts with No. 1 I would like that everytime I make another order the number should be added by 1. like as A1 = 1 next order A1 should be equal to 2 and so on... and It's always the same .xlt file. Thanks for you help.

Apr 23rd, 2002, 01:41 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Lina How do you create another order? That is when the value would be incremented. Correct? Need a few more details. Thanks, Tom

Apr 23rd, 2002, 01:44 AM	#3
Peter100 Board Regular Join Date: Apr 2002 Posts: 758	Create a file for example called ordnos.xls in A1 enter the starting No. ie 1 and save the file in your .XLT template,in the order No cell enter the formula =max(pathfilenameA1:a999)+1