Terima Kasih Pa HK,sangat membantu sekali, saya coba pelajari dulu
SalamKang Oza
On Tuesday, November 24, 2015 2:41 PM, "hendrik karnadi
[email protected] [belajar-excel]" <[email protected]> wrote:
Hai Kang Oza,Coba file warisan si mbah ini (telah diedit).
Salam,HK
From: "Ahmad Rojali [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 24 November 2015, 9:55
Subject: [belajar-excel] Membuat database induk dan database anak [1
Attachment]
Dear Para Master,
Saya masih sangat awam tentang macro. mohon bantuan untuk menyimpan data di
database induk dan database anak.
penjelasannya: jika kita mengisi di sheet "Invoicing" lalu kita tekan button
rekam, maka data akan tersimpan di sheet "RkpInduk" sebagai Rekapan invoice dan
di Sheet "RkpAnak" sebagai rincian invoice. dan ketika sewaktu-waktu
dibutuhkan, data tersebut dapat dipanggil di Sheet "Print" dengan data sama
persis seperti waktu dibuat di sheet "Invoicing" seperti file terlampir.
Terima kasih banyak atas bantuannya
Regards
Kang Oza
#yiv2336682893 #yiv2336682893 -- #yiv2336682893ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2336682893
#yiv2336682893ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2336682893
#yiv2336682893ygrp-mkp #yiv2336682893hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2336682893 #yiv2336682893ygrp-mkp #yiv2336682893ads
{margin-bottom:10px;}#yiv2336682893 #yiv2336682893ygrp-mkp .yiv2336682893ad
{padding:0 0;}#yiv2336682893 #yiv2336682893ygrp-mkp .yiv2336682893ad p
{margin:0;}#yiv2336682893 #yiv2336682893ygrp-mkp .yiv2336682893ad a
{color:#0000ff;text-decoration:none;}#yiv2336682893 #yiv2336682893ygrp-sponsor
#yiv2336682893ygrp-lc {font-family:Arial;}#yiv2336682893
#yiv2336682893ygrp-sponsor #yiv2336682893ygrp-lc #yiv2336682893hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2336682893
#yiv2336682893ygrp-sponsor #yiv2336682893ygrp-lc .yiv2336682893ad
{margin-bottom:10px;padding:0 0;}#yiv2336682893 #yiv2336682893actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2336682893
#yiv2336682893activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2336682893
#yiv2336682893activity span {font-weight:700;}#yiv2336682893
#yiv2336682893activity span:first-child
{text-transform:uppercase;}#yiv2336682893 #yiv2336682893activity span a
{color:#5085b6;text-decoration:none;}#yiv2336682893 #yiv2336682893activity span
span {color:#ff7900;}#yiv2336682893 #yiv2336682893activity span
.yiv2336682893underline {text-decoration:underline;}#yiv2336682893
.yiv2336682893attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2336682893 .yiv2336682893attach div a
{text-decoration:none;}#yiv2336682893 .yiv2336682893attach img
{border:none;padding-right:5px;}#yiv2336682893 .yiv2336682893attach label
{display:block;margin-bottom:5px;}#yiv2336682893 .yiv2336682893attach label a
{text-decoration:none;}#yiv2336682893 blockquote {margin:0 0 0
4px;}#yiv2336682893 .yiv2336682893bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2336682893
.yiv2336682893bold a {text-decoration:none;}#yiv2336682893 dd.yiv2336682893last
p a {font-family:Verdana;font-weight:700;}#yiv2336682893 dd.yiv2336682893last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2336682893
dd.yiv2336682893last p span.yiv2336682893yshortcuts
{margin-right:0;}#yiv2336682893 div.yiv2336682893attach-table div div a
{text-decoration:none;}#yiv2336682893 div.yiv2336682893attach-table
{width:400px;}#yiv2336682893 div.yiv2336682893file-title a, #yiv2336682893
div.yiv2336682893file-title a:active, #yiv2336682893
div.yiv2336682893file-title a:hover, #yiv2336682893 div.yiv2336682893file-title
a:visited {text-decoration:none;}#yiv2336682893 div.yiv2336682893photo-title a,
#yiv2336682893 div.yiv2336682893photo-title a:active, #yiv2336682893
div.yiv2336682893photo-title a:hover, #yiv2336682893
div.yiv2336682893photo-title a:visited {text-decoration:none;}#yiv2336682893
div#yiv2336682893ygrp-mlmsg #yiv2336682893ygrp-msg p a
span.yiv2336682893yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2336682893
.yiv2336682893green {color:#628c2a;}#yiv2336682893 .yiv2336682893MsoNormal
{margin:0 0 0 0;}#yiv2336682893 o {font-size:0;}#yiv2336682893
#yiv2336682893photos div {float:left;width:72px;}#yiv2336682893
#yiv2336682893photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2336682893
#yiv2336682893photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2336682893
#yiv2336682893reco-category {font-size:77%;}#yiv2336682893
#yiv2336682893reco-desc {font-size:77%;}#yiv2336682893 .yiv2336682893replbq
{margin:4px;}#yiv2336682893 #yiv2336682893ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2336682893 #yiv2336682893ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2336682893
#yiv2336682893ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2336682893
#yiv2336682893ygrp-mlmsg select, #yiv2336682893 input, #yiv2336682893 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2336682893
#yiv2336682893ygrp-mlmsg pre, #yiv2336682893 code {font:115%
monospace;}#yiv2336682893 #yiv2336682893ygrp-mlmsg *
{line-height:1.22em;}#yiv2336682893 #yiv2336682893ygrp-mlmsg #yiv2336682893logo
{padding-bottom:10px;}#yiv2336682893 #yiv2336682893ygrp-msg p a
{font-family:Verdana;}#yiv2336682893 #yiv2336682893ygrp-msg
p#yiv2336682893attach-count span {color:#1E66AE;font-weight:700;}#yiv2336682893
#yiv2336682893ygrp-reco #yiv2336682893reco-head
{color:#ff7900;font-weight:700;}#yiv2336682893 #yiv2336682893ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2336682893 #yiv2336682893ygrp-sponsor
#yiv2336682893ov li a {font-size:130%;text-decoration:none;}#yiv2336682893
#yiv2336682893ygrp-sponsor #yiv2336682893ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2336682893
#yiv2336682893ygrp-sponsor #yiv2336682893ov ul {margin:0;padding:0 0 0
8px;}#yiv2336682893 #yiv2336682893ygrp-text
{font-family:Georgia;}#yiv2336682893 #yiv2336682893ygrp-text p {margin:0 0 1em
0;}#yiv2336682893 #yiv2336682893ygrp-text tt {font-size:120%;}#yiv2336682893
#yiv2336682893ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2336682893
