Loop copy and paste range to different sheets.

Hello friends, hope all is well!

please help create a VB Loop code that will copy A1:D10 to a new sheet.

the attachment here already has a loop code that copies each cell of E2:E5 to cell D5.
So in the end we should have 4 new sheets copied and pasted values.

Thank you so much in advance.

Maybe:

Please Login or Register  to view this content.