Question: how to transfer certain data from one spreadsheet to another in excel?
Answer: Highlight the cell or group of cells you want to copy to the other workbook, and then select "Copy" from the Clipboard group on the Home tab.
Choose the worksheet you want to copy the data to, and then select where you want the data to appear.