Google Sheets App Script - Menu Item Link Purchase Order # to Packing Slip # -

i having trouble wrapping mind around problem.

i have sheet customer purchase orders.

here dumbed down sheet example here: https://docs.google.com/spreadsheets/d/151h1xjb98nobno0otnaql3asjk84ccczz399dx4bmbm/edit?usp=sharing

i need way link packing slip # matching list of customer purchase order #'s on order sheet.

using sort of copy cell value "packing slip!g2" "orders!c:c" = "packing slip!g5" "orders!d:d"

do think feasible?

thank you.

been smashing around, trimmed out stuff mussing , leave here morning can make better sense.

    function linkpacknumtopo() { var activesheet = spreadsheetapp.getactive(); var ps = activesheet.getvalue("g2"); var po = activesheet.getvalue(g5); 

}

so can not figure out way similar operation vlookup using app script.

so thinking need write separate sheet single record each purchase order # being linked packing slip # and/or sales order # also.

i using following code copy date, company, purchase order, packing slip, sheet act key matching purchase orders packing slips.

also added clear contents reset packing slip, routine auto increment packing slip #, using l3 key value.

    function clearpackinglist() {       var ss = spreadsheetapp.getactive();       var sheet = ss.getsheetbyname("packslip");       var source = sheet.getrange("n3:q3");       var target = ss.getsheetbyname("orderkey");       var values = source.getvalues();       target.appendrow(values[0]);      sheet.getrange('c6').clearcontent();     sheet.getrange('c9').clearcontent();     sheet.getrange('c10').clearcontent();     sheet.getrange('b11').clearcontent();     sheet.getrange('b12').clearcontent();     sheet.getrange('h6:h8').clearcontent();     sheet.getrange('f11').clearcontent();     sheet.getrange('g11').clearcontent();     sheet.getrange('h14:h77').clearcontent();    var cell = sheet.getrange("l3");   var cellvalue = cell.getvalue();   cell.setvalue(cellvalue + 1);     }; 

i need add menu item next , figure out how write orders sheet matching purchase orders packing slip,

also working on figuring out how print range of cells.

okay have working 'kludge'

    function onopen() {   var ui = spreadsheetapp.getui();   // or documentapp or formapp.   ui.createmenu('custom menu')       .additem('submit packing list', 'menuitem1')       .addtoui(); }  function menuitem1() {   var ss = spreadsheetapp.getactive();   var sheet = ss.getsheetbyname("packslip");   var source = sheet.getrange("n3:q3");   var target = ss.getsheetbyname("pskey");   var values = source.getvalues();   target.appendrow(values[0]);      sheet.getrange('c6').clearcontent();     sheet.getrange('c9').clearcontent();     sheet.getrange('c10').clearcontent();     sheet.getrange('b11').clearcontent();     sheet.getrange('b12').clearcontent();     sheet.getrange('h6:h8').clearcontent();     sheet.getrange('f11').clearcontent();     sheet.getrange('g11').clearcontent();     sheet.getrange('h14:h77').clearcontent();   var cell = sheet.getrange("l3");   var cellvalue = cell.getvalue();   cell.setvalue(cellvalue + 1); }; 

it submits customer po , packing slip sheet key table.

i have create look-up table reference pskey (packing slip key table) return matching relationship has been shipped on customer's purchase order # , on back-order.

it have been nice find way write directly order table matching packing slip id customer purchase order id fail find way of doing using google app script, on head.