linking two spreadsheets together to get the totals in cells to appear in a second spreadsheet

Copper Contributor

I have three spreadsheets in one workbook and I am trying to link totals from one of the spreadsheets into another spreadsheet.

 

Does any one know how to do this task?

3 Replies
You can link a cell directly to the value of another cell (including in a different sheet or workbook) by simply selecting the destination cell, typing the equals sign (=) then navigating to and selecting the source cell you wish to mirror and hitting enter.

@Charla74 

 

I tried your solution and it worked very well.  Thanks for your help.  I have been struggling to find that answer for many months now and was very pleased that someone could help me so quickly.