Extracting a row number from where a hyperlink was clicked

Hi guys

A little bit of help with this would be great, I'm tearing my hair out...

I've currently got a list of value in column B of a sheet... lets call it "Sheet 1"

I want to create a set of hyperlinks in column A of Sheet 1, that then changes a particular value in Sheet 2 to the value of the cell in column B of the same row as the hyperlink clicked in column A.

This would be easy if there was a small number of values in column B, as I could use a button for each one... However I have 1300 values so can hardly do a button for each!!

So far I'm thinking I need to have create an autofill of the hyperlink to that same address in sheet 2 for each cell in column A of sheet 1, and then using a macro with the Worksheet_FollowHyperlink(ByVal Target As Hyperlink) routine to extract the row which was clicked, the value in column B of that row, and then to use this as the new value for my target cell.

How would I go about extracting the row from which the hyperlink was clicked in?

Thanks in advance for any help!!

nobody?