I need to copy and duplicate rows of from one sheet to another. The number of duplicate rows will depend on a value in one of the columns.
Very simply example:
Sheet1
ProdCode No_of_Cases
123456-1 5
456789-0 3
Becomes in Sheet2
ProdCode Case_No
123456-1 1
123456-1 2
123456-1 3
123456-1 4
123456-1 5
456789-0 1
456789-0 2
456789-0 3
Very simply example:
Sheet1
ProdCode No_of_Cases
123456-1 5
456789-0 3
Becomes in Sheet2
ProdCode Case_No
123456-1 1
123456-1 2
123456-1 3
123456-1 4
123456-1 5
456789-0 1
456789-0 2
456789-0 3