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

Question

I have three spreadsheets in one workbook and I am trying to link totals from one of the spreadsheets into another spreadsheet.&nbsp;Does any one know how to do this task?

charla74 · Answer

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.

chip_wall · Answer

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

charla74 · Answer

Glad to help!

Forum Discussion

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

3 Replies

Resources