How to make cells/text clickable to redirect into other worksheets

[marcelkahn5]

Hi Excel Forum!

I'm trying to bypass macros and allow users to click on text which would then redirect users into another worksheet (Similar to Itunes). Attached is my basic spreadsheet. I really appreciate all your assistance! You're all the best!

Also, how do I create a system that allows users to redirect to the main page or any other page once they are in a specific worksheet?

THANK YOU!

-MK

[tuph]

On the Main Page, click in cell A2 and add a hyperlink using the Bookmark option that points to the Projects worksheet. Repeat this process in cell A4, A6 and A8.

To return to the main page, on each worksheet create a cell called "Main" and insert a hyperlink to the Main worksheet.

I have attached a sample to get you started.

[marcelkahn5]

Thanks Tuph! Is there any way we can make a dashboard like Itunes: So ideally there would be a column for selection options and everything on the right would change based on the selection in that same worksheet.