1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[NEED HELP] Microsoft excel macro for purchase order

Discussion in 'BlackHat Lounge' started by Hybrid, Sep 19, 2011.

  1. Hybrid

    Hybrid Regular Member

    Joined:
    Jun 23, 2011
    Messages:
    209
    Likes Received:
    250
    Hey guys,

    Im hoping someone can help me out with this.

    Im trying to figure out how to print a bulk amount of blank purchase orders with the purchase order number going up by one each time. I hand write the order details in but just want the blank order with the number as its not just me that uses them and need to have a good number system with no duplicates.

    Currently I am printing 1 at a time and changing the number manually you can imagine how time consuming this is when printing 300-500 at a time lol.

    So im really hoping that someone might be able to help me out with a macro of some sort to help me do this, I dont have any experience with macros so any help would be greatly appreciated.

    The document name is: POSheet
    P/O number cell: C14

    PS I have also googled this but cant figure it out.

    Cheers.
     
  2. Hybrid

    Hybrid Regular Member

    Joined:
    Jun 23, 2011
    Messages:
    209
    Likes Received:
    250
    I have this code but I cant get it to work.

    Sub PrintPO2()
    Dim i As Integer
    Dim c As Integer
    Dim myPO As Range
    Set myPO = Worksheets("POSheet").Range("C14")
    i = CInt(Split(myPO.Value, "-")(1))
    For c = 1 To Application.InputBox("50?", Type:=1)
    myPO.Value = Left(myPO.Value, InStr(1, myPO.Value, "-")) & i + c
    Worksheets("POSheet").PrintOut
    Next c
    ThisWorkbook.Save
    End Sub

    Found the code at: http://answers.microsoft.com/en-us/...se-order/80928a88-69b9-4f0c-947a-d27d470fffeb
     
  3. Hybrid

    Hybrid Regular Member

    Joined:
    Jun 23, 2011
    Messages:
    209
    Likes Received:
    250
    Can anyone help?
     
  4. mariyagomes

    mariyagomes Newbie

    Joined:
    Jul 29, 2013
    Messages:
    1
    Likes Received:
    0
    Hi,

    I think For creating Excel for purchase order fetchflow will help you out and if you want to create new purchase order then contact to above link. I think they will help you out
     
  5. FinalRising

    FinalRising Newbie

    Joined:
    May 18, 2013
    Messages:
    22
    Likes Received:
    6
    Occupation:
    Student
    Location:
    New Zealand
    If you're stuck try the website stackoverflow they might be able to help you out. (Don't have perms to post a link sorry)
     
  6. RainbowWarriorT

    RainbowWarriorT Newbie

    Joined:
    Jan 7, 2015
    Messages:
    0
    Likes Received:
    0
    Hey man, I think I might be able to help you out... I'm a programmer, and I'm pretty decent with Excel. I had a question for you as well! I can't PM you since I'm under 15 posts... Can you send me an email for easier communication?

    EDIT - seems I can't post my email... but the name of the email is 'alstotz' and the domain name is gmail... I'm sure you can figure out the rest. Thanks man

    also, if you already figured it out, shoot me a line anyways... Like I said, I have a question for you!