Generating purchase order numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel to set up a purchase order document for our company. We always have to input a new number when we generate a new p.o. Is there any kind of formula that I could use that would allow the new document to generate the next number in the sequence? Any help or insight is much appreciated.
 
Monica, here is one way, you could use a macro like this one, you could also
use it in a open or before print event
Sheet1.[A1] = Sheet1.[A1].Value + 1

--
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 2000 & 97
** remove news from my email address to reply by email **
Monica Garza said:
I am using Excel to set up a purchase order document for our company. We
Click to expand...
always have to input a new number when we generate a new p.o. Is there any
kind of formula that I could use that would allow the new document to
generate the next number in the sequence? Any help or insight is much
appreciated.
 
Back
Top