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.createMenu('Sales')           .addItem('Max', 'menu2')           .addItem('Rocky', 'menu3'))       .addToUi();   } Once Menu created in the menu bar, assign Links f