Open the workbook, then on the View tab, choose New Window. You will then have two independent windows open on the same workbook and you can copy paste etc between them. Make sure to close one of them before saving the workbook or it will open up again with two windows (unless that's what you want).