Dynamic reference list of sheet in Excel workbook

[jaco3616]

Hi guys,

I hope that you can help me:

I have an Excel sheet with a lot of different sheets (+60 at the moment). In the sheet I would like an easy way of navigating between the different sheet without having to go through all the sheets everytime.

I would like to have an "index-sheet" where all the sheet listed dynamically (so new sheets are added automatically) where there a links to cell A1 in every tab, so that by clicking the sheet name I'm taken to the sheet.

Do you have any ideas on how to solve this, without having to add every sheet manually?

Thanks a lot for your help!

[dominicb]

Good morning jaco3616

Before you start getting a bad reputation, and people start ignoring your posts, you might like to revisit your first post, here : https://www.excelforum.com/excel-pro...ml#post4731390

Forum Expert mehmetcik has provided you with a solution that you have not acknowledged. Please take a moment to respond to this post. If the solution is suitable to your needs, please mark it as solved.

DominicB

[MickG]

Right click page arrows (bottom left on screen) for page Index selection list.

[SjonR]

run this while on the index tab. Rename the red part to the name of the index sheet.

Please Login or Register  to view this content.

[nigelog]

Attached is a menu listing (userform) that I like to use to navigate sheets or open workbooks, might help you

Please Login or Register  to view this content.

[jaco3616]

Thanks alot SjonR, just what I was looking for

Is it possible to have list start printing at cell A10 (for example)? At the moment it's printing from cell A2.

Thanks for your help!

[nigelog]

Please Login or Register  to view this content.

didnt spot that, if you change above sub to this you can activate any worksheet from the listbox listing

[SjonR]

Thanks alot SjonR, just what I was looking for

Is it possible to have list start printing at cell A10 (for example)? At the moment it's printing from cell A2.

Thanks for your help!

It starts at the first empty row, so if you enter something in A9 ( for example "Sheets") then it will start in A10.