+ Reply to Thread
Results 1 to 4 of 4

Macro to automatically number & print purchase orders

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Macro to automatically number & print purchase orders

    Attached is the purchase order we use. I would like to create a pad of 100 3 part forms. I would like to be able to put in the first PO Number in A5 (the yellow cell) and then activate a macro that will print the page (3 times), increment the number, and print the next page. I would need to be able to change the initial PO Number, and adjust how many pages to print (it might not always be 100).
    Any help would be greatly appreciated.
    Attached Files Attached Files
    "Laugh? I thought I'd die!"

    Jimbo?

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Macro to automatically number & print purchase orders

    Try something like this:

    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Macro to automatically number & print purchase orders

    That seems to work perfectly! Thank you. Am I right in thinking if I want only 2 copies instead of 3 I can change the number in "Copies:=3" to "Copies:=2"?

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Macro to automatically number & print purchase orders

    Yes, the other PrintOut properties can be seen in the table here: https://msdn.microsoft.com/en-us/lib.../ff838253.aspx

+ 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. Automated log from Purchase orders
    By Angel1111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2015, 03:44 PM
  2. Purchase orders
    By markabraham in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2014, 01:08 PM
  3. Sequential number for purchase orders
    By Rockhopper in forum Excel General
    Replies: 2
    Last Post: 08-19-2014, 09:03 PM
  4. Purchase orders tracking
    By sagar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2014, 08:19 PM
  5. Purchase orders tracking
    By sagar in forum Excel General
    Replies: 2
    Last Post: 08-11-2014, 03:41 PM
  6. Purchase Orders
    By Merlin54k in forum Excel General
    Replies: 4
    Last Post: 06-07-2008, 07:03 AM
  7. [SOLVED] Consecutively Number Purchase Orders
    By debcps in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2005, 11:06 AM

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