Hello,
I'm looking for some help. I want to print 50 sheets where each sheet has 3 labels that look like this (The right side is a copy):
[TABLE="class: cms_table_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!!
I'm looking for some help. I want to print 50 sheets where each sheet has 3 labels that look like this (The right side is a copy):
[TABLE="class: cms_table_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!!