Print template with changing numbering

[Anar]

Hi, guys,


I need help. The issue is that I have a template, I need to print 120 copies of it. The whole structure of the template does not change except for the numbers of the each template, for example, first printed template should have a number QSA1, second QSA2, etc.

It can be done manually, however changing numbers in each template and printing them will take a lot of time.


Thank you

 

[NARAYANK991]

Hi ,


Where are these numbers to be changed and printed ? In a cell ?


Narayan

 

[Anar]

Hi,


In a cell, Narayan, for example, in B2

 

[NARAYANK991]

Hi ,


You will have to use a macro / VBA procedure to do the printing from within a loop ; within the loop , increment the cell that is to have the template number. Do you want the complete procedure ?


Narayan

 

[Anar]

Thank you, NARAYANK991


I don't need complete procedure as I already have one.