I am looking for a function or proceedure to link cell and its contents in a
worksheet?. For example:
in Sheet1 :
A1=blank
B1=Mango
B2=apple
B3=50
B4=XYZ
I want to hyperlink cells B1 to B4 to Cell A1.When I select B1,cursor should
move to cell A1 with value 'Mango',and if I select B3, cell A1 should
display 50.
Any body from this forum suggest me a function !!!