Hello,
I have been through the forum and haven't found a solution for a problem with all of the following elements:
REQUIREMENTS
1.) Require prompts that ask for a range of serial numbers (i.e. "What is the serial starting value?" "What is the serial ending value?")
2.) Prints the workbook with the starting serial number, increments the serial number and prints again. Continues to loop until the range as given in #1 is completed.
3.) Serials contain a non-numeric character. Serials begin with '01-', '02-', or '03-' and are followed by 5 digits (i.e. 01-00141).
EXPLANATION
I have a workbook that contains a serial number that exists in cell D5 throughout all worksheets in a workbook. I need an easy way to incrementally print a large series of these work books. For example, if a job comes in for 500 parts we will need 500 print outs of this workbook with serials starting with 01-00141 and ending with 01-00641. Instead of entering the serial, printing, and manually changing the serial and printing again it would be nice to have a macro that would do this for me.
I have some experience with macros but it is mostly restricted to tweaking code. Any assistance would be appreciated.
Thank you!
Bookmarks