Forum Discussion
Linking cells/sheets from different workbooks
Not an Excel expert!
I have four workbooks of multiple sheets, each with a summary as the first sheet (drawing from other sheets)
I want to create a fifth workbook that is a summary of the summaries, drawing from each of the workbooks.
How can I do this in Excel 365 for Mac?
I have tried using copy/paste to bring in the summary sheets in full but the calculation results (from the source summaries) have not come across.
Resources online are referring to features I do not see on Mac version ("get and transform" etc.).
Any help appreciated.
6 Replies
rebeccap2021 Unfortunately, Power Query (aka Get & Transform) isn't available on Mac, but you can use direct cell links.
For example, with a source workbook open (one with data you want to link to), enter = in a cell in your destination workbook, switch to the source workbook, select the cell to link, and press enter. Excel will capture the file path/cell address for you. Note that it will return the link in Absolute form (=$A$1), so you'll want to remove the $'s, then you can copy/paste that formula wherever you want.
HTH
Smitty Smith thanks for this. Seems to be working, although I imagine it won't update if the source sheet is updated? Shame that the full functionality is not on the Mac version (hint?).
rebeccap2021 If both workbooks are open, then the values should update automatically. If they don't, you can always go to Data > Edit Links > Update.
