Home > IT Answers > Microsoft Windows > Excel cell referencing across worksheets
Ianh
5 pts.
 Excel cell referencing across worksheets
Excel 2003, Microsoft Excel
In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003. Any suggestions?

Software/Hardware used:
ASKED: February 18, 2008  6:18 AM
UPDATED: February 18, 2008  4:39 PM
RELATED QUESTIONS
Answer Wiki:
That feature is still there. The syntax is "=Sheet2!B4". In this case I'm referencing the value on Sheet2 in the cell B4.
Last Wiki Answer Submitted:  February 18, 2008  7:35 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _