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

Holly · Nov 8, 2005

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

Anne Troy · Nov 8, 2005

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

Ron de Bruin · Nov 8, 2005