macro to repeat all rows cell acording to specific value

[ispyhope]

Hey,

Can you please tell me a formula or macro to repeat the contents of a row depending on a cell value.

I need the whole row to repeat as many times as the "Qty" Column.

for eg. - if qty is 1 then the row appears only 1 time
if qty is 3 then the same row repeats three times.
sample.xlsx

[taps]

Hi,

See the attached file. It is working fine in my system. Let us know how it works.

If it is working fine then mark the thread as SOLVED.


Regards

taps

[mike7952]

Hello ispyhope,

Give this a try. Should produce 101 rows which is the sum of your Qty.

Please Login or Register  to view this content.

[ispyhope]

@taps and mike - First of all thank you so much for the solutions.

In both cases I need to add many more rows of data. I had only sent in a sample file. Total no. of rows - 1141. In that case what do I need to do?
@taps - I tried adding all the new rows and clicking on the Run Macro button, but that appears to be a picture.
@mike - Erro says "Subscript out of range"

Thanks again for your help. Would appreciate the response to this as well.

[mike7952]

Whats the name of the sheet that your data is on? If its not sheet1 then change this

Please Login or Register  to view this content.

[ispyhope]

Awesome.. Thank you