Posted to microsoft.public.excel.programming
|
|
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????
|