[NEED HELP] Microsoft excel macro for purchase order

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.

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

Can anyone help?

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

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)

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!