|
Posted to microsoft.public.excel.misc
|
|
|
list and hyperlink
http://pmexcelent.dk/Tanya.xls
"Tanya" skrev:
Hi, I would like on the selection from a validation list to go to a
particular cell on another sheet [the same cell reference of each sheet for
each value in the list] is this possible.
Example
validation list would contain a list of student names -
Smith, Henry
Duck, Donald
Rabbit, Roger
Result-
Smith, Henry [hyperlink to C2 on sheet S1]
Duck, Rabbit [hyperlink to C2 on sheet S2]
Note: S1 and S2 are sheet names referring in brief to student 1, 2 and so on.
I hope this makes sense. I don't expect hyperlink will be the way to solve
this, perhaps a macro? or a vlookup?
Thanking you in advance.
Tanya
|