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