a sort of dashboard

[hitch_hiker]

I wonder if it is possible to have similar to a dashboard or menu, where I have a list of sheets to choose from ( it might be as many as 30 ) when I click on the sheet name it takes me to the sheet instead of needing to scroll along to find the sheet I need. The sheets are very low data, a few simple calculations and only take one screen to display.

 

[Saba Sabaratnam]

Hi Hitch Hiker,

You can create a summary sheet and link all other sheets by using Hyperlink. To do this, right click on a cell, select Hyperlink, then select 'Place in this Document Option' on Insert Hyperlink dialog box and then select the sheet you want to have hyperlink.

You can also link back to the summary sheet from other sheets by using the same process for easy navigation.

Kind regards

Saba

 

[Trebor76]

Hi hitch_hiker,

If you right click at the bottom left-hand corner of any tab you are presented with a list of all visible sheets in the workbook which you can select and click OK to go to the desired tab.

Robert

 

[hitch_hiker]

Thanks Saba,
That was what I was thinking off, but I didn't know how, then I saw Robert's post
Thanks Robert,
perfect with many thanks, just made my life infinitely easier

 

[Trebor76]

You're welcome. No need to reinvent the wheel

 

[Saba Sabaratnam]

No problem