Can I reference a value in one spreadsheet in another spreadsheet?

Yes, as long as both spreadsheets are in the same document. In order to reference a cell in another spreadsheet, type “=SheetName!A1”. 

Please note: If the sheet name you are referencing includes more than one word, you must bracket the sheet name in set of single quotation marks.  

    ex: to reference the cell B27 in the Sheet Monthly Estimates, enter: 

            ='Monthly Estimates'!B27

Was this article helpful?
4 out of 6 found this helpful