Make sequential labels, 3 per page, for 50 pages faster/ easier

[sgeng4]

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):

Title		Title
LABEL# (M1, M2, M3...M150)		LABEL# (M1, M2, M3...M150)
Date		Date
Shift (Day / Night)		Shift (Day / Night)
Number		Number
Location		Location
Remarks		Remarks

<tbody>
</tbody>

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!!

 

[Fluff]

Duplicate post https://www.mrexcel.com/forum/excel...er-label-increases-each-time.html#post4987297

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

 

[Fluff]

Closed