Purchase Order Printing (Automatically increment the number in a cell)

**bigsi1984** · 10-08-2013, 11:02 AM

Untitled.jpg

Hello,

I work in a purchasing team and I use a printed purchase order to place orders with suppliers. Currently I print out the sheets and hand write in the next 50 or so numbers and then repeat when required.

I would like to be able to use a macro to print the next 50-100 sheets and have the numbers go up incrementally in cell K2.

I am not sure if the image I have uploaded will be visible to help with my explanation.

Macros are new to me and I recently made one by simply using the record macro button and then carrying out the vlookups etc that I need to be done. However, I do not understand many of the programming language terms.

Hopefully someone can help.

Thanks,

**ARGK** · 10-08-2013, 12:05 PM

Hi
Assuming K2, as per your example, stores the PO Number, cut and paste this code into a module in your workbook and run it as you need to.

Please Login or Register  to view this content.

Good luck.
Tony

**bigsi1984** · 10-09-2013, 03:33 AM

Thats great thanks!

**Fotis1991** · 10-09-2013, 03:37 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.