|
|
#1
01-02-2018, 08:09 AM
|
|||
|
|||
creating multiple data rows, for labels based on a cell value
I have a need to produce multiple labels (probably via a mail merge (or something). my sticking point is that the number of labels will vary based on a cell value for the given row(i.e quantity)
I am assuming there is a way within a loop or some other method, but I am not finding such an example in my searches. currently, all of the data is in Excel-but could export to Access if a solution within Access is needed for more in-depth code Sample data below with some explanation item quantity # of labels needed( quantity*2) 101 1 2 102 5 10 
|
| Tags |
| adding multiple rows, mail merge, vba |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extracting multiple words from one cell into individual rows while copying all other data | randyaserve | Excel Programming | 4 | 10-05-2015 09:52 AM |
| Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
 Insert values from multiple rows based on value in one column
|
pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |
|
Creating formula based on if data is correct in cell
|
MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |
|
Hide Rows and Update Chart based on cell value
|
ubns | Excel Programming | 5 | 05-07-2012 05:44 AM |
Windows 10 
Office 2016
Threaded Mode