Hello.

I have set up a worksheet, using the increment macro, which enables me
to send purchase orders via e-mail. Every time i go into the work
sheet, i run the macro and the invoice number increases by one giving
me a unique order number each time. I then save the file as that order
number so i have a copy of the order that was sent.

However, i was wondering whether there would be a way of the order
number increasing by 1 automatically every time i opened the template
(as opposed to every time i open the template i have to run the
macro)?

Any suggestions would be appreciated, thanks.


--
Blues
------------------------------------------------------------------------
Blues's Profile: http://www.excelforum.com/member.php...o&userid=30771
View this thread: http://www.excelforum.com/showthread...hreadid=504383