Dear Mr. Kid,
Maksudnya bagaimana ya? Maaf saya belum menangkap maksud dari Mr. Kid.Baris
tersebut memang ditujukan untuk cell tetap yaitu C10.
Salam,DM
On Tuesday, December 30, 2014 7:52 PM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Dwi,
Baris ini selalu merujuk ke cell yang tetap.
TblRkp(NewRkp + r, 7) = Sheets("Form").Range("c10").Value '
keterangan
Coba ubah agar dinamis mengikuti pertambahan nilai variabel r
Wassalam,
Kid.
2014-12-29 19:48 GMT+11:00 dwi mulyaningsih [email protected] [belajar-excel]
<[email protected]>:
Dear Rekan excel,
Mohon bantuannya lagi.Saya punya file kas & bank, yang saya inginkan setelah
entry data di form langsung masuk ke rekapan.Pada sheet form isinya terdiri
dari 3 buah form, kolom C2 merupakan kolom pembantu untuk mengidentifikasi form
yang mana yang digunakan. Jika C2=0, maka yang digunakan form kas keluar, jika
C2=1 maka yang digunakan form kas keluar (untuk bank), jika C2=2 maka yang
digunakan form kas masuk (untuk bank). Yang saya inginkan saat tombol input di
klik maka data akan otomatis masuk ke rekapan berdasarkan identifikasi dari
form yang digunakan. Saya menggunakan formula vba milik alm Mba Siti dengan
modifikasi, untuk beberapa form yang sudah saya pakai formulanya dapat berjalan
akan tetapi untuk kasus ini tidak berhasil. Pada saat saya klik tombol input
data memang masuk ke sheet rekap akan tetapi ter entrynya lebih dari satu.
Letak kesalahannya dimana ya? Mohon bantuannya.
Terima kasih
SalamDwi
#yiv8499359840 #yiv8499359840 -- #yiv8499359840ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8499359840
#yiv8499359840ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8499359840
#yiv8499359840ygrp-mkp #yiv8499359840hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8499359840 #yiv8499359840ygrp-mkp #yiv8499359840ads
{margin-bottom:10px;}#yiv8499359840 #yiv8499359840ygrp-mkp .yiv8499359840ad
{padding:0 0;}#yiv8499359840 #yiv8499359840ygrp-mkp .yiv8499359840ad p
{margin:0;}#yiv8499359840 #yiv8499359840ygrp-mkp .yiv8499359840ad a
{color:#0000ff;text-decoration:none;}#yiv8499359840 #yiv8499359840ygrp-sponsor
#yiv8499359840ygrp-lc {font-family:Arial;}#yiv8499359840
#yiv8499359840ygrp-sponsor #yiv8499359840ygrp-lc #yiv8499359840hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8499359840
#yiv8499359840ygrp-sponsor #yiv8499359840ygrp-lc .yiv8499359840ad
{margin-bottom:10px;padding:0 0;}#yiv8499359840 #yiv8499359840actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8499359840
#yiv8499359840activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8499359840
#yiv8499359840activity span {font-weight:700;}#yiv8499359840
#yiv8499359840activity span:first-child
{text-transform:uppercase;}#yiv8499359840 #yiv8499359840activity span a
{color:#5085b6;text-decoration:none;}#yiv8499359840 #yiv8499359840activity span
span {color:#ff7900;}#yiv8499359840 #yiv8499359840activity span
.yiv8499359840underline {text-decoration:underline;}#yiv8499359840
.yiv8499359840attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8499359840 .yiv8499359840attach div a
{text-decoration:none;}#yiv8499359840 .yiv8499359840attach img
{border:none;padding-right:5px;}#yiv8499359840 .yiv8499359840attach label
{display:block;margin-bottom:5px;}#yiv8499359840 .yiv8499359840attach label a
{text-decoration:none;}#yiv8499359840 blockquote {margin:0 0 0
4px;}#yiv8499359840 .yiv8499359840bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8499359840
.yiv8499359840bold a {text-decoration:none;}#yiv8499359840 dd.yiv8499359840last
p a {font-family:Verdana;font-weight:700;}#yiv8499359840 dd.yiv8499359840last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8499359840
dd.yiv8499359840last p span.yiv8499359840yshortcuts
{margin-right:0;}#yiv8499359840 div.yiv8499359840attach-table div div a
{text-decoration:none;}#yiv8499359840 div.yiv8499359840attach-table
{width:400px;}#yiv8499359840 div.yiv8499359840file-title a, #yiv8499359840
div.yiv8499359840file-title a:active, #yiv8499359840
div.yiv8499359840file-title a:hover, #yiv8499359840 div.yiv8499359840file-title
a:visited {text-decoration:none;}#yiv8499359840 div.yiv8499359840photo-title a,
#yiv8499359840 div.yiv8499359840photo-title a:active, #yiv8499359840
div.yiv8499359840photo-title a:hover, #yiv8499359840
div.yiv8499359840photo-title a:visited {text-decoration:none;}#yiv8499359840
div#yiv8499359840ygrp-mlmsg #yiv8499359840ygrp-msg p a
span.yiv8499359840yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8499359840
.yiv8499359840green {color:#628c2a;}#yiv8499359840 .yiv8499359840MsoNormal
{margin:0 0 0 0;}#yiv8499359840 o {font-size:0;}#yiv8499359840
#yiv8499359840photos div {float:left;width:72px;}#yiv8499359840
#yiv8499359840photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8499359840
#yiv8499359840photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8499359840
#yiv8499359840reco-category {font-size:77%;}#yiv8499359840
#yiv8499359840reco-desc {font-size:77%;}#yiv8499359840 .yiv8499359840replbq
{margin:4px;}#yiv8499359840 #yiv8499359840ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8499359840 #yiv8499359840ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8499359840
#yiv8499359840ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8499359840
#yiv8499359840ygrp-mlmsg select, #yiv8499359840 input, #yiv8499359840 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8499359840
#yiv8499359840ygrp-mlmsg pre, #yiv8499359840 code {font:115%
monospace;}#yiv8499359840 #yiv8499359840ygrp-mlmsg *
{line-height:1.22em;}#yiv8499359840 #yiv8499359840ygrp-mlmsg #yiv8499359840logo
{padding-bottom:10px;}#yiv8499359840 #yiv8499359840ygrp-msg p a
{font-family:Verdana;}#yiv8499359840 #yiv8499359840ygrp-msg
p#yiv8499359840attach-count span {color:#1E66AE;font-weight:700;}#yiv8499359840
#yiv8499359840ygrp-reco #yiv8499359840reco-head
{color:#ff7900;font-weight:700;}#yiv8499359840 #yiv8499359840ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8499359840 #yiv8499359840ygrp-sponsor
#yiv8499359840ov li a {font-size:130%;text-decoration:none;}#yiv8499359840
#yiv8499359840ygrp-sponsor #yiv8499359840ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8499359840
#yiv8499359840ygrp-sponsor #yiv8499359840ov ul {margin:0;padding:0 0 0
8px;}#yiv8499359840 #yiv8499359840ygrp-text
{font-family:Georgia;}#yiv8499359840 #yiv8499359840ygrp-text p {margin:0 0 1em
0;}#yiv8499359840 #yiv8499359840ygrp-text tt {font-size:120%;}#yiv8499359840
#yiv8499359840ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8499359840