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