Reference or access a cell in another worksheet

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
Home

How to reference or access a cell in another worksheet:
1. If the sheet name is simple like 'income' then you can access the cells in this worksheet
by writing =income!CellAddress
2. If the worksheet name consisits of multiple words with spaces like 'Profit And Loss' then you must enclose the name in single quotes like 'Profit And Tax' followed by an exclamation mark and then the cell address ='Profit And Loss'!CellAddress to access the cell.





Reference

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010