Create Multiple Rows based on Cell Value by way of VBA

Good day everyone!

I have an assignment under which I am required to create multiple rows for the same row data based on the number mentioned in column J.

Let’s say if row 5 has 4 as the number in cell J5. I need to be able to copy that row data 4 times and so on and so forth

Attached sample has original data in Blue and Data Requested in Green. I need to make a fresh workbook. The data is just a representation of my requested harvest.

Please help me with a macro that can do this for me. I understand the limitation in terms of number of rows in excel but the data is or will be manageable.

Thank you very much!

But given the magnitude of data I would really request for a VBA as I want to create a new file everyday.

Thank you.

Check this one too..

Please Login or Register  to view this content.

AB33 and Deb - Thank you for your assistance. Both the things work well. It indeed was a very quick one...

AB33 - I'll go with the one you provided as it helps me get the data to another sheet.

A couple of things though:

1. On running the script the data gets updated in the Output sheet but the last row of the worksheet (sheet1) gets selected and asks me to select a cell and press enter. Why would this be happening?
2. Not necessary but if possible can I have the Output sheet created as a separate workbook ? If it is a lot of work I can do this by copy paste daily. But was just wondering so thought it best to check.

In any event - I am glad with the response and help. Thanks to you both. Perhaps another lesson learned to some extent can't say fully.

Fantastic and thank you once again.