Saya sependapat dengan Mas Toby, kalau mau belajar harus step by step.
Namun sebagai user (tdk terkecuali saya), kita kan maunya siap pakai.
Tetapi ketika masalah timbul (mis butuh tambahan kolom, dsb) kita pasti akan
bingung lagi.
Jadi kalau boleh saran mungkin kita bisa mulai dengan tahapan langkah2 secara
manual dulu dengan segala macam variasinya...kemudian baru kita "otomatisasi
dengan VBA" melalui macro recording.
Untuk mulai belajar menulis VBA...bisa mampir ke blognya Be-Excel...di sana
banyak coretan Mr. Kid.
Salam,HK
----- Forwarded Message -----
From: "Toby kenzo [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, 10 March 2015, 10:28
Subject: Bls: [belajar-excel] Absensi Ronda RT
Dear Mas Agus, Bukannya setengah hati..Untuk proses pembelajaran alangkah
baiknya belajar step by step, belajar dari konsepnya trus formula apa yg di
gunakan dan tampilan yang di inginkan, kalo "matengan" malah bingung nantinya
mas..Kalo mas Agus mau belajar lebih jauh tentang VBA, monggo mas...mas Agus
bias share di forum ini dan kami di sini pasti membantu... TerimaKasih.
Pada Selasa, 10 Maret 2015 9:34, "uharyanto [email protected]
[belajar-excel]" <[email protected]> menulis:
Sungguh sayang sekali nge share nya setengah hati nih, ada protect nya.
On 10/03/2015 12:28 AM, Toby kenzo [email protected] [belajar-excel] wrote:
| Dear Mas Agus, Berikut filenya untuk absensi ronda, mungkin bisa membantu.
Filenya menggunakan VBA, jd harus di active kan dulu dgn mengclick macro
enablednya. Maaf, filenya saya protect, mas Agus tinggal isi di sheet
kehadiran/absen dan langsung click tombol check maka jumlah ketidak hadiran
akan muncul di sheet rekap yg tidak hadir. Semoga bermanfaat. TerimaKasih. Sent
from Yahoo Mail on Android |
From: 'Agus Widodo' [email protected] [belajar-excel]
<[email protected]>;
To: <[email protected]>;
Subject: [belajar-excel] Absensi Ronda RT [1 Attachment]
Sent: Mon, Mar 9, 2015 9:07:51 AM
|
| Dear All Master, Mohon Bantuannya terkait dengan Problem yang sedang saya
alami ini : Bagaimana Caranya supaya di sheet TIDAK HADIR INI muncul secara
otomatis nama beserta semua data absensi dan juga denda karena saya harus
Input data sampai ratusan ke bawah dan kalau saya buat manual satu persatu
masih ada data yang kembar / doble antara sheet hadir dan sheet tidak hadir
Mohon sekiranya para master menyempatkan waktunya untuk membantu masalah saya
ini. Sekian Atas perhatiannya saya ucapkan Matur Nuwun Sanget. Salam, Guswi
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#yiv7779479193 #yiv7779479193 -- #yiv7779479193ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7779479193
#yiv7779479193ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7779479193
#yiv7779479193ygrp-mkp #yiv7779479193hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7779479193 #yiv7779479193ygrp-mkp #yiv7779479193ads
{margin-bottom:10px;}#yiv7779479193 #yiv7779479193ygrp-mkp .yiv7779479193ad
{padding:0 0;}#yiv7779479193 #yiv7779479193ygrp-mkp .yiv7779479193ad p
{margin:0;}#yiv7779479193 #yiv7779479193ygrp-mkp .yiv7779479193ad a
{color:#0000ff;text-decoration:none;}#yiv7779479193 #yiv7779479193ygrp-sponsor
#yiv7779479193ygrp-lc {font-family:Arial;}#yiv7779479193
#yiv7779479193ygrp-sponsor #yiv7779479193ygrp-lc #yiv7779479193hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7779479193
#yiv7779479193ygrp-sponsor #yiv7779479193ygrp-lc .yiv7779479193ad
{margin-bottom:10px;padding:0 0;}#yiv7779479193 #yiv7779479193actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7779479193
#yiv7779479193activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7779479193
#yiv7779479193activity span {font-weight:700;}#yiv7779479193
#yiv7779479193activity span:first-child
{text-transform:uppercase;}#yiv7779479193 #yiv7779479193activity span a
{color:#5085b6;text-decoration:none;}#yiv7779479193 #yiv7779479193activity span
span {color:#ff7900;}#yiv7779479193 #yiv7779479193activity span
.yiv7779479193underline {text-decoration:underline;}#yiv7779479193
.yiv7779479193attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7779479193 .yiv7779479193attach div a
{text-decoration:none;}#yiv7779479193 .yiv7779479193attach img
{border:none;padding-right:5px;}#yiv7779479193 .yiv7779479193attach label
{display:block;margin-bottom:5px;}#yiv7779479193 .yiv7779479193attach label a
{text-decoration:none;}#yiv7779479193 blockquote {margin:0 0 0
4px;}#yiv7779479193 .yiv7779479193bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7779479193
.yiv7779479193bold a {text-decoration:none;}#yiv7779479193 dd.yiv7779479193last
p a {font-family:Verdana;font-weight:700;}#yiv7779479193 dd.yiv7779479193last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7779479193
dd.yiv7779479193last p span.yiv7779479193yshortcuts
{margin-right:0;}#yiv7779479193 div.yiv7779479193attach-table div div a
{text-decoration:none;}#yiv7779479193 div.yiv7779479193attach-table
{width:400px;}#yiv7779479193 div.yiv7779479193file-title a, #yiv7779479193
div.yiv7779479193file-title a:active, #yiv7779479193
div.yiv7779479193file-title a:hover, #yiv7779479193 div.yiv7779479193file-title
a:visited {text-decoration:none;}#yiv7779479193 div.yiv7779479193photo-title a,
#yiv7779479193 div.yiv7779479193photo-title a:active, #yiv7779479193
div.yiv7779479193photo-title a:hover, #yiv7779479193
div.yiv7779479193photo-title a:visited {text-decoration:none;}#yiv7779479193
div#yiv7779479193ygrp-mlmsg #yiv7779479193ygrp-msg p a
span.yiv7779479193yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7779479193
.yiv7779479193green {color:#628c2a;}#yiv7779479193 .yiv7779479193MsoNormal
{margin:0 0 0 0;}#yiv7779479193 o {font-size:0;}#yiv7779479193
#yiv7779479193photos div {float:left;width:72px;}#yiv7779479193
#yiv7779479193photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7779479193
#yiv7779479193photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7779479193
#yiv7779479193reco-category {font-size:77%;}#yiv7779479193
#yiv7779479193reco-desc {font-size:77%;}#yiv7779479193 .yiv7779479193replbq
{margin:4px;}#yiv7779479193 #yiv7779479193ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7779479193 #yiv7779479193ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7779479193
#yiv7779479193ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7779479193
#yiv7779479193ygrp-mlmsg select, #yiv7779479193 input, #yiv7779479193 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7779479193
#yiv7779479193ygrp-mlmsg pre, #yiv7779479193 code {font:115%
monospace;}#yiv7779479193 #yiv7779479193ygrp-mlmsg *
{line-height:1.22em;}#yiv7779479193 #yiv7779479193ygrp-mlmsg #yiv7779479193logo
{padding-bottom:10px;}#yiv7779479193 #yiv7779479193ygrp-msg p a
{font-family:Verdana;}#yiv7779479193 #yiv7779479193ygrp-msg
p#yiv7779479193attach-count span {color:#1E66AE;font-weight:700;}#yiv7779479193
#yiv7779479193ygrp-reco #yiv7779479193reco-head
{color:#ff7900;font-weight:700;}#yiv7779479193 #yiv7779479193ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7779479193 #yiv7779479193ygrp-sponsor
#yiv7779479193ov li a {font-size:130%;text-decoration:none;}#yiv7779479193
#yiv7779479193ygrp-sponsor #yiv7779479193ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7779479193
#yiv7779479193ygrp-sponsor #yiv7779479193ov ul {margin:0;padding:0 0 0
8px;}#yiv7779479193 #yiv7779479193ygrp-text
{font-family:Georgia;}#yiv7779479193 #yiv7779479193ygrp-text p {margin:0 0 1em
0;}#yiv7779479193 #yiv7779479193ygrp-text tt {font-size:120%;}#yiv7779479193
#yiv7779479193ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7779479193
