AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS

[Guest]

Hello, i know this questions has been posted before, but i an extremely new
at creating formulas in excel (besides the basics). I have created a purchase
order template that i would like to automatically update the P.O. number
everytime the template is opened. I would like the invoices to increase by
+1. I would also like to be able to share this template with others in my
office on our server. Is there anyone who can help me with this, i have been
struggling with this problem for a few weeks now and i have made no progress.


I would seriously appreciate any help someone may be able to give. I just
know sending me to a website to try to figure it out for myself doesn't seem
to be working for me.

Emily

 

[Norman Jones]

Hi LuvMeDo,

See J. E. McGimpsey at:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

 

[Guest]

First of all thank you so much for responding. This may sounds like a very
stupid question, but do i just copy and paste that formula? And how will i
tell the formula whice cell to add +1 to each time?

 

[Norman Jones]

Hi LuvMeDo,

The link page explains two methods: the first uses the Workbook_Open
procedure to read / write values to the registry; the second uses a
function, which is called from the Workbook_Open event, to read / write
values to a text file.

If you are not familiar with even procedures, see Chip Pearson's overview
at:

http://www.cpearson.com/excel/events.htm

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm