Results 1 to 13 of 13

Auto Running Number in Excel Worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2010
    Posts
    12

    Smile Auto Running Number in Excel Worksheet

    Hi everyone.
    Pls review on the attached PO Template, which I use it to issue Purchase Order and keep track on monthly purchases.
    This template allow me generate a fresh PO with feature of auto "Naming" which is also the refernce number of the PO.
    However, its only allow me to generate at maximum of 1000 POs in same worksheet with limited reference number to 3 digits, i.e. from POFM 001 ~ 1000. If i further generate the PO in this workbook for more that 1000, there incremental sequence number will just not working..

    What I wish for improve for this template are as follows:-

    1. Is there a way for me to start my running number which is more that 3 digits?
    2. As I am creating a new workbook monthly (which is to avoid a heavy file size over time), how I can continue the running number from previous month in another new workbook for coming month?
    3. I wish to have same PO refernce number (which is the same as worksheet name) in the body of PO template say in default cell "H4" when a new PO is created, how can I do this with VBA?

    Hope someone could help...

    Regards, CJ Yap
    Attached Files Attached Files
    Last edited by Yap Chin Joo; 10-28-2013 at 01:22 PM. Reason: Spelling

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to auto increment a number each time i open the worksheet
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  2. how to auto increment a number each time i open the worksheet
    By fred rondak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  3. [SOLVED] how to auto increment a number each time i open the worksheet
    By fred rondak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  4. [SOLVED] how to auto increment a number each time i open the worksheet
    By fred rondak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. [SOLVED] How do I add an auto number to a worksheet
    By peterm in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1