Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 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

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
 



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 03:39 PM.


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