Need a macro that will change a po. number it is printed

Maybe something like:

Please Login or Register  to view this content.

I'd test it out with maybe Do While x < 1105 so you don't accidentally print 150 copies of something you don't need.

So all you want to do is update the value in a certain cell on your Template to increment by one, then print 3 copies, then repeat for as many rounds as you'd like to indicate?

1) Highlight the cell with the Invoice number in it and press CTRL-1 to open the Cell Format wizard, apply a CUSTOM number format of "B"0
2) Now enter the starting NUMBER without the "B" into that cell... notice the cell Formatting puts the number back?

This makes it easy to change the number in the cell because all that's IN the cell is a number, the "B" is added by formatting.
The other benefit is that it means you can add different text other than B without having to modify the macro.

==========
Let's assume that's cell A1 on your sheet "Template".
Let's assume each time you run the macro you want the macro to ASK you how many copies of each to print, and how many times you want to increment and print.
The macro will always start by incrementing the current value assuming that it was used in the prior "run".

This would do that:

Please Login or Register  to view this content.

Sitting here rereading the code, seeing "MyRuns" in there has given me fits of laughter.

Almost makes me want to hide layers of innuendo in all the code I write going forward..

Thanks!

This worked perfect. Thank you so much!

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.