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.
Bookmarks