View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Problem saving sequential numbers order book

Take a look he

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

In article ,
Blues wrote:

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.

Any ideas????