I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines.
Some members receive more than one copy of the magazine, which will be indicated in one of the columns by a number (X). If X is higher than 1, I now have to manually copy that specific row X times and insert it into the worksheet.
Is there an easy way to automate this?
I'm thinking of letting a macro go through the column with numbers higher than 1 and automatically copy the rows X times. The order of the rows is not important, nor is the fact that it will obviously create duplicate rows.