how do i link from one sheet to another in the same workbook?

S

savita

I want to link one cell in sheet 1 to another cell in sheet 2.
According to Office Help this can be done by using the formula HYPERLINK.
But if I use the formula as described, I cannot jump from the cell in sheet 1
to the corrsponding cell in sheet 2.

Help anyone?
 
S

Syd

I have a workbook that I have done this with in an easier manner. I have
several sheets that have totals on them and I want to transfer the totals to
my monthly budget report. I do this by right clicking on the cell in each
individual sheet I want transferred to my budget sheet and click copy. I go
to my budget sheet and right click on the cell that I want the information
linked to and I click paste. There is a little box to the right hand side of
the cell that I pasted the information into. I click on that and it has a
drop down menu. I choose the link cells option and they are linked.

I hope this helps you.
 
Top