LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JDellenger
 
Posts: n/a
Default Different quantities of a certain item...

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
sort bar chart in excel BuriedInSpreadSheets Charts and Charting in Excel 6 May 31st 07 04:12 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 10th 05 11:37 PM
PivotTable toolbar, Formulas, Calculated Item Jacob Excel Discussion (Misc queries) 1 March 19th 05 01:15 PM
Item wise balance in Pivot Table Samad Excel Discussion (Misc queries) 0 January 8th 05 11:15 AM
Selecting an Item from a List and getting a different item to pop. Matt Excel Worksheet Functions 1 December 7th 04 02:37 PM


All times are GMT +1. The time now is 03:27 AM.

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

About Us

"It's about Microsoft Excel"