Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto create a file | Excel Discussion (Misc queries) | |||
Master invoice number | Excel Worksheet Functions | |||
Create invoice from Excel worksheet | Excel Discussion (Misc queries) | |||
In Excel, how do you create a multi page Invoice Template? | Excel Discussion (Misc queries) | |||
Extracting data from a client worksheet to create an invoice | Excel Discussion (Misc queries) |