hyperlink

[pierre]

hello all........

i have :

A B
1 x 20
2 - -


i would like to make a hyperlink in A1 (wich is "x" ) in order to lead me
to 20...BUT my primary goal is that i want to drag from A1 to A6 for
example... and like that i ever click the hyperlink cell A2 i get its result
in cell B2 and so forth....

any suggestions ?

 

[Sheeloo]

You need a couple of helper columns
Copy Col A to (say) Col G
Enter this in H1
=[Book1.xls]B1
replace Book1 by your workbook name and copy down till the last row in your
data set
Enter this in A1
=HYPERLINK(H1,G1)
and copy down till the last row in your data set