Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Number of Excel Purchase Order Form

    We have created an excel-based purchase order (PO) form for use in our company. I would like the form to automatically number itself (increase by one) each time an employee uses it--each PO requires a unique number. The form is located on the company's server, and the cell for the PO number is D11. I am not a skilled or advanced excel user and will require step by step instructions if someone is willing. I have enabled macros for this spreadsheet and I know how to get to the VBA screen, if that is what's required. Thank you!

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    CJ,

    Welcome to the Lounge as a new poster!

    I assume that your PO is a template?
    One way to accomplish the task would be via a macro that would be used to save the created document.
    The macro would check a text file or another workbook for the last number used if the PO field is currently blank.
    Then increment the number found there by one and update and save both the text file/workbook and the PO.
    If the PO field is not blank then it would just save the PO since a number had already been assinged this is an EDIT of an existing PO.

    Sorry I don't have time to bang out some sample code but I'm getting ready to hit the road and am short on time.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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