Hi,
I need to create duplicate rows in excel for a mail merge in order to print differing number of documents for each row in excel. The table has a certain number of rows (say 100) of unique data. In each row there is a list of addresses that will get a letter. The table has a column called "Count" that has the # of addresses to count the number of documents I need to send for that row of data. To simplify, its something like this:
Headers: Key No. $$ amount Count
Row 1: 71-55 $1000 2
Row 2: 82-66 $4000 3
Row 3: 90-56 $2650 9
So, I need to duplicate row 1 an additional time, row 2 two additional times, and row 3 8 additional times. Or, alternatively if its easier, I need to create a new worksheet that has row 1 two times, row 2 three times, and row 3 nine times. It doesn't really matter what order the duplication is in as I can do a quick sort by key number to put them in the order I need for the mail merge. Duplicating in a new spreadsheet would be ideal.
Because there may be 100 rows and over 500 duplications, I need an automated solution for this. If there is a way to do this in Word where word can read the insert Count in the upper right hand corner and print that number of that document that is also a solution but I think the excel solution would be easiest.
Any help would be much appreciated. Email me at geoff@geoffreypolk.com if you have ideas or need more information on what I'm trying to do here.
Thanks!
Geoff
I need to create duplicate rows in excel for a mail merge in order to print differing number of documents for each row in excel. The table has a certain number of rows (say 100) of unique data. In each row there is a list of addresses that will get a letter. The table has a column called "Count" that has the # of addresses to count the number of documents I need to send for that row of data. To simplify, its something like this:
Headers: Key No. $$ amount Count
Row 1: 71-55 $1000 2
Row 2: 82-66 $4000 3
Row 3: 90-56 $2650 9
So, I need to duplicate row 1 an additional time, row 2 two additional times, and row 3 8 additional times. Or, alternatively if its easier, I need to create a new worksheet that has row 1 two times, row 2 three times, and row 3 nine times. It doesn't really matter what order the duplication is in as I can do a quick sort by key number to put them in the order I need for the mail merge. Duplicating in a new spreadsheet would be ideal.
Because there may be 100 rows and over 500 duplications, I need an automated solution for this. If there is a way to do this in Word where word can read the insert Count in the upper right hand corner and print that number of that document that is also a solution but I think the excel solution would be easiest.
Any help would be much appreciated. Email me at geoff@geoffreypolk.com if you have ideas or need more information on what I'm trying to do here.
Thanks!
Geoff