Follow hyperlink

Dear All,

I have many hyperlinks in my activesheet. With every hyperlink cell on left adjecent cell, i have a text which i want to copy to destination let say cell A1.

When ever someone click on the hyperlink, macro should copy value on left side of hyperlinked cell (may by using offset(0,-1)) and paste in the target destination.

I would really appreciate your help.

Thks

Nazim

I wanted to use below code

Please Login or Register  to view this content.

The destination is also in the same workbook. I have already hyperlinked all cell, what i want to do here is to take text which is inputed in left column of hyperlinked cell to the destination. All the hyperlinked cells are in Sheet1 and all destination cells are in sheet2.

Thks

Nazim

sorry for not making it clear

I want to use hyperlink is there any other method.