I have a sheet in which almost every row needs to be copied to a new sheet, but a
variable number of times. Example (source sheet):
Qty Product# UPC
2 BCD673 0112345698
0 118 7894561563
125 SPE1937 02845356978
I'm looking for help with VBA code that would generate a list of product # with their respective UPC in a new sheet. Each record would be repeated (looped) according to the qty inputed in the "Qty required" column.
The code would be triggered by a button pressed in the sheet. The code would wipe the information previously stored in the "output" sheet
So the output list would look like this:
Product# UPC (titles)
BCD673 0112345698
BCD673 0112345698
SPE1937 02845356978
SPE1937 02845356978
SPE1937 02845356978
SPE1937 02845356978
...
Thanks in advance
Ian
Bookmarks