Ask a question »

Excel - Transfer data between several sheets

July 2015

Data can be transferred between several Excel worksheets manually as well as automatically. If the Excel worksheet contains a small number of records, a manual operation to transfer data between several sheets can be done. However, for databases that contain a large amount of data, manual operation needs to be kept to a minimum. To copy data from one database to another, a few key presses and toggling between the worksheets are required. Manual transfer of data between several sheets in Excel is feasible for small data such as attendance sheets of a class. The keys may vary for newer versions of the Excel office software or for Visio.

Excel - Transfer data between several sheets



Issue


Transfer data between sheets under Excel:
  • This involves an attendance sheet. A tab for each month with columns for weekly attendance, a total for the month and a summary tab containing the students' names and the monthly totals.
  • I would like to transfer students' names and the monthly totals associated with each name to a summary sheet.

Solution


Open both spreadsheets. In the spreadsheet where you want the information to appear click on that cell and enter the equal sign. Then go to the Windows tab and choose the other spreadsheet. Click on the cell that you want to import the information from. Then hit enter.
  • This should work. If you are using a new version of Office or Visio the tab may be titled differently.


Thanks to barbie0976 for this tip on the forum.
For unlimited offline reading, you can download this article for free in PDF format:
Excel-transfer-data-between-several-sheets.pdf

See also

In the same category

Published by aakai1056. - Latest update by aquarelle
This document entitled « Excel - Transfer data between several sheets » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.