Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2020, 12:23 PM
Millwood Millwood is offline Adding sequential number to labels beside non sequential data Windows 10 Adding sequential number to labels beside non sequential data Office 2016
Novice
Adding sequential number to labels beside non sequential data
 
Join Date: Aug 2020
Posts: 2
Millwood is on a distinguished road
Smile Adding sequential number to labels beside non sequential data

I have ton of folders need to be labeled, each folder differently have its proper DATA (text and numbers), which need to be typed one by one.



I need to add sequential numbers beside or under that each DATA on each single label.

The fact I was able do it by creating excel file and applied it to my Word file.

But the problem when I update (Update Labels), each of the DATA got replaced by the first DATA of the first label.

Any effort would be appreciated. Tanks

Millwood.
Reply With Quote
  #2  
Old 08-14-2020, 05:48 AM
gmayor's Avatar
gmayor gmayor is offline Adding sequential number to labels beside non sequential data Windows 10 Adding sequential number to labels beside non sequential data Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If your data and the numbers are in an Excel data file, you could simply merge the numbers and associated data to labels - Mail Merge Labels

If you just want numbers on labels - see Numbered Labels
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 08-17-2020, 10:06 AM
Millwood Millwood is offline Adding sequential number to labels beside non sequential data Windows 10 Adding sequential number to labels beside non sequential data Office 2016
Novice
Adding sequential number to labels beside non sequential data
 
Join Date: Aug 2020
Posts: 2
Millwood is on a distinguished road
Default

Thanks for the answer,

I just typed the DATA and the sequential numbers in excel, so the DATA also comes with 3 inputs in 2 rows (a text+ serial numbers and code numbers),the third row for the sequential numbers,
when run the in excel (Ctrl+Drag the fill handle), it only duplicates it (third row). it might because many numbers in a same cell (serial num, code num and sequent num.).
Reply With Quote
  #4  
Old 08-24-2020, 08:55 PM
Charles Kenyon Charles Kenyon is offline Adding sequential number to labels beside non sequential data Windows 10 Adding sequential number to labels beside non sequential data Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,082
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

To do a basic mail merge, you need everything variable for a single label to be in one row. In mailmerge terms, each row is a separate record.

These must be big labels.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding sequential number to labels beside non sequential data Looking for help with creating sequential serial number on one page 4ener Word 9 02-24-2019 07:50 AM
Adding sequential number to labels beside non sequential data sequential number and macro optima Word 6 05-15-2018 11:01 PM
Adding sequential number to labels beside non sequential data I would like a function to add sequential numbers to a class number/name Highlander01 Excel 5 01-22-2016 02:29 PM
Adding sequential number to labels beside non sequential data Adding sequential Number in a document that already has merged fields inserted Highlander01 Mail Merge 3 01-19-2016 12:33 PM
Labeling sequential forms with a unique number krau0231 Word 1 10-18-2012 03:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.


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