How to transfer data to different sheets?

pinepienaar 

For a single cell:

Select the cell on the other sheet where you want the formula.

Type =

Click on the sheet tab of the sheet with the data.

Click on the cell with the value that you want to use (for example a total).

You should now see something similar to =DataSheet!D10 in the formula bar.

Press Enter or click the check mark to the left of the formula in the formula bar.

For a multi-cell range:

Select a range on the data sheet.

Click the Copy button on the Home tab of the ribbon, or press Ctrl+C.

Activate the other sheet.

Select the top left cell of the range where you want a copy of the data.

Click on the lower half of the Paste button on the Home tab of the ribbon.

Select Paste Link under Other Paste Options.