View Single Post
 
Old 02-21-2019, 02:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The simplest approach would be to use an Excel worksheet formatted with the desired layout. See the attached workbook, which is already formatted for 3 pages of labels.

Note the formula used in A1. Once you've used up the existing 3 pages of labels, you can either:
• use Find/Replace to change the 1500 to 1680 for all cells, or
• copy the existing columns and paste them to the right the current ones.
Either approach will give you a new set of labels to work with.
Attached Files
File Type: xlsx SMG Serial #s.xlsx (10.5 KB, 11 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote