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...

How to Import data from another sheet in google spreadsheet?   In the target sheet, select the cell and use the following ‘IMPORT RANGE’ function. =IMPORTRANGE(spreadsheet_url, range_string) Open the spreadsheet in  the empty cell where you wish to import the data just enter the following formula : = IMPORTRANGE("paste sourcefile link here", "sheetname!B1:B10"  Copy the source file ‘URL’ (from the sheet you wish to import) and paste it in between the quote in the target sheet.   next, write a sheet name of the source file spreadsheet exactly the way it’s written.    Select the column which you would like to import in the source file. You receive an entire Column data in the target file where you wish to import. if you wish to import only the total amount of the column,    just add "Sum before the import range" in the formula as mentioned below.  =Sum(IMPORTRANGE(spreadsheet_url, range_string)) rest follow the same procedure as our ...

To create a button in google sheet and link to another sheet  through the script, just follow the below steps. First, open a google sheet, click on the main menu, Insert - Drawing Select a Shape and desired Button and drag and create button   Now, once button created click on the three dots on the top right of the button Click on Assign script (any desired letters)    Now go to tool - script editor and delete existing codes. and paste the following code :  function PC() {   var selection = SpreadsheetApp.getActiveSheet().getActiveCell().getValue();     var html = "<script>window.open(' paste url here');google.script.host.close();</script>";     var userInterface = HtmlService.createHtmlOutput(html);     SpreadsheetApp.getUi().showModalDialog(userInterface, 'Petty Cash'); } Make necessary changes as per your target sheet requirement.  For more details  watch the video: -