How To Build Buttons in Google Sheets

Here is the Script that you'll need:

function ph() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Data Interpretation", 47, 1);
}

function goToSheet(sheetName, row, col) {
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

Видео How To Build Buttons in Google Sheets канала Kenneth Revoy