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' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> 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 upie...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: 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