Google should add additional functionality to the Hyperlink function in spreadsheets to be able to link one cell on one spreadsheet, to another cell in another spreadsheet.
Jun 25, 2012 11:57 AM
Posted in group:
: Share an idea
: Desktop (specify browser/OS)
When you have one spreadsheet with multiple tabs on the bottom, you can easily have data on one tab appear on a different tab.
It would be awesome if Google would add a feature in the existing hyperlink function to where you could have data from one cell on one spreadsheet appear in a cell on a completely different spreadsheet.
I currently have an application where I have three large spreadsheets with many tabs each. Each spread sheet generates just one number. I have a forth spreadsheet that takes the one number generated from the three a fore mentioned spreadsheets and continues on with some additional number crunching. Currently, I have to hand copy the numbers form the three spreadsheets into the forth spreadsheet. Having these cells hyperlink'ed from one spreadsheet to another would be swanky!