Create a Custom Menu to link another sheet In google sheet Create a custom menu and link to another sheet by using the app script editor. For Custom menu items use simple trigger function, which is onOpen() . To update onOpen() and add new menu items in the menu bar do the following. · In the menu bar click on tools - > script editor add following script . · You can add your desired menu item name as per your requirement. · Change the Menu name as per your requirement (i.e.; ‘My Data’ ‘Progress-Report’, ‘Sales’. ‘Max’, ‘Rocky’) function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu('MyData') .addItem('Progress-report', 'menu1') .addSeparator() .addSubMenu(ui.createMen...