redirecting hyperlink based on the cell value

[rinijg]

Hi, Can some one tell me how to redirect a hyperlink based on the value of cell??

 

[Andrew Poulsom]

I'm not sure what you mean, but maybe you can use the HYPERLINK function. You can use cell references as its arguments.

 

[rinijg]

This is my actual problem
I have a workbook named Search in which there is a worksheet named Find_Result. A1-"Search Results", A2 to the cells down have the search results. These search results are the name of the worksheets of another workbook named Database. The search results vary each time and some time there might be only one search resul, that is, only A2 will have the name of the worksheet. Sometimes there might be many search results.
When i click on the cell, i want it to open that particular worksheet from the workbook Database.

Can you help me in writing a code for that?

 

[Andrew Poulsom]

Have you tried recording a macro while entering such a hyperlink manually?

 

[rinijg]

Yeah I tried, But it was not recorded. I dont know why. But now I got how to do that. Got through another thread in Mr. Excel