Macro multiply rows and copy exact same data from original row

Hello,

I really hope someone can help me.

Please, if you can supply with a macro that can multiply each row with the exact same data from original row. It has to be a specific number of rows, number declared in column M.

I attached the file. In sheet #2, I set an example(for first row) on how it needs to look like.

Thank you in advance!

This can do

Please Login or Register  to view this content.

Kind regards
Leo

Thank you very much, Leo! It worked flawlessly.