AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS
 

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

AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS
 

Hi LuvMeDo,

See J. E. McGimpsey at:

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


---
Regards,
Norman



"LUVMEEDOO" wrote in message
...
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

AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS
 

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" wrote:

Hi LuvMeDo,

See J. E. McGimpsey at:

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


---
Regards,
Norman



"LUVMEEDOO" wrote in message
...
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

AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS
 

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



---
Regards,
Norman


"LUVMEEDOO" wrote in message
...
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" wrote:

Hi LuvMeDo,

See J. E. McGimpsey at:

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


---
Regards,
Norman



"LUVMEEDOO" wrote in message
...
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