Dashboard Hyperlinks

[jei eusebio]

Hi Ninjas,

I currently have a dashboard with 4 sheets in it then I created another sheet (Main Sheet) with hyperlinks on the left side, what I want to is that when I click on the hyperlinks, cell range A3:A50-DH3:DH50 would show up on the Main sheet starting from cell G3. One thing i did is I also hid column E onwards so that it only shows column A-D of the Main sheet with the hyperlinks.

Thanks in advance!

 

[Luke M]

when I click on the hyperlinks, cell range A3:A50-DH3:DH50 would show up on the Main sheet starting from cell G3.

I'm afraid I don't know what that statement means.

 

[jei eusebio]

Hi Luke,

A3-DH50 is the range of data in one of the sheets that I would like to show in the main sheet when I click on the hyperlink. :D

 

[Luke M]

The closest I can think of to that is using a Linked Picture image. To do the hyperlinks would require some VB, but it we go with a dropdown, it's pretty easy.

The CHOOSE function lets you state a number >=1, and give choices. We can list ranges as our choices. So, if we do:
=CHOOSE(2,Sheet1!A1:C10,Sheet2!A1:C10,Sheet3!A1:C10)
it would choose the 2nd range, on Sheet 2.

The attached has a full working example, with the dropdown, linked image, and a named range called "myPic" which figures out which range to show in the image.

BTW, not sure how you are going to show columns A:DH. That's a lot of columns...how will they fit on one screen?

 

[jei eusebio]

Hi Luke,

Thanks a lot! i think i'll split the sections that I want to display since not all the data will fit on my screen. But so far I think this will be enough, the main reason for this is to find a better way of showing them the data when I give them updates! Thanks again sir!