Hyperlink to same worksheet for different project

[maniknandi]

Dear Sir,

Greetings!

Kindly help us regarding hyperlink while selecting a project name in the worksheet it will open in other worksheet and show the details of that project.

Example :

We have a workbook which contain the name and detail of projects. In a worksheet, we can sort through formula top 5 performing projects and bottom 5. Now we want there would be a hyperlink against each project and when we click on it the details of that project show in another worksheet (each time it will show in the same sheet, because we do not prepared separate sheet for each project).

I would appreciate any help. Thanks.
Regards,Manik

 

[GraH - Guido]

maniknandi,
Can you upload a sample workbook please.
Do you mean it like this?

 

[maniknandi]

Attached please find the workbook...

 

[GraH - Guido]

But where are the details?

 

[maniknandi]

Details? I need a selection help, that when we click in a project in sheet1 it will select the same project name in the sheet2 from drop down list. Once it is selected then project details will show. project details will be extracted from the raw data which is in another sheet and that we can do. We cant do the selection part.

 

[Chief Ace]

Like What "Grah-Guido" was asking "Where are the details?" at least make a sample of what details suppose to show. Why do you need a drop down if you can hyperlink directly to the right project and with details. Hopefully this will help.

 

[GraH - Guido]

Manic, if I understand correctly, you need the exact opposite of what I made.
Not the drop down is the hyperlink to the details. But "more..." is the hyperlink to populate the drop down and navigate to the project sheet.
I believe you need to do that with a macro. And then the drop down does not serve any purpose if you ask me.

 

[maniknandi]

Exactly Sir... thank you so much for your help.
however, I am attaching my demo workbook..

 

[GraH - Guido]

Try...

 

[maniknandi]

Perfect Sir...Thanks a lot.