I have been researching using sequential numbers for invoices and
purchase orders, but all of them seem to advance the number either
every time the document is opened or saved. My purchase order is part
of a larger file, and since I will be opening and saving the file
without necessarily writing a purchase order I need more control over
its advancement. I was wondering how I could create a button that when
pressed or selected would advance the number by 1? Also, how could I
make it create a unique number depending on who's creating the purchase
order. For example, let's say the user is "John Smith" how could I have
the P.O. number be somthing like "JS-0001"? Thank you very much in
advance for your help.


--
littlegreenmen1
------------------------------------------------------------------------
littlegreenmen1's Profile: http://www.excelforum.com/member.php...o&userid=23978
View this thread: http://www.excelforum.com/showthread...hreadid=376479