To create a simple link:
Select a cell in the second worksheet
Type an equal sign
Select the first sheet
Click on the cell that you want to link
Press the Enter key.
Alesha wrote:
Say i have one worksheet and on my second one I want to reference cells from
the first one? is there a formula for that?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html