Printing 50 pages of labels where the number of the label increases each time

[sgeng4]

Hello,

I'm looking for some help. I want to print 50 sheets. Each sheet should have 3 labels that look like this (The right side is a duplicate / copy):


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Title
[/TD]
[TD][/TD]
[TD]Title
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LABEL# (M1, M2, M3...M150)
[/TD]
[TD][/TD]
[TD]LABEL# (M1, M2, M3...M150)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD][/TD]
[TD]Date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Shift (Day / Night)[/TD]
[TD][/TD]
[TD]Shift (Day / Night)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number
[/TD]
[TD][/TD]
[TD]Number
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Location
[/TD]
[TD][/TD]
[TD]Location[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Remarks
[/TD]
[TD][/TD]
[TD]Remarks[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Labels start at M1 and go to M150.
Page 1 should have Labels M1 to M3.
Page 2 should have Labels M4 to M6. etc

Is there a way I can accomplish this in excel?

Bonus if there is a way I can make the next 150 labels (M151-M300) easily too!

Thank you in advanced!!

 

[sgeng4]

Bump

 

[SpillerBD]

Word is where you should create labels, especially if you are using pre-cut labels from someone light Avery.
You will need Excel for the incremental part, which you can run out as far as you want and then use filtering to print any range desired.

 

[sgeng4]

Thank you SpillerBD.

Is there a way to automate the incremental part in a macro?