55. Reference Data Outside This Sheet
42 Enter Simple Data into a Spreadsheet 46 Edit Cell Data 64 Conditionally Format Data If all your data resided in the current sheet, referencing other cells would be simple. You'd only need to know the other cell's address, such as D4. What if the cell is in another sheet inside the current spreadsheet? If Sheet1 needs to reference cell G6 in a sheet named Sheet3, you cannot use the simple G6 reference.
[View full size image]

Use the following pattern:
That's quite a mouthful! Here is one such example:
='http://www.YourDomain.com/Spreadsheet.sxc'#Sheet1.Cell
='http://www.simplerenthouses.com/corporate.sxc'#Division1.W11