Select the cell you want to hyperlink to and give it a name (Insert - name)
and then you can hyperlink to it.

Mike

"Yasna" wrote:

I need to have a specific cell in Worksheet 'A' to reflect the contents of a
formulated call of another Worksheet 'B'.
E.G. Worksheet 'A'...(cell E4)...NEEDS TO DISPLAY THE NET % OF PROFIT
(WHICH IS A FORMULATED CELL) FROM Worksheet 'B' ...(cell O7)

Is this even possible? Will it display the contents in that cell or will it
only link to the Worksheet itself?

Thank you in advance!