How to Copy Data from One Worksheet to Another in the Same Workbook
- 1). Open your worksheet, and select the cells you want to copy to another location.
- 2). Press the "Ctrl" and "C" keys simultaneously to copy the data.
- 3). Click the worksheet tab where you would like to transfer the data.
- 4). Click on the cell where you would like to import the data.
- 5). Press the "Ctrl" and "V" keys simultaneously to paste the data.
Source...