Problem saving sequential numbers order book

B

Blues

Hello,

I made a purchase order excel book where every time i entered the
template the order number would increase by 1 - e.g C1002, C1003, C1004
etc etc

However, i have typed out a full order on the template then tried to
save it as the current order number (in this case it was C1002). Then,
when i need to make another order, i go back into the template
expecting the order number to go up to C1003, but it just stays at
C1002. I then go into the saved order C1002 and that number increases
by 1 to C1003. :confused:

Any ideas????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment Macro - Order numbers 3
Select one checkbox to Add a Purchase Order (PO) Number 2
Sequential numbering 3
How to order numbers 4
creating order book in excel 2007 2
Excel 2007 erases VBA code from Excel 2003 5
AUTOMATIC INVOICE NUMBER FOR PURCHASE ORDERS 3
How do I automate the numbering of a purchase order form. 2

Top