{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["InputData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"InputData","index":0,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,4,0,7],[0,8,0,9],[2,0,2,9],[2,11,2,15]]}
[null,null,null,null,"Tanggal Olah Data :",null,null,null,"2013-06-01"]
[]
["Tabel A.  Raw Data",null,null,null,null,null,null,null,null,null,null,"Tabel B. Isikan Kolom Nominal ke dlm Tabel A"]
[]
["nama","kat","tgl","ofs1","ofs2","ofs3","ofs4","ofs5","bln","pilih",null,"nama","kat","baris","kolom","Nominal",null,"Penjelasan Sel Tujuan di Tabel A"]
["alfa","A","2013-03-01",null,null,null,10,null,{"$f":"(YEAR($I$1)-YEAR(C6))*12+MONTH($I$1)-MONTH(C6)+1","v":4},{"$f":"IF(AND(I6>0,I6<=5),1,0)","v":1},null,"alfa","A",{"$f":"MATCH(L6&M6,$A$6:$A$13&$B$6:$B$13,0)+5","v":6},{"$f":"INDEX($I$6:$I$13,MATCH(L6&M6,$A$6:$A$13&$B$6:$B$13,0))+3","v":7},10,null,"Isilah sel (6,7) dengan nominal 10"]
["beta","A","2012-02-01",null,null,null,null,null,{"$f":"(YEAR($I$1)-YEAR(C7))*12+MONTH($I$1)-MONTH(C7)+1","v":17},{"$f":"IF(AND(I7>0,I7<=5),1,0)","v":0},null,"alfa","B",{"$f":"MATCH(L7&M7,$A$6:$A$13&$B$6:$B$13,0)+5","v":9},{"$f":"INDEX($I$6:$I$13,MATCH(L7&M7,$A$6:$A$13&$B$6:$B$13,0))+3","v":5},20,null,"Isilah sel (9,5) dengan nominal 20"]
["charlie","A","2012-03-01",null,null,null,null,null,{"$f":"(YEAR($I$1)-YEAR(C8))*12+MONTH($I$1)-MONTH(C8)+1","v":16},{"$f":"IF(AND(I8>0,I8<=5),1,0)","v":0},null,"charlie","B",{"$f":"MATCH(L8&M8,$A$6:$A$13&$B$6:$B$13,0)+5","v":11},{"$f":"INDEX($I$6:$I$13,MATCH(L8&M8,$A$6:$A$13&$B$6:$B$13,0))+3","v":4},30,null,"dst"]
["alfa","B","2013-05-01",null,20,null,null,null,{"$f":"(YEAR($I$1)-YEAR(C9))*12+MONTH($I$1)-MONTH(C9)+1","v":2},{"$f":"IF(AND(I9>0,I9<=5),1,0)","v":1},null,"delta","B",{"$f":"MATCH(L9&M9,$A$6:$A$13&$B$6:$B$13,0)+5","v":12},{"$f":"INDEX($I$6:$I$13,MATCH(L9&M9,$A$6:$A$13&$B$6:$B$13,0))+3","v":6},40,null,"dst"]
["beta","B","2012-05-01",null,null,null,null,null,{"$f":"(YEAR($I$1)-YEAR(C10))*12+MONTH($I$1)-MONTH(C10)+1","v":14},{"$f":"IF(AND(I10>0,I10<=5),1,0)","v":0}]
["charlie","B","2013-06-01",30,null,null,null,null,{"$f":"(YEAR($I$1)-YEAR(C11))*12+MONTH($I$1)-MONTH(C11)+1","v":1},{"$f":"IF(AND(I11>0,I11<=5),1,0)","v":1}]
["delta","B","2013-04-01",null,null,40,null,null,{"$f":"(YEAR($I$1)-YEAR(C12))*12+MONTH($I$1)-MONTH(C12)+1","v":3},{"$f":"IF(AND(I12>0,I12<=5),1,0)","v":1}]
["echo","A","2012-09-01",null,null,null,null,null,{"$f":"(YEAR($I$1)-YEAR(C13))*12+MONTH($I$1)-MONTH(C13)+1","v":10},{"$f":"IF(AND(I13>0,I13<=5),1,0)","v":0}]
[]
[]
["Yth. Para pakar dan rekan2 excellers..."]
["Maaf terlalu sering bertanya..."]
[]
["Mohon dibantu melengkapi script VBA di Module 1 (Sub InputData), agar kolom Nominal di Tabel B Diinput ke Tabel A.  Loop kah??"]
["Yang diinputkan hanya kolom Nominal saja, dan alamat sel tujuan (baris dan kolom)-nya sudah tertera di Tabel B."]
[]
["Btw, sekalian mohon dibantu merevisi script di Sub SelectRange_Susah2Gampang untuk mengkopi hanya Kolom 1 dan 9 saja."]
["Kode yang sudah saya tulis tsb ketika dieksekusi hasilnya malah mengkopi kolom 1 s/d 9."]
[]
["Mohon dibantu, terima kasih sebelumnya."]
[]
["Wassalam"]
["Imam Sinurat"]