Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-24-2017, 11:15 AM
msullivan msullivan is offline Trying to create an automatically increasing number within a formatted page Windows 7 64bit Trying to create an automatically increasing number within a formatted page Office 2013
Novice
Trying to create an automatically increasing number within a formatted page
 
Join Date: Aug 2017
Posts: 2
msullivan is on a distinguished road
Default Trying to create an automatically increasing number within a formatted page

Please see attached screenshot. We frequently need to process these carton labels, and it is getting rather tedious to manually change the numbers for each page. Is there a way I can get this to repeat on as many pages I will need but have Word increase this number value for the 'CARTON NUMBER' automatically?



Thanks for any help, sorry if I am doing this wrong, first time posting here.
Attached Images
File Type: png screenshot.PNG (51.9 KB, 19 views)
Reply With Quote
  #2  
Old 08-24-2017, 06:46 PM
macropod's Avatar
macropod macropod is offline Trying to create an automatically increasing number within a formatted page Windows 7 64bit Trying to create an automatically increasing number within a formatted page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Simply replace the '9' in '9 of 80' with a SEQ field coded as:
{SEQ Nr}
and copy that you each of the other four labels on the page.

From then on, simply make as many copies of the labels as you need and, when you're done, press Ctrl-A, F9 to update the fields.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-25-2017, 07:27 AM
msullivan msullivan is offline Trying to create an automatically increasing number within a formatted page Windows 7 64bit Trying to create an automatically increasing number within a formatted page Office 2013
Novice
Trying to create an automatically increasing number within a formatted page
 
Join Date: Aug 2017
Posts: 2
msullivan is on a distinguished road
Default Perfect!

Thanks so much! This will save us a lot of time!
Reply With Quote
  #4  
Old 08-25-2017, 02:13 PM
macropod's Avatar
macropod macropod is offline Trying to create an automatically increasing number within a formatted page Windows 7 64bit Trying to create an automatically increasing number within a formatted page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

FWIW, I'd be inclined to set this up using a label mailmerge with an Excel data source. In the workbook, I'd have a header row with columns corresponding to all the info you presently have to type. On the 2nd row, I'd type all those data and have formulae from rows 3 down that simply replicate the data from row 2. One column would be for the Carton # and another for the number of cartons. Unlike all the other columns, the Carton # columns would simply increment from the row above, I might have, say, 100 rows of data set up this way. Having filled in the data on row 2, I'd save & close the workbook, then open up the Word mailmerge main document, answer 'yes' to the mailmerge SQL prompt, then click 'Finish & Merge'>'Send to Printer' and tell it to process records, say, 1 to 80 (80 being the # input into the workbook column for the number of cartons). No copying & pasting label content is required with such an approach.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to create an automatically increasing number within a formatted page number for invoices and forms automatically increasing by 1 each time I open the template Fedjwick Excel 3 05-01-2017 05:38 AM
Trying to create an automatically increasing number within a formatted page How to create a table with a number of line depending a number entered by user Cellendhyll Word Tables 3 07-10-2014 05:49 AM
Trying to create an automatically increasing number within a formatted page replace number with formatted number antoniob Word 5 06-17-2014 02:32 PM
Add increasing number at document opening HidExp Word 6 09-17-2012 12:28 AM
Page Count Increasing Exponentially BobF Word 3 03-23-2012 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft