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! |