CrazyMuster: Excel

I have a very big Google Spreadsheet where there are some 30 sheets. Now I want to mantain links to each and every sheet on first sheet. So when I click on a link on the first sheet it should open a specific sheet.

Putting a Hyperlink will open the sheet in New Broswer Tab.

In Order to accomplish this follow the below steps.

Here is my sample sheet

Now I want to add a link on 'Index' sheet which when clicked should take me to the desired sheet.

Step 1 :

Goto Insert --> Drawing

Step 2 :

Type 2 , Resize it and click save and close

Position it properly on the sheet

Step 3:

Now click on 2 - you will see an arrow, click on it and select 'Assign Script'

Now type 'GotoSheet2' and click OK

Step 4:

Goto Tools --> Script Editor. If you see the below screen click 'Spreadsheet'. A script page is opened.

In the script window add the below code at the last line

function goToSheet(sheetName) {
  var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
  SpreadsheetApp.setActiveSheet(sheet);
}

Once the above function is added now add your function 'GotoSheet2' assigned above and click Save

function GotoSheet2(){
  goToSheet('Sheet2');
}

The final code snippet looks as follows.

Repeat the above process for each and every link.

function goToSheet(sheetName) {
  var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
  SpreadsheetApp.setActiveSheet(sheet);
}

function GotoSheet2(){
  goToSheet('Sheet2');
} 

function GotoSheet3(){
  goToSheet('Sheet3');
} 

function GotoSheet4(){
  goToSheet('Sheet4');
}

Here is the public link for the example project

https://docs.google.com/spreadsheets/d/19RZJkPWNQcgzlRYlkO9Z-UPaR9y6-h0NkXbhyZ6TmeA/edit?usp=sharing

CrazyMuster

Google spreadsheet Hyperlink to a specific sheet in the same spreadsheet

Microsoft Excel Not Updating formulas automatically