Print 200 or so copies of the same document (1 page), but with one unique identifier cell that changes.

[NuZenith]

Sorry about the long title.

I work for a small battery pack production company. We are ramping up production and need to have documentation for each lot. I've been searching for a solution that, ideally, would allow me to print several copies of a BUILD TRAVELER with a unique number on each copy that coincides with the build number, lot, and customer purchase order.

Is there a way in VBA to have a cell that incrementally changes with each print?

Alternatively, I could have a macro that generates a workbook several build travelers, either on the same worksheet or on several worksheets. I'm just not sure where to start.

Thanks in advance.
~Alex

 

[JoeMo]

Can you provide an example of what the unique number you want to use would look like and which part of it would increment on each successive copy? What cell would contain the unique number?

 

[NuZenith]

Can you provide an example of what the unique number you want to use would look like and which part of it would increment on each successive copy? What cell would contain the unique number?

Thanks for your response,

So the unique identifier could be as simple as 004/500, meaning the 4th lot out of an order of 500. If the most feasible method is to generate a workbook, thin I'm thinking it should make a new workbook, copy and paste a template on a specified amount of sheets, and populate specific cells with info like.

[TABLE="width: 206"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]b-k640[/TD]
[/TR]
[TR]
[TD]Customer[/TD]
[TD]CoreLT[/TD]
[/TR]
[TR]
[TD]Lot #[/TD]
[TD]008/300[/TD]
[/TR]
[TR]
[TD]Build Date[/TD]
[TD="align: right"]1/14/2015
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
~Alex