A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need formula to auto-sequence numbers (3 labels ea #) Word '07



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2010, 01:21 PM posted to microsoft.public.word.tables
Mark
external usenet poster
 
Posts: 1,534
Default Need formula to auto-sequence numbers (3 labels ea #) Word '07

Want to create 3 labels each of same number, then incrementally increase the
numbers by 1 for another 3 labels. Want to build this in Word '07, but can't
locate the right formula to do this. Found the formula for SUM(ABOVE)+1, and
it works for the second row of 3 labels across. But when I put that formula
on the third row, it adds up all the previous rows and adds 1 to that total -
which makes the numbers incorrect, of course. Can anyone help me get the
correct formula in here?

I would like to be able to quickly paste the formula into each cell, as I
need several hundred sets of 3 labels, so doing this one cell and having to
click on the formula button and then type in the formula, one cell at a time,
is a real PITA. Not sure how to go about doing this. Prefer to use Word,
but if someone can help me use a different MS product that I own and get the
labels to print correctly, I'm open to other methods. I have used Excel in
the past, and worked with their formulas there - which are really good, but
not sure the labels would be uniform in Excel. Labels for MS Word - formulas
in Excel....not sure if they are very interchangeable....but I haven't got a
lot of experience in 2007 yet. My experience is based on how the programs
worked 10-15 yrs ago.
  #2  
Old April 9th, 2010, 01:58 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Need formula to auto-sequence numbers (3 labels ea #) Word '07

See http://www.gmayor.com/Numbered_labels.htm. You can repeat SEQ fields
with the \c switch, or you can use three separate SEQ fields, one for each
of the same number.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Mark" wrote in message
...
Want to create 3 labels each of same number, then incrementally increase
the
numbers by 1 for another 3 labels. Want to build this in Word '07, but
can't
locate the right formula to do this. Found the formula for SUM(ABOVE)+1,
and
it works for the second row of 3 labels across. But when I put that
formula
on the third row, it adds up all the previous rows and adds 1 to that
total -
which makes the numbers incorrect, of course. Can anyone help me get the
correct formula in here?

I would like to be able to quickly paste the formula into each cell, as I
need several hundred sets of 3 labels, so doing this one cell and having
to
click on the formula button and then type in the formula, one cell at a
time,
is a real PITA. Not sure how to go about doing this. Prefer to use Word,
but if someone can help me use a different MS product that I own and get
the
labels to print correctly, I'm open to other methods. I have used Excel
in
the past, and worked with their formulas there - which are really good,
but
not sure the labels would be uniform in Excel. Labels for MS Word -
formulas
in Excel....not sure if they are very interchangeable....but I haven't got
a
lot of experience in 2007 yet. My experience is based on how the programs
worked 10-15 yrs ago.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.