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

%3CLINGO-SUB%20id%3D%22lingo-sub-1639648%22%20slang%3D%22en-US%22%3Elinking%20two%20spreadsheets%20together%20to%20get%20the%20totals%20in%20cells%20to%20appear%20in%20a%20second%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639648%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20three%20spreadsheets%20in%20one%20workbook%20and%20I%20am%20trying%20to%20link%20totals%20from%20one%20of%20the%20spreadsheets%20into%20another%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20any%20one%20know%20how%20to%20do%20this%20task%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1639648%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1639772%22%20slang%3D%22en-US%22%3ERE%3A%20linking%20two%20spreadsheets%20together%20to%20get%20the%20totals%20in%20cells%20to%20appear%20in%20a%20second%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639772%22%20slang%3D%22en-US%22%3EYou%20can%20link%20a%20cell%20directly%20to%20the%20value%20of%20another%20cell%20(including%20in%20a%20different%20sheet%20or%20workbook)%20by%20simply%20selecting%20the%20destination%20cell%2C%20typing%20the%20equals%20sign%20(%3D)%20then%20navigating%20to%20and%20selecting%20the%20source%20cell%20you%20wish%20to%20mirror%20and%20hitting%20enter.%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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.
Highlighted

@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.

Highlighted