One way is to copy and paste  via code

Another way is to use a refedit box with appropriate code

Best N10

Arrange the windows so you can see both worksheets (in separate workbooks if you
want), then drag and drop across the windows.