I am struggling to get an Excel macro to function as I need it to. I may have created one macro in the past; however it has been a number of year. I will need step by step guidance as well as the macro in order to execute.
We have created a blank purchase order form that we will print out. We will print 50 copies each time we print and would like the spreadsheet to automatically change the number on each printed copy as well as remember the last number printed upon saving so that when the file is opened again, it prints from the point it stopped after the last print session.
Example: Print out 50 Purchase orders today (100001-100050), save the file, print out 50 purchase orders tomorrow (100051-100100).
Please advise how I can get this done with a VBA project and the steps that i need to take in order to execute the macro.
Thanks so much for any help!
We have created a blank purchase order form that we will print out. We will print 50 copies each time we print and would like the spreadsheet to automatically change the number on each printed copy as well as remember the last number printed upon saving so that when the file is opened again, it prints from the point it stopped after the last print session.
Example: Print out 50 Purchase orders today (100001-100050), save the file, print out 50 purchase orders tomorrow (100051-100100).
Please advise how I can get this done with a VBA project and the steps that i need to take in order to execute the macro.
Thanks so much for any help!
