LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JDellenger
 
Posts: n/a
Default Merging different quantites of labels based on Excel data


I have a worksheet that I am trying to do a mail merge from to print mailing
labels. There is a column that is labeled quantity and has a list of numbers
in it.

I need to be able to print a different number of each label...based on the
number that is in the quantity column.

Is there any way that I can do this? For example, if my quantity column has
the value 3...I need to be able to print 3 labels that say "Box 1 of 3", "Box
2 of 3" and "Box 3 of 3" as one row of the merge.

Does anyone have any ideas of ways that I can maybe use multiple formulas to
do this????

Any help would be GREATLY appreciated!!!!!!!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format cell based on results of vlookup function Edith F Excel Worksheet Functions 1 July 21st 05 07:39 PM
Subtract a group of cells from a total based on ending date Nicholas Scarpinato Excel Discussion (Misc queries) 0 May 17th 05 03:25 PM
Excel 2003 and Labels (NOT Address Labels) Los Excel Discussion (Misc queries) 2 May 4th 05 01:57 PM
Column format when merging Excel data to Word labels Red Excel Discussion (Misc queries) 1 April 6th 05 03:40 AM
Alignment of Multiple-Level Category Labels Not Possible? MCP Charts and Charting in Excel 1 March 26th 05 07:01 AM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"