+ Reply to Thread
Results 1 to 3 of 3

Purchase Order Form needs incrementing numbers for three separate departments

  1. #1
    Registered User
    Join Date
    07-06-2016
    Location
    California
    MS-Off Ver
    2013
    Posts
    2

    Purchase Order Form needs incrementing numbers for three separate departments

    I am new to macros and vb. I am pretty good with Excel's front side, formulas, and so on. It is automating actions to minimize mistakes and work time that I need some help in.

    I cannot post my file because I am new and have no permissions to post, so the best I can do is explain it like this:

    I need to take the numbers from k2:n2, k3:n3, or k4:n4 depending on which department is chosen, and combine them into a single string that looks like this 16-17-001-00 in cell B4, so that I can tell the third set of numbers to increment. Or I need a macro that will increment only the data from the third set of numbers in the string if it is typed as a whole in any one cell.

    I have set up buttons to attach macros to for the different departments so that when the correct button is pressed the department numbers p.o. base will load and increment by one each time.
    Our company p.o. looks like this 16-17-001-00 and the only part that increments is the 001 section. It represents our fiscal year, the p.o. number, then the department code and it is absolutely not something I can alter, it has been long established as the standard form. We have three department codes 00, 02, and 03.


    Please help if you can and thanks in advance.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: Purchase Order Form needs incrementing numbers for three separate departments

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-06-2016
    Location
    California
    MS-Off Ver
    2013
    Posts
    2

    Re: Purchase Order Form needs incrementing numbers for three separate departments

    Ok, I have tried to attach the file, but last time I tried it resulted in a php format for some reason
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populate my Purchase order from a list of Purchase Order numbers and their details
    By Carolbell44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2015, 07:14 AM
  2. Replies: 8
    Last Post: 04-06-2015, 11:44 AM
  3. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM
  4. Purchase form with auto-sequential serial numbers
    By psanghvi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2012, 05:40 PM
  5. Replies: 2
    Last Post: 10-11-2011, 08:03 AM
  6. Creating a Purchase Order Form
    By Fordy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2006, 01:50 PM
  7. purchase order counter in excel purchase order template
    By Brandy@baoco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2005, 03: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