|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Perfect!
Thanks so much! This will save us a lot of time!
|
#4
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
number for invoices and forms automatically increasing by 1 each time I open the template | Fedjwick | Excel | 3 | 05-01-2017 05:38 AM |
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 |
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 |