How do i create a Wrksht that auto. chgs to nxt invoice # when ope
 

I'm trying to create a worksheet that, when opened, automatically changes the
P.O. # to the next number.
Any ideas?

How do i create a Wrksht that auto. chgs to nxt invoice # when ope
 

There are several VBA macros here that help you do this:
http://vbaexpress.com/kb/kblist.php
You can search the page for "invoice" and make sure it's an Excel entry.
************
Anne Troy
www.OfficeArticles.com

"Holly" wrote in message
...
I'm trying to create a worksheet that, when opened, automatically changes
the
P.O. # to the next number.
Any ideas?

How do i create a Wrksht that auto. chgs to nxt invoice # when ope
 

Hi Holly

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Holly" wrote in message ...
I'm trying to create a worksheet that, when opened, automatically changes the
P.O. # to the next number.
Any ideas?