Ask Different Asked by Bori Woulds on November 23, 2021
I wonder if it’s possible to link tables from different spreadsheets.
I have several live projects running at the same time, for each I have a "Project finance" sheet, in which I have different tabs (Labour cost, Material cost, Project summary).
I would like to create a SUMMARY sheet with all my project, where I can link/mirror copy the project summary tables from all my projects. This needs to be "live", i.e. as we make changes in the project finance sheets (as the projects progress), on this summary table it would update automatically.
In Google sheet this is the formula I would use, but I only recently started using Numbers and I couldn’t find anything similar in there.
=importrange("https://docs.google.com/spreadsheets/d/138XdwtZoMVsdMwJOzT4R8Zzg2NNc9pxTV-ARDPvHoj8/edit#gid=63426406","Customer finance!A1:N100")
You can basically create a "live carbon copy" this way.
Any help would be greatly appreciated.
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP