[HELP] How to Make Navigation GUI

[jamzsaludares]

Hi There,

Its me again seeking for help, and want to learn more about excel.

I am created Financial Worksheets. . . ex. Balance Sheet, Income Statement, Cash Flows, Notes, Forecasted Sales Etc.
and I want to make a GUI in-order to navigate easily. I already included Hyper Links to it for some detailed annexes.

Please Help me with this.

Thank You.

[FDibbins]

If you already have hyperlinks to some places, why not create a "navigation" sheet and include a few more there?

[jamzsaludares]

Can you recommend me some king of a button?

[FDibbins]

On a new sheet, select Formula Tab/Name Manager, click New and call it Sheetnames
Refers to: =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
click OK

In A2, copy this down...
=IFERROR(HYPERLINK("#"&"'"&INDEX(Sheetnames,ROWS($A$2:A2))&"'!A1",INDEX(Sheetnames,ROWS($A$2:A2))),"")

This will create a list of all sheets (it will updata as you add new sheets), and will add a hyperlink to each cell, pointing to A1 on taht sheet name. Change the bolded part (A1) if you want it to point to a different cell

[jamzsaludares]

Tnx. Ill keep this one.