Re: Fw: Re: [belajar-excel] copas tidak berpindah ke baris selanjutnya
Bls: [belajar-excel] copas tidak berpindah ke baris selanjutnya
mohon maaf Mr.Kid masih awan tentang hal tersebut, skript yng saya tulis juga hasil dari googling trs saya coba, dan mentog disitu dengan baris yang sama, tidak mau berpindah ketika membuka file baru. file yang mau direkap lebih dari 1 file Mr.Kid namun barisnya sama. mohon pencerahan masalah saya, matur nuwun Pada Jumat, 5 Januari 2018 22:37, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" menulis: Silakan disesuaikan baris kode pengatur lokasi paste-nya. Regards, Kid 2018-01-05 18:54 GMT+07:00 Bos Kbrn bos.k...@yahoo.com [belajar-excel] : selamat malam para master, terima kasih Mr.Kid untuk postingan sebelumnya, terselesaikan masalahnya, saya ada kesulitan untuk memindahkan hasil copas dari file lain ke sheet rekap, setiap saya copas pasti mentok di cell A7 tidak berpindah ke baris berikutnya ketika file baru dipilih dan dilakukan copas, mohon penyelesaian dari permasalahn saya, matur nuwun. file terlampir #yiv8090526811 #yiv8090526811 -- #yiv8090526811ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8090526811 #yiv8090526811ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8090526811 #yiv8090526811ygrp-mkp #yiv8090526811hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8090526811 #yiv8090526811ygrp-mkp #yiv8090526811ads {margin-bottom:10px;}#yiv8090526811 #yiv8090526811ygrp-mkp .yiv8090526811ad {padding:0 0;}#yiv8090526811 #yiv8090526811ygrp-mkp .yiv8090526811ad p {margin:0;}#yiv8090526811 #yiv8090526811ygrp-mkp .yiv8090526811ad a {color:#ff;text-decoration:none;}#yiv8090526811 #yiv8090526811ygrp-sponsor #yiv8090526811ygrp-lc {font-family:Arial;}#yiv8090526811 #yiv8090526811ygrp-sponsor #yiv8090526811ygrp-lc #yiv8090526811hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8090526811 #yiv8090526811ygrp-sponsor #yiv8090526811ygrp-lc .yiv8090526811ad {margin-bottom:10px;padding:0 0;}#yiv8090526811 #yiv8090526811actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8090526811 #yiv8090526811activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8090526811 #yiv8090526811activity span {font-weight:700;}#yiv8090526811 #yiv8090526811activity span:first-child {text-transform:uppercase;}#yiv8090526811 #yiv8090526811activity span a {color:#5085b6;text-decoration:none;}#yiv8090526811 #yiv8090526811activity span span {color:#ff7900;}#yiv8090526811 #yiv8090526811activity span .yiv8090526811underline {text-decoration:underline;}#yiv8090526811 .yiv8090526811attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8090526811 .yiv8090526811attach div a {text-decoration:none;}#yiv8090526811 .yiv8090526811attach img {border:none;padding-right:5px;}#yiv8090526811 .yiv8090526811attach label {display:block;margin-bottom:5px;}#yiv8090526811 .yiv8090526811attach label a {text-decoration:none;}#yiv8090526811 blockquote {margin:0 0 0 4px;}#yiv8090526811 .yiv8090526811bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8090526811 .yiv8090526811bold a {text-decoration:none;}#yiv8090526811 dd...yiv8090526811last p a {font-family:Verdana;font-weight:700;}#yiv8090526811 dd.yiv8090526811last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8090526811 dd.yiv8090526811last p span.yiv8090526811yshortcuts {margin-right:0;}#yiv8090526811 div.yiv8090526811attach-table div div a {text-decoration:none;}#yiv8090526811 div.yiv8090526811attach-table {width:400px;}#yiv8090526811 div.yiv8090526811file-title a, #yiv8090526811 div.yiv8090526811file-title a:active, #yiv8090526811 div.yiv8090526811file-title a:hover, #yiv8090526811 div.yiv8090526811file-title a:visited {text-decoration:none;}#yiv8090526811 div.yiv8090526811photo-title a, #yiv8090526811 div.yiv8090526811photo-title a:active, #yiv8090526811 div.yiv8090526811photo-title a:hover, #yiv8090526811 div.yiv8090526811photo-title a:visited {text-decoration:none;}#yiv8090526811 div#yiv8090526811ygrp-mlmsg #yiv8090526811ygrp-msg p a span.yiv8090526811yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8090526811 .yiv8090526811green {color:#628c2a;}#yiv8090526811 .yiv8090526811MsoNormal {margin:0 0 0 0;}#yiv8090526811 o {font-size:0;}#yiv8090526811 #yiv8090526811photos div {float:left;width:72px;}#yiv8090526811 #yiv8090526811photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv8090526811 #yiv8090526811photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8090526811 #yiv8090526811reco-category {font-size:77%;}#yiv8090526811 #yiv8090526811reco-desc {font-size:77%;}#yiv8090526811 .yiv8090526811replbq {margin:4px;}#yiv8090526811 #yiv8090526811ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8090526811 #yiv8090526811ygrp-mlmsg {font-size:13
Re: Fw: Re: [belajar-excel] copas tidak berpindah ke baris selanjutnya
[belajar-excel] copas tidak berpindah ke baris selanjutnya
selamat malam para master, terima kasih Mr.Kid untuk postingan sebelumnya, terselesaikan masalahnya, saya ada kesulitan untuk memindahkan hasil copas dari file lain ke sheet rekap, setiap saya copas pasti mentok di cell A7 tidak berpindah ke baris berikutnya ketika file baru dipilih dan dilakukan copas, mohon penyelesaian dari permasalahn saya, matur nuwun. file terlampir Copas.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: [belajar-excel] memunculkan uraian dibawah kode rekening
Re: [belajar-excel] memunculkan uraian dibawah kode rekening
Bls: [belajar-excel] memunculkan uraian dibawah kode rekening
matur nuwun Mr.Kid atas pencerahannya, namun permasalahan di tempat saya tidak diperbolehkan memakai pivot, jika dipakai rumus apakah harus memakai array untuk mengurutkan per levelnya, mohon maaf Mr.Kid, matur nuwun. Pada Kamis, 21 Desember 2017 0:28, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" menulis: Hai Kbrn, Dengan menyusun tabel referensi hirarki berorientasi horisontal, maka fitur Excel Pivot Table bisa dimanfaatkan untuk membentuk layout isi output. Perangkat layout selain isi bisa diatur kemudian. File terlampir. Regards, Kid 2017-12-20 22:29 GMT+07:00 Bos Kbrn bos.k...@yahoo.com [belajar-excel] : Selamat malam master belajar excel, mohon ijin bertanya, bagaimana cara menampilkan deskripsi uraian belanja dibawah kode rekening sesuai dengan urutan kode di sheet Kode Rekening yang ditambilkan di sheet RKA? Contoh hasil yang diharapkan ada di sheet yg diharapkan, mohon maaf bila bertanya dengan teme sejenis yang telah dijelaskan namun saya benar2 tidak tahu, terima kasih atas bantuannya. #yiv8790621556 #yiv8790621556 -- #yiv8790621556ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8790621556 #yiv8790621556ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8790621556 #yiv8790621556ygrp-mkp #yiv8790621556hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8790621556 #yiv8790621556ygrp-mkp #yiv8790621556ads {margin-bottom:10px;}#yiv8790621556 #yiv8790621556ygrp-mkp .yiv8790621556ad {padding:0 0;}#yiv8790621556 #yiv8790621556ygrp-mkp .yiv8790621556ad p {margin:0;}#yiv8790621556 #yiv8790621556ygrp-mkp .yiv8790621556ad a {color:#ff;text-decoration:none;}#yiv8790621556 #yiv8790621556ygrp-sponsor #yiv8790621556ygrp-lc {font-family:Arial;}#yiv8790621556 #yiv8790621556ygrp-sponsor #yiv8790621556ygrp-lc #yiv8790621556hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8790621556 #yiv8790621556ygrp-sponsor #yiv8790621556ygrp-lc .yiv8790621556ad {margin-bottom:10px;padding:0 0;}#yiv8790621556 #yiv8790621556actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8790621556 #yiv8790621556activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8790621556 #yiv8790621556activity span {font-weight:700;}#yiv8790621556 #yiv8790621556activity span:first-child {text-transform:uppercase;}#yiv8790621556 #yiv8790621556activity span a {color:#5085b6;text-decoration:none;}#yiv8790621556 #yiv8790621556activity span span {color:#ff7900;}#yiv8790621556 #yiv8790621556activity span .yiv8790621556underline {text-decoration:underline;}#yiv8790621556 .yiv8790621556attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8790621556 .yiv8790621556attach div a {text-decoration:none;}#yiv8790621556 .yiv8790621556attach img {border:none;padding-right:5px;}#yiv8790621556 .yiv8790621556attach label {display:block;margin-bottom:5px;}#yiv8790621556 .yiv8790621556attach label a {text-decoration:none;}#yiv8790621556 blockquote {margin:0 0 0 4px;}#yiv8790621556 .yiv8790621556bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8790621556 .yiv8790621556bold a {text-decoration:none;}#yiv8790621556 dd.yiv8790621556last p a {font-family:Verdana;font-weight:700;}#yiv8790621556 dd.yiv8790621556last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8790621556 dd.yiv8790621556last p span.yiv8790621556yshortcuts {margin-right:0;}#yiv8790621556 div.yiv8790621556attach-table div div a {text-decoration:none;}#yiv8790621556 div.yiv8790621556attach-table {width:400px;}#yiv8790621556 div.yiv8790621556file-title a, #yiv8790621556 div...yiv8790621556file-title a:active, #yiv8790621556 div.yiv8790621556file-title a:hover, #yiv8790621556 div.yiv8790621556file-title a:visited {text-decoration:none;}#yiv8790621556 div.yiv8790621556photo-title a, #yiv8790621556 div.yiv8790621556photo-title a:active, #yiv8790621556 div.yiv8790621556photo-title a:hover, #yiv8790621556 div.yiv8790621556photo-title a:visited {text-decoration:none;}#yiv8790621556 div#yiv8790621556ygrp-mlmsg #yiv8790621556ygrp-msg p a span.yiv8790621556yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8790621556 .yiv8790621556green {color:#628c2a;}#yiv8790621556 .yiv8790621556MsoNormal {margin:0 0 0 0;}#yiv8790621556 o {font-size:0;}#yiv8790621556 #yiv8790621556photos div {float:left;width:72px;}#yiv8790621556 #yiv8790621556photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv8790621556 #yiv8790621556photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8790621556 #yiv8790621556reco-category {font-size:77%;}#yiv8790621556 #yiv8790621556reco-desc {font-size:77%;}#yiv8790621556 .yiv8790621556replbq {margin:4px;}#yiv8790621556 #yiv8790621556ygrp-actbar div a:first-child {marg
[belajar-excel] memunculkan uraian dibawah kode rekening
Selamat malam master belajar excel, mohon ijin bertanya, bagaimana cara menampilkan deskripsi uraian belanja dibawah kode rekening sesuai dengan urutan kode di sheet Kode Rekening yang ditambilkan di sheet RKA? Contoh hasil yang diharapkan ada di sheet yg diharapkan, mohon maaf bila bertanya dengan teme sejenis yang telah dijelaskan namun saya benar2 tidak tahu, terima kasih atas bantuannya. tanya milis.xlsx Description: MS-Excel 2007 spreadsheet
Bls: [belajar-excel] Pembatasan sheet dalam excel
terimakasih filenya om saya pelajari dulu Pada Kamis, 11 Agustus 2016 8:18, "Nang Agus nanga...@gmail.com [belajar-excel]" menulis: 2016-08-09 0:37 GMT+07:00 'bos.kbrn' bos.k...@yahoo.com [belajar-excel] : ssalamu'alaikum wr. wb. Dear be exceller Saya mau tanya apakah dalam proses input dapat dibatasi,,misalkan ada 4 sheet, sheet 1 merupakan sheet kunci, sheet 2, 3 dan 4 tidak dapat diisi kalau sheet 1 tidak diisi. Matur nuwun n terima kasih atas penjelasannya. Wassalamu'alaikum wr. wb #yiv4816241053 #yiv4816241053 -- #yiv4816241053ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4816241053 #yiv4816241053ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4816241053 #yiv4816241053ygrp-mkp #yiv4816241053hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4816241053 #yiv4816241053ygrp-mkp #yiv4816241053ads {margin-bottom:10px;}#yiv4816241053 #yiv4816241053ygrp-mkp .yiv4816241053ad {padding:0 0;}#yiv4816241053 #yiv4816241053ygrp-mkp .yiv4816241053ad p {margin:0;}#yiv4816241053 #yiv4816241053ygrp-mkp .yiv4816241053ad a {color:#ff;text-decoration:none;}#yiv4816241053 #yiv4816241053ygrp-sponsor #yiv4816241053ygrp-lc {font-family:Arial;}#yiv4816241053 #yiv4816241053ygrp-sponsor #yiv4816241053ygrp-lc #yiv4816241053hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4816241053 #yiv4816241053ygrp-sponsor #yiv4816241053ygrp-lc .yiv4816241053ad {margin-bottom:10px;padding:0 0;}#yiv4816241053 #yiv4816241053actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4816241053 #yiv4816241053activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4816241053 #yiv4816241053activity span {font-weight:700;}#yiv4816241053 #yiv4816241053activity span:first-child {text-transform:uppercase;}#yiv4816241053 #yiv4816241053activity span a {color:#5085b6;text-decoration:none;}#yiv4816241053 #yiv4816241053activity span span {color:#ff7900;}#yiv4816241053 #yiv4816241053activity span .yiv4816241053underline {text-decoration:underline;}#yiv4816241053 .yiv4816241053attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4816241053 .yiv4816241053attach div a {text-decoration:none;}#yiv4816241053 .yiv4816241053attach img {border:none;padding-right:5px;}#yiv4816241053 .yiv4816241053attach label {display:block;margin-bottom:5px;}#yiv4816241053 .yiv4816241053attach label a {text-decoration:none;}#yiv4816241053 blockquote {margin:0 0 0 4px;}#yiv4816241053 .yiv4816241053bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4816241053 .yiv4816241053bold a {text-decoration:none;}#yiv4816241053 dd.yiv4816241053last p a {font-family:Verdana;font-weight:700;}#yiv4816241053 dd.yiv4816241053last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4816241053 dd.yiv4816241053last p span.yiv4816241053yshortcuts {margin-right:0;}#yiv4816241053 div.yiv4816241053attach-table div div a {text-decoration:none;}#yiv4816241053 div.yiv4816241053attach-table {width:400px;}#yiv4816241053 div.yiv4816241053file-title a, #yiv4816241053 div.yiv4816241053file-title a:active, #yiv4816241053 div.yiv4816241053file-title a:hover, #yiv4816241053 div.yiv4816241053file-title a:visited {text-decoration:none;}#yiv4816241053 div.yiv4816241053photo-title a, #yiv4816241053 div.yiv4816241053photo-title a:active, #yiv4816241053 div.yiv4816241053photo-title a:hover, #yiv4816241053 div.yiv4816241053photo-title a:visited {text-decoration:none;}#yiv4816241053 div#yiv4816241053ygrp-mlmsg #yiv4816241053ygrp-msg p a span.yiv4816241053yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4816241053 .yiv4816241053green {color:#628c2a;}#yiv4816241053 .yiv4816241053MsoNormal {margin:0 0 0 0;}#yiv4816241053 o {font-size:0;}#yiv4816241053 #yiv4816241053photos div {float:left;width:72px;}#yiv4816241053 #yiv4816241053photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv4816241053 #yiv4816241053photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4816241053 #yiv4816241053reco-category {font-size:77%;}#yiv4816241053 #yiv4816241053reco-desc {font-size:77%;}#yiv4816241053 .yiv4816241053replbq {margin:4px;}#yiv4816241053 #yiv4816241053ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4816241053 #yiv4816241053ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4816241053 #yiv4816241053ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4816241053 #yiv4816241053ygrp-mlmsg select, #yiv4816241053 input, #yiv4816241053 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4816241053 #yiv4816241053ygrp-mlmsg pre, #yiv4816241053 code {font:115% monospace;}#yiv4816241053 #yiv4816241053ygrp-mlmsg * {line-height:1.22em;}#yiv48162
Bls: [belajar-excel] Pembatasan sheet dalam excel
terima ksih omm,dicoba dulu Pada Kamis, 11 Agustus 2016 8:18, "Nang Agus nanga...@gmail.com [belajar-excel]" menulis: 2016-08-09 0:37 GMT+07:00 'bos.kbrn' bos.k...@yahoo.com [belajar-excel] : ssalamu'alaikum wr. wb. Dear be exceller Saya mau tanya apakah dalam proses input dapat dibatasi,,misalkan ada 4 sheet, sheet 1 merupakan sheet kunci, sheet 2, 3 dan 4 tidak dapat diisi kalau sheet 1 tidak diisi. Matur nuwun n terima kasih atas penjelasannya. Wassalamu'alaikum wr. wb #yiv1126406691 -- #yiv1126406691ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1126406691 #yiv1126406691ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1126406691 #yiv1126406691ygrp-mkp #yiv1126406691hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1126406691 #yiv1126406691ygrp-mkp #yiv1126406691ads {margin-bottom:10px;}#yiv1126406691 #yiv1126406691ygrp-mkp .yiv1126406691ad {padding:0 0;}#yiv1126406691 #yiv1126406691ygrp-mkp .yiv1126406691ad p {margin:0;}#yiv1126406691 #yiv1126406691ygrp-mkp .yiv1126406691ad a {color:#ff;text-decoration:none;}#yiv1126406691 #yiv1126406691ygrp-sponsor #yiv1126406691ygrp-lc {font-family:Arial;}#yiv1126406691 #yiv1126406691ygrp-sponsor #yiv1126406691ygrp-lc #yiv1126406691hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1126406691 #yiv1126406691ygrp-sponsor #yiv1126406691ygrp-lc .yiv1126406691ad {margin-bottom:10px;padding:0 0;}#yiv1126406691 #yiv1126406691actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1126406691 #yiv1126406691activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1126406691 #yiv1126406691activity span {font-weight:700;}#yiv1126406691 #yiv1126406691activity span:first-child {text-transform:uppercase;}#yiv1126406691 #yiv1126406691activity span a {color:#5085b6;text-decoration:none;}#yiv1126406691 #yiv1126406691activity span span {color:#ff7900;}#yiv1126406691 #yiv1126406691activity span .yiv1126406691underline {text-decoration:underline;}#yiv1126406691 .yiv1126406691attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1126406691 .yiv1126406691attach div a {text-decoration:none;}#yiv1126406691 .yiv1126406691attach img {border:none;padding-right:5px;}#yiv1126406691 .yiv1126406691attach label {display:block;margin-bottom:5px;}#yiv1126406691 .yiv1126406691attach label a {text-decoration:none;}#yiv1126406691 blockquote {margin:0 0 0 4px;}#yiv1126406691 .yiv1126406691bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1126406691 .yiv1126406691bold a {text-decoration:none;}#yiv1126406691 dd.yiv1126406691last p a {font-family:Verdana;font-weight:700;}#yiv1126406691 dd.yiv1126406691last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1126406691 dd.yiv1126406691last p span.yiv1126406691yshortcuts {margin-right:0;}#yiv1126406691 div.yiv1126406691attach-table div div a {text-decoration:none;}#yiv1126406691 div.yiv1126406691attach-table {width:400px;}#yiv1126406691 div.yiv1126406691file-title a, #yiv1126406691 div.yiv1126406691file-title a:active, #yiv1126406691 div.yiv1126406691file-title a:hover, #yiv1126406691 div.yiv1126406691file-title a:visited {text-decoration:none;}#yiv1126406691 div.yiv1126406691photo-title a, #yiv1126406691 div.yiv1126406691photo-title a:active, #yiv1126406691 div.yiv1126406691photo-title a:hover, #yiv1126406691 div.yiv1126406691photo-title a:visited {text-decoration:none;}#yiv1126406691 div#yiv1126406691ygrp-mlmsg #yiv1126406691ygrp-msg p a span.yiv1126406691yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1126406691 .yiv1126406691green {color:#628c2a;}#yiv1126406691 .yiv1126406691MsoNormal {margin:0 0 0 0;}#yiv1126406691 o {font-size:0;}#yiv1126406691 #yiv1126406691photos div {float:left;width:72px;}#yiv1126406691 #yiv1126406691photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv1126406691 #yiv1126406691photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1126406691 #yiv1126406691reco-category {font-size:77%;}#yiv1126406691 #yiv1126406691reco-desc {font-size:77%;}#yiv1126406691 .yiv1126406691replbq {margin:4px;}#yiv1126406691 #yiv1126406691ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1126406691 #yiv1126406691ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1126406691 #yiv1126406691ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1126406691 #yiv1126406691ygrp-mlmsg select, #yiv1126406691 input, #yiv1126406691 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1126406691 #yiv1126406691ygrp-mlmsg pre, #yiv1126406691 code {font:115% monospace;}#yiv1126406691 #yiv1126406691ygrp-mlmsg * {line-height:1.22em;}#yiv1126406691 #yiv1126406691ygrp-mlms
[belajar-excel] Pembatasan sheet dalam excel
ssalamu'alaikum wr. wb. Dear be exceller Saya mau tanya apakah dalam proses input dapat dibatasi,,misalkan ada 4 sheet, sheet 1 merupakan sheet kunci, sheet 2, 3 dan 4 tidak dapat diisi kalau sheet 1 tidak diisi. Matur nuwun n terima kasih atas penjelasannya. Wassalamu'alaikum wr. wb