Coba lakukan dengan rekaman macro.Kemudian dibuat macro untuk mencari baris baru pada sheet database.Buat macro untuk proses loopingnya. Selamat mencoba. Salam,HK
Sent from Yahoo Mail on Android On Fri, May 4, 2018 at 17:17, adechandrawida...@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote: Selamat Sore, Salam Kenal... saya mau tanya tentang sourecode vbexcel nih... saya lagi buat aplikasi input data KRS mahasiswa & saya mengalami kendala, kiranya Master bisa membantu saya. Sheet InputData di Kolom A1 = Nama di Kolom A2 = NIM di Kolom A3-A13 = Mata Kuliah 1 - 12 yang diambil mahasiswa, dan ada tombol Simpan menggunakan Shape ( Bukan Axtive COntrol Button ) Sheet Database di Kolom A2 = maunya terisi No. Secara Otomatis di Kolom B2 = Nama ( yang terinput dari sheetInpuData ) di Kolom C2 = NIM ( yang terinput dari sheetInpuData ) di Kolom D2-D baris terakhir = Mata Kuliah 1 - 12 ( yang diambil dari sheetInpuData ), dan ketika menginputkan Nama Mahasiswa Lainnya, Datanya masuk kedalam sheet database (dibawah data mahasiswa yang ambil Pertama ). Mohon Bantuannya dari para Master... Terima Kasih #yiv3829010743 #yiv3829010743 -- #yiv3829010743ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3829010743 #yiv3829010743ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3829010743 #yiv3829010743ygrp-mkp #yiv3829010743hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3829010743 #yiv3829010743ygrp-mkp #yiv3829010743ads {margin-bottom:10px;}#yiv3829010743 #yiv3829010743ygrp-mkp .yiv3829010743ad {padding:0 0;}#yiv3829010743 #yiv3829010743ygrp-mkp .yiv3829010743ad p {margin:0;}#yiv3829010743 #yiv3829010743ygrp-mkp .yiv3829010743ad a {color:#0000ff;text-decoration:none;}#yiv3829010743 #yiv3829010743ygrp-sponsor #yiv3829010743ygrp-lc {font-family:Arial;}#yiv3829010743 #yiv3829010743ygrp-sponsor #yiv3829010743ygrp-lc #yiv3829010743hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3829010743 #yiv3829010743ygrp-sponsor #yiv3829010743ygrp-lc .yiv3829010743ad {margin-bottom:10px;padding:0 0;}#yiv3829010743 #yiv3829010743actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3829010743 #yiv3829010743activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3829010743 #yiv3829010743activity span {font-weight:700;}#yiv3829010743 #yiv3829010743activity span:first-child {text-transform:uppercase;}#yiv3829010743 #yiv3829010743activity span a {color:#5085b6;text-decoration:none;}#yiv3829010743 #yiv3829010743activity span span {color:#ff7900;}#yiv3829010743 #yiv3829010743activity span .yiv3829010743underline {text-decoration:underline;}#yiv3829010743 .yiv3829010743attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3829010743 .yiv3829010743attach div a {text-decoration:none;}#yiv3829010743 .yiv3829010743attach img {border:none;padding-right:5px;}#yiv3829010743 .yiv3829010743attach label {display:block;margin-bottom:5px;}#yiv3829010743 .yiv3829010743attach label a {text-decoration:none;}#yiv3829010743 blockquote {margin:0 0 0 4px;}#yiv3829010743 .yiv3829010743bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3829010743 .yiv3829010743bold a {text-decoration:none;}#yiv3829010743 dd.yiv3829010743last p a {font-family:Verdana;font-weight:700;}#yiv3829010743 dd.yiv3829010743last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3829010743 dd.yiv3829010743last p span.yiv3829010743yshortcuts {margin-right:0;}#yiv3829010743 div.yiv3829010743attach-table div div a {text-decoration:none;}#yiv3829010743 div.yiv3829010743attach-table {width:400px;}#yiv3829010743 div.yiv3829010743file-title a, #yiv3829010743 div.yiv3829010743file-title a:active, #yiv3829010743 div.yiv3829010743file-title a:hover, #yiv3829010743 div.yiv3829010743file-title a:visited {text-decoration:none;}#yiv3829010743 div.yiv3829010743photo-title a, #yiv3829010743 div.yiv3829010743photo-title a:active, #yiv3829010743 div.yiv3829010743photo-title a:hover, #yiv3829010743 div.yiv3829010743photo-title a:visited {text-decoration:none;}#yiv3829010743 div#yiv3829010743ygrp-mlmsg #yiv3829010743ygrp-msg p a span.yiv3829010743yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3829010743 .yiv3829010743green {color:#628c2a;}#yiv3829010743 .yiv3829010743MsoNormal {margin:0 0 0 0;}#yiv3829010743 o {font-size:0;}#yiv3829010743 #yiv3829010743photos div {float:left;width:72px;}#yiv3829010743 #yiv3829010743photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3829010743 #yiv3829010743photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3829010743 #yiv3829010743reco-category {font-size:77%;}#yiv3829010743 #yiv3829010743reco-desc {font-size:77%;}#yiv3829010743 .yiv3829010743replbq {margin:4px;}#yiv3829010743 #yiv3829010743ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3829010743 #yiv3829010743ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3829010743 #yiv3829010743ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3829010743 #yiv3829010743ygrp-mlmsg select, #yiv3829010743 input, #yiv3829010743 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3829010743 #yiv3829010743ygrp-mlmsg pre, #yiv3829010743 code {font:115% monospace;}#yiv3829010743 #yiv3829010743ygrp-mlmsg * {line-height:1.22em;}#yiv3829010743 #yiv3829010743ygrp-mlmsg #yiv3829010743logo {padding-bottom:10px;}#yiv3829010743 #yiv3829010743ygrp-msg p a {font-family:Verdana;}#yiv3829010743 #yiv3829010743ygrp-msg p#yiv3829010743attach-count span {color:#1E66AE;font-weight:700;}#yiv3829010743 #yiv3829010743ygrp-reco #yiv3829010743reco-head {color:#ff7900;font-weight:700;}#yiv3829010743 #yiv3829010743ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3829010743 #yiv3829010743ygrp-sponsor #yiv3829010743ov li a {font-size:130%;text-decoration:none;}#yiv3829010743 #yiv3829010743ygrp-sponsor #yiv3829010743ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3829010743 #yiv3829010743ygrp-sponsor #yiv3829010743ov ul {margin:0;padding:0 0 0 8px;}#yiv3829010743 #yiv3829010743ygrp-text {font-family:Georgia;}#yiv3829010743 #yiv3829010743ygrp-text p {margin:0 0 1em 0;}#yiv3829010743 #yiv3829010743ygrp-text tt {font-size:120%;}#yiv3829010743 #yiv3829010743ygrp-vital ul li:last-child {border-right:none !important;}#yiv3829010743