I have a spreadsheet with up to 50,000 rows. Data spans from A1:BP50000
Each row has a value in column "E"
I would like each row to be duplicated X times ---> X = value in column "E"
If one row has a value of 5 in column "E", duplicate that row 5 times
If another row has a value of 2 in column "E", duplicate that row 2 times
If a row has a value of 0, do not duplicate OR do nothing
Can this be done through VBA?
Thanks for the help
Each row has a value in column "E"
I would like each row to be duplicated X times ---> X = value in column "E"
If one row has a value of 5 in column "E", duplicate that row 5 times
If another row has a value of 2 in column "E", duplicate that row 2 times
If a row has a value of 0, do not duplicate OR do nothing
Can this be done through VBA?
Thanks for the help