dearnang agus
terimasikasih atas masukannya dan filenya sudah saya terima, kira-kira scrip
untuk file tersebut ada g mas nang agus karna untuk pengimputan sheet buku
induk saya mengunakan form pengingputan dengan VBA Excel jadi kalau bisa untuk
pengisian arsip pengelola saya sekaligus waktu menginput langsung terisi sheet
pengelola. trims
On Friday, December 16, 2016 10:47 AM, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> wrote:
2016-12-15 22:39 GMT+07:00 dedril cecen [email protected] [belajar-excel]
<[email protected]>:
dear bapak/ibu guru belajar-excel
saya mempunyai pembukuan surat menyurat data suratnya seperti pada file dibawah
inisaya ingin memisahkan kelompok arsip sesuai dengan pengelolanyaapabila
pengelolanya kasubbag umum maka tersimpat di sheet arsip umumapabila
pengelolanya Kasi Pemerintahan maka tersimpat di sheet arsip pemerintahan
apabila pengelolanya Bendahara maka tersimpat di sheet arsip bendahara apabila
pengelolanya kasi pmd maka tersimpat di sheet arsi pmdddan seterusnya
setiap mengisi buku induk otomatis sheet sesuai pengelola langsung mengsi
tersendirimohon bantuannya dalam penulisan script nya. trims
#yiv0951252904 #yiv0951252904 -- #yiv0951252904ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0951252904
#yiv0951252904ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0951252904
#yiv0951252904ygrp-mkp #yiv0951252904hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0951252904 #yiv0951252904ygrp-mkp #yiv0951252904ads
{margin-bottom:10px;}#yiv0951252904 #yiv0951252904ygrp-mkp .yiv0951252904ad
{padding:0 0;}#yiv0951252904 #yiv0951252904ygrp-mkp .yiv0951252904ad p
{margin:0;}#yiv0951252904 #yiv0951252904ygrp-mkp .yiv0951252904ad a
{color:#0000ff;text-decoration:none;}#yiv0951252904 #yiv0951252904ygrp-sponsor
#yiv0951252904ygrp-lc {font-family:Arial;}#yiv0951252904
#yiv0951252904ygrp-sponsor #yiv0951252904ygrp-lc #yiv0951252904hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0951252904
#yiv0951252904ygrp-sponsor #yiv0951252904ygrp-lc .yiv0951252904ad
{margin-bottom:10px;padding:0 0;}#yiv0951252904 #yiv0951252904actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0951252904
#yiv0951252904activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0951252904
#yiv0951252904activity span {font-weight:700;}#yiv0951252904
#yiv0951252904activity span:first-child
{text-transform:uppercase;}#yiv0951252904 #yiv0951252904activity span a
{color:#5085b6;text-decoration:none;}#yiv0951252904 #yiv0951252904activity span
span {color:#ff7900;}#yiv0951252904 #yiv0951252904activity span
.yiv0951252904underline {text-decoration:underline;}#yiv0951252904
.yiv0951252904attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0951252904 .yiv0951252904attach div a
{text-decoration:none;}#yiv0951252904 .yiv0951252904attach img
{border:none;padding-right:5px;}#yiv0951252904 .yiv0951252904attach label
{display:block;margin-bottom:5px;}#yiv0951252904 .yiv0951252904attach label a
{text-decoration:none;}#yiv0951252904 blockquote {margin:0 0 0
4px;}#yiv0951252904 .yiv0951252904bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0951252904
.yiv0951252904bold a {text-decoration:none;}#yiv0951252904 dd.yiv0951252904last
p a {font-family:Verdana;font-weight:700;}#yiv0951252904 dd.yiv0951252904last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0951252904
dd.yiv0951252904last p span.yiv0951252904yshortcuts
{margin-right:0;}#yiv0951252904 div.yiv0951252904attach-table div div a
{text-decoration:none;}#yiv0951252904 div.yiv0951252904attach-table
{width:400px;}#yiv0951252904 div.yiv0951252904file-title a, #yiv0951252904
div.yiv0951252904file-title a:active, #yiv0951252904
div.yiv0951252904file-title a:hover, #yiv0951252904 div.yiv0951252904file-title
a:visited {text-decoration:none;}#yiv0951252904 div.yiv0951252904photo-title a,
#yiv0951252904 div.yiv0951252904photo-title a:active, #yiv0951252904
div.yiv0951252904photo-title a:hover, #yiv0951252904
div.yiv0951252904photo-title a:visited {text-decoration:none;}#yiv0951252904
div#yiv0951252904ygrp-mlmsg #yiv0951252904ygrp-msg p a
span.yiv0951252904yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0951252904
.yiv0951252904green {color:#628c2a;}#yiv0951252904 .yiv0951252904MsoNormal
{margin:0 0 0 0;}#yiv0951252904 o {font-size:0;}#yiv0951252904
#yiv0951252904photos div {float:left;width:72px;}#yiv0951252904
#yiv0951252904photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0951252904
#yiv0951252904photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0951252904
#yiv0951252904reco-category {font-size:77%;}#yiv0951252904
#yiv0951252904reco-desc {font-size:77%;}#yiv0951252904 .yiv0951252904replbq
{margin:4px;}#yiv0951252904 #yiv0951252904ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0951252904 #yiv0951252904ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0951252904
#yiv0951252904ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0951252904
#yiv0951252904ygrp-mlmsg select, #yiv0951252904 input, #yiv0951252904 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0951252904
#yiv0951252904ygrp-mlmsg pre, #yiv0951252904 code {font:115%
monospace;}#yiv0951252904 #yiv0951252904ygrp-mlmsg *
{line-height:1.22em;}#yiv0951252904 #yiv0951252904ygrp-mlmsg #yiv0951252904logo
{padding-bottom:10px;}#yiv0951252904 #yiv0951252904ygrp-msg p a
{font-family:Verdana;}#yiv0951252904 #yiv0951252904ygrp-msg
p#yiv0951252904attach-count span {color:#1E66AE;font-weight:700;}#yiv0951252904
#yiv0951252904ygrp-reco #yiv0951252904reco-head
{color:#ff7900;font-weight:700;}#yiv0951252904 #yiv0951252904ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0951252904 #yiv0951252904ygrp-sponsor
#yiv0951252904ov li a {font-size:130%;text-decoration:none;}#yiv0951252904
#yiv0951252904ygrp-sponsor #yiv0951252904ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0951252904
#yiv0951252904ygrp-sponsor #yiv0951252904ov ul {margin:0;padding:0 0 0
8px;}#yiv0951252904 #yiv0951252904ygrp-text
{font-family:Georgia;}#yiv0951252904 #yiv0951252904ygrp-text p {margin:0 0 1em
0;}#yiv0951252904 #yiv0951252904ygrp-text tt {font-size:120%;}#yiv0951252904
#yiv0951252904ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0951252904
