VBA help - copy lines n times based on input

[stjuch]

Hi all,

I'm pretty new to VBA and was wondering if it is possible to create a macro that copies part of a row n times (depending on cell value) to another sheet in the workbook?

Specifically, in attached dummy file I need to copy the data for each row in column A:W in sheet "Model Mapping" n times based number written in sheet "Input" column B and paste it into sheet "Lines" column I:AE

For example, if input in sheet "Input" is 10 in cell B3, I need 10 lines of the corresponding data related to cell A3 inserted in sheet "Lines".

https://easyupload.io/vl1ymr

Is it possible and can something guide me in the right direction?

Thanks a lot.

/stjuch

 

[stjuch]

Thanks so much for your help again!

 

[mumps]

My pleasure.