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

Hi LuvMeDo,

See J. E. McGimpsey at:

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


---
Regards,
Norman



"LUVMEEDOO" <(E-Mail Removed)> wrote in message
news:32B6272C-0BB1-45C9-A4DB-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:32B6272C-0BB1-45C9-A4DB-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:6E949347-B00F-4C10-B7E3-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:32B6272C-0BB1-45C9-A4DB-(E-Mail Removed)...
>> > 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
>>
>>
>>