dear mas nang
terimakasih atas responnya, kenapa tidak bisa dibuka ya referensi situsnya
(apakrn di blokir di kantor)
mas nang, apa di situs tsb, msh dpt diselesaikan kah...
soalnya sy ingin membuat teamplate,,, dari sheet input menjadi ke sheet
databasesheet input tsb, ada tombol save yg otomatis save ke sheet database,
kemudian bisa digandakan untuk secara mudah mengisi utk bulan brktnya
dikarenakan banyaknya baris yg di copy,,,di data base di save scr berurut
sesuai bulannya
mohon bantuannya
terimakasih
Pada Selasa, 22 November 2016 10:02, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> menulis:
dear suhendra
coba dibuat sendiri menggunakan record macro
salah satu caranya di sini
kalau nanti ada kesulitan lagi dapat dipostingkan.
salam
NangAgus
2016-11-21 17:54 GMT+07:00 Suhendra St [email protected] [belajar-excel]
<[email protected]>:
dear. teman2 beExcel
mohon bantuan membuar data base (file terlampir)
acuan, perbulan,,,,bisa digandakan
dan bisa dilihat untuk bulan-bulan sebelumnya
terimakasih sebelummnya
#yiv7630411530 #yiv7630411530 -- #yiv7630411530ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7630411530
#yiv7630411530ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7630411530
#yiv7630411530ygrp-mkp #yiv7630411530hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7630411530 #yiv7630411530ygrp-mkp #yiv7630411530ads
{margin-bottom:10px;}#yiv7630411530 #yiv7630411530ygrp-mkp .yiv7630411530ad
{padding:0 0;}#yiv7630411530 #yiv7630411530ygrp-mkp .yiv7630411530ad p
{margin:0;}#yiv7630411530 #yiv7630411530ygrp-mkp .yiv7630411530ad a
{color:#0000ff;text-decoration:none;}#yiv7630411530 #yiv7630411530ygrp-sponsor
#yiv7630411530ygrp-lc {font-family:Arial;}#yiv7630411530
#yiv7630411530ygrp-sponsor #yiv7630411530ygrp-lc #yiv7630411530hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7630411530
#yiv7630411530ygrp-sponsor #yiv7630411530ygrp-lc .yiv7630411530ad
{margin-bottom:10px;padding:0 0;}#yiv7630411530 #yiv7630411530actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7630411530
#yiv7630411530activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7630411530
#yiv7630411530activity span {font-weight:700;}#yiv7630411530
#yiv7630411530activity span:first-child
{text-transform:uppercase;}#yiv7630411530 #yiv7630411530activity span a
{color:#5085b6;text-decoration:none;}#yiv7630411530 #yiv7630411530activity span
span {color:#ff7900;}#yiv7630411530 #yiv7630411530activity span
.yiv7630411530underline {text-decoration:underline;}#yiv7630411530
.yiv7630411530attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7630411530 .yiv7630411530attach div a
{text-decoration:none;}#yiv7630411530 .yiv7630411530attach img
{border:none;padding-right:5px;}#yiv7630411530 .yiv7630411530attach label
{display:block;margin-bottom:5px;}#yiv7630411530 .yiv7630411530attach label a
{text-decoration:none;}#yiv7630411530 blockquote {margin:0 0 0
4px;}#yiv7630411530 .yiv7630411530bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7630411530
.yiv7630411530bold a {text-decoration:none;}#yiv7630411530 dd.yiv7630411530last
p a {font-family:Verdana;font-weight:700;}#yiv7630411530 dd.yiv7630411530last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7630411530
dd.yiv7630411530last p span.yiv7630411530yshortcuts
{margin-right:0;}#yiv7630411530 div.yiv7630411530attach-table div div a
{text-decoration:none;}#yiv7630411530 div.yiv7630411530attach-table
{width:400px;}#yiv7630411530 div.yiv7630411530file-title a, #yiv7630411530
div.yiv7630411530file-title a:active, #yiv7630411530
div.yiv7630411530file-title a:hover, #yiv7630411530 div.yiv7630411530file-title
a:visited {text-decoration:none;}#yiv7630411530 div.yiv7630411530photo-title a,
#yiv7630411530 div.yiv7630411530photo-title a:active, #yiv7630411530
div.yiv7630411530photo-title a:hover, #yiv7630411530
div.yiv7630411530photo-title a:visited {text-decoration:none;}#yiv7630411530
div#yiv7630411530ygrp-mlmsg #yiv7630411530ygrp-msg p a
span.yiv7630411530yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7630411530
.yiv7630411530green {color:#628c2a;}#yiv7630411530 .yiv7630411530MsoNormal
{margin:0 0 0 0;}#yiv7630411530 o {font-size:0;}#yiv7630411530
#yiv7630411530photos div {float:left;width:72px;}#yiv7630411530
#yiv7630411530photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7630411530
#yiv7630411530photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7630411530
#yiv7630411530reco-category {font-size:77%;}#yiv7630411530
#yiv7630411530reco-desc {font-size:77%;}#yiv7630411530 .yiv7630411530replbq
{margin:4px;}#yiv7630411530 #yiv7630411530ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7630411530 #yiv7630411530ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7630411530
#yiv7630411530ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7630411530
#yiv7630411530ygrp-mlmsg select, #yiv7630411530 input, #yiv7630411530 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7630411530
#yiv7630411530ygrp-mlmsg pre, #yiv7630411530 code {font:115%
monospace;}#yiv7630411530 #yiv7630411530ygrp-mlmsg *
{line-height:1.22em;}#yiv7630411530 #yiv7630411530ygrp-mlmsg #yiv7630411530logo
{padding-bottom:10px;}#yiv7630411530 #yiv7630411530ygrp-msg p a
{font-family:Verdana;}#yiv7630411530 #yiv7630411530ygrp-msg
p#yiv7630411530attach-count span {color:#1E66AE;font-weight:700;}#yiv7630411530
#yiv7630411530ygrp-reco #yiv7630411530reco-head
{color:#ff7900;font-weight:700;}#yiv7630411530 #yiv7630411530ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7630411530 #yiv7630411530ygrp-sponsor
#yiv7630411530ov li a {font-size:130%;text-decoration:none;}#yiv7630411530
#yiv7630411530ygrp-sponsor #yiv7630411530ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7630411530
#yiv7630411530ygrp-sponsor #yiv7630411530ov ul {margin:0;padding:0 0 0
8px;}#yiv7630411530 #yiv7630411530ygrp-text
{font-family:Georgia;}#yiv7630411530 #yiv7630411530ygrp-text p {margin:0 0 1em
0;}#yiv7630411530 #yiv7630411530ygrp-text tt {font-size:120%;}#yiv7630411530
#yiv7630411530ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7630411530
