Forum Discussion
how to link to a different spreadsheet
I need to create a big data file and I am planning to have a summary worksheet out of the data worksheet. I'd like to create columns in the summary worksheet where the heading is the same name as eac...
I think you want to build each other-worksheet reference as a string (not surprisingly) and use the INDIRECT function to have it evaluated.
E.g., in worksheet Summary1, if cell B3 contains the other-worksheet name Data1, and you want cell B4 to contain a sum from column C in Data1, the formula in B4 might be:
=SUM( INDIRECT( B3 & "!C2:C91" ) )
I hope that helps.
E.g., in worksheet Summary1, if cell B3 contains the other-worksheet name Data1, and you want cell B4 to contain a sum from column C in Data1, the formula in B4 might be:
=SUM( INDIRECT( B3 & "!C2:C91" ) )
I hope that helps.