Dear Cecen, Bisa di share ngga form penginputannya yang menggunakan VBA,
mungkin teman-teman yang lain bias membantu. TerimaKasih.
Pada Senin, 19 Desember 2016 7:22, "dedril cecen [email protected]
[belajar-excel]" <[email protected]> menulis:
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
#yiv7490610295 #yiv7490610295 -- #yiv7490610295ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7490610295
#yiv7490610295ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7490610295
#yiv7490610295ygrp-mkp #yiv7490610295hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7490610295 #yiv7490610295ygrp-mkp #yiv7490610295ads
{margin-bottom:10px;}#yiv7490610295 #yiv7490610295ygrp-mkp .yiv7490610295ad
{padding:0 0;}#yiv7490610295 #yiv7490610295ygrp-mkp .yiv7490610295ad p
{margin:0;}#yiv7490610295 #yiv7490610295ygrp-mkp .yiv7490610295ad a
{color:#0000ff;text-decoration:none;}#yiv7490610295 #yiv7490610295ygrp-sponsor
#yiv7490610295ygrp-lc {font-family:Arial;}#yiv7490610295
#yiv7490610295ygrp-sponsor #yiv7490610295ygrp-lc #yiv7490610295hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7490610295
#yiv7490610295ygrp-sponsor #yiv7490610295ygrp-lc .yiv7490610295ad
{margin-bottom:10px;padding:0 0;}#yiv7490610295 #yiv7490610295actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7490610295
#yiv7490610295activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7490610295
#yiv7490610295activity span {font-weight:700;}#yiv7490610295
#yiv7490610295activity span:first-child
{text-transform:uppercase;}#yiv7490610295 #yiv7490610295activity span a
{color:#5085b6;text-decoration:none;}#yiv7490610295 #yiv7490610295activity span
span {color:#ff7900;}#yiv7490610295 #yiv7490610295activity span
.yiv7490610295underline {text-decoration:underline;}#yiv7490610295
.yiv7490610295attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7490610295 .yiv7490610295attach div a
{text-decoration:none;}#yiv7490610295 .yiv7490610295attach img
{border:none;padding-right:5px;}#yiv7490610295 .yiv7490610295attach label
{display:block;margin-bottom:5px;}#yiv7490610295 .yiv7490610295attach label a
{text-decoration:none;}#yiv7490610295 blockquote {margin:0 0 0
4px;}#yiv7490610295 .yiv7490610295bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7490610295
.yiv7490610295bold a {text-decoration:none;}#yiv7490610295 dd.yiv7490610295last
p a {font-family:Verdana;font-weight:700;}#yiv7490610295 dd.yiv7490610295last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7490610295
dd.yiv7490610295last p span.yiv7490610295yshortcuts
{margin-right:0;}#yiv7490610295 div.yiv7490610295attach-table div div a
{text-decoration:none;}#yiv7490610295 div.yiv7490610295attach-table
{width:400px;}#yiv7490610295 div.yiv7490610295file-title a, #yiv7490610295
div.yiv7490610295file-title a:active, #yiv7490610295
div.yiv7490610295file-title a:hover, #yiv7490610295 div.yiv7490610295file-title
a:visited {text-decoration:none;}#yiv7490610295 div.yiv7490610295photo-title a,
#yiv7490610295 div.yiv7490610295photo-title a:active, #yiv7490610295
div.yiv7490610295photo-title a:hover, #yiv7490610295
div.yiv7490610295photo-title a:visited {text-decoration:none;}#yiv7490610295
div#yiv7490610295ygrp-mlmsg #yiv7490610295ygrp-msg p a
span.yiv7490610295yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7490610295
.yiv7490610295green {color:#628c2a;}#yiv7490610295 .yiv7490610295MsoNormal
{margin:0 0 0 0;}#yiv7490610295 o {font-size:0;}#yiv7490610295
#yiv7490610295photos div {float:left;width:72px;}#yiv7490610295
#yiv7490610295photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7490610295
#yiv7490610295photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7490610295
#yiv7490610295reco-category {font-size:77%;}#yiv7490610295
#yiv7490610295reco-desc {font-size:77%;}#yiv7490610295 .yiv7490610295replbq
{margin:4px;}#yiv7490610295 #yiv7490610295ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7490610295 #yiv7490610295ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7490610295
#yiv7490610295ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7490610295
#yiv7490610295ygrp-mlmsg select, #yiv7490610295 input, #yiv7490610295 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7490610295
#yiv7490610295ygrp-mlmsg pre, #yiv7490610295 code {font:115%
monospace;}#yiv7490610295 #yiv7490610295ygrp-mlmsg *
{line-height:1.22em;}#yiv7490610295 #yiv7490610295ygrp-mlmsg #yiv7490610295logo
{padding-bottom:10px;}#yiv7490610295 #yiv7490610295ygrp-msg p a
{font-family:Verdana;}#yiv7490610295 #yiv7490610295ygrp-msg
p#yiv7490610295attach-count span {color:#1E66AE;font-weight:700;}#yiv7490610295
#yiv7490610295ygrp-reco #yiv7490610295reco-head
{color:#ff7900;font-weight:700;}#yiv7490610295 #yiv7490610295ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7490610295 #yiv7490610295ygrp-sponsor
#yiv7490610295ov li a {font-size:130%;text-decoration:none;}#yiv7490610295
#yiv7490610295ygrp-sponsor #yiv7490610295ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7490610295
#yiv7490610295ygrp-sponsor #yiv7490610295ov ul {margin:0;padding:0 0 0
8px;}#yiv7490610295 #yiv7490610295ygrp-text
{font-family:Georgia;}#yiv7490610295 #yiv7490610295ygrp-text p {margin:0 0 1em
0;}#yiv7490610295 #yiv7490610295ygrp-text tt {font-size:120%;}#yiv7490610295
#yiv7490610295ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7490610295
