Assalamualaikum
Terimakasih Penjelasannya Pak KID
Maaf kalau saya udah mengganggu selama ini, karena emang saya kurang mengerti
dan masih tahap belajar makanya saya sering bertanya
Sukses selalu Mail belajar-excel@yahoogroups.com
Wassalamualaikum
Pada Senin, 9 November 2015 16:42, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
Hai Hairul,
Ingin dibuatkan atau mau mencoba membuat sendiri ?
Kalau mau mencoba membuat sendiri, proses belajarnya begini :
1. coba lakukan autofilter manual sesuai kebutuhan Anda, misal dari date sekian
sampai sekian (tidak perlu VBA dulu).
2. Kalau sudah bisa menggunakan autofilter secara manual, coba catat setiap
langkah yang Anda lakukan secara manual tadi.
3. Posting deh kemilis setiap langkah yang sudah dicatat di nomor 2.
btw,
biasanya pengguna Excel enggan belajar lagi dan lebih suka menunggu sembari
re-post terus menerus.
untungnya, ada saja BeExceller yang tega membuat member yang enggan belajar
untuk tetap tidak belajar dan terus menunggu jadinya, dengan memberi solusi
jadinya.
ya begitulah adanya...
Maaf kalau kurang berkenan.
Wassalamu'alaikum wr wb
Kid
2015-11-09 14:18 GMT+07:00 HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:
Assalamualaikum
Yth. Para Master
Terlampir file excel yang saya mau buat filter VBA, bisakah dibantu untuk code
VBA pada kasus saya
TerimakasihWassalamualaikum
#yiv8931412708 #yiv8931412708 -- #yiv8931412708ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8931412708
#yiv8931412708ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8931412708
#yiv8931412708ygrp-mkp #yiv8931412708hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8931412708 #yiv8931412708ygrp-mkp #yiv8931412708ads
{margin-bottom:10px;}#yiv8931412708 #yiv8931412708ygrp-mkp .yiv8931412708ad
{padding:0 0;}#yiv8931412708 #yiv8931412708ygrp-mkp .yiv8931412708ad p
{margin:0;}#yiv8931412708 #yiv8931412708ygrp-mkp .yiv8931412708ad a
{color:#0000ff;text-decoration:none;}#yiv8931412708 #yiv8931412708ygrp-sponsor
#yiv8931412708ygrp-lc {font-family:Arial;}#yiv8931412708
#yiv8931412708ygrp-sponsor #yiv8931412708ygrp-lc #yiv8931412708hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8931412708
#yiv8931412708ygrp-sponsor #yiv8931412708ygrp-lc .yiv8931412708ad
{margin-bottom:10px;padding:0 0;}#yiv8931412708 #yiv8931412708actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8931412708
#yiv8931412708activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8931412708
#yiv8931412708activity span {font-weight:700;}#yiv8931412708
#yiv8931412708activity span:first-child
{text-transform:uppercase;}#yiv8931412708 #yiv8931412708activity span a
{color:#5085b6;text-decoration:none;}#yiv8931412708 #yiv8931412708activity span
span {color:#ff7900;}#yiv8931412708 #yiv8931412708activity span
.yiv8931412708underline {text-decoration:underline;}#yiv8931412708
.yiv8931412708attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8931412708 .yiv8931412708attach div a
{text-decoration:none;}#yiv8931412708 .yiv8931412708attach img
{border:none;padding-right:5px;}#yiv8931412708 .yiv8931412708attach label
{display:block;margin-bottom:5px;}#yiv8931412708 .yiv8931412708attach label a
{text-decoration:none;}#yiv8931412708 blockquote {margin:0 0 0
4px;}#yiv8931412708 .yiv8931412708bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8931412708
.yiv8931412708bold a {text-decoration:none;}#yiv8931412708 dd.yiv8931412708last
p a {font-family:Verdana;font-weight:700;}#yiv8931412708 dd.yiv8931412708last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8931412708
dd.yiv8931412708last p span.yiv8931412708yshortcuts
{margin-right:0;}#yiv8931412708 div.yiv8931412708attach-table div div a
{text-decoration:none;}#yiv8931412708 div.yiv8931412708attach-table
{width:400px;}#yiv8931412708 div.yiv8931412708file-title a, #yiv8931412708
div.yiv8931412708file-title a:active, #yiv8931412708
div.yiv8931412708file-title a:hover, #yiv8931412708 div.yiv8931412708file-title
a:visited {text-decoration:none;}#yiv8931412708 div.yiv8931412708photo-title a,
#yiv8931412708 div.yiv8931412708photo-title a:active, #yiv8931412708
div.yiv8931412708photo-title a:hover, #yiv8931412708
div.yiv8931412708photo-title a:visited {text-decoration:none;}#yiv8931412708
div#yiv8931412708ygrp-mlmsg #yiv8931412708ygrp-msg p a
span.yiv8931412708yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8931412708
.yiv8931412708green {color:#628c2a;}#yiv8931412708 .yiv8931412708MsoNormal
{margin:0 0 0 0;}#yiv8931412708 o {font-size:0;}#yiv8931412708
#yiv8931412708photos div {float:left;width:72px;}#yiv8931412708
#yiv8931412708photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8931412708
#yiv8931412708photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8931412708
#yiv8931412708reco-category {font-size:77%;}#yiv8931412708
#yiv8931412708reco-desc {font-size:77%;}#yiv8931412708 .yiv8931412708replbq
{margin:4px;}#yiv8931412708 #yiv8931412708ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8931412708 #yiv8931412708ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8931412708
#yiv8931412708ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8931412708
#yiv8931412708ygrp-mlmsg select, #yiv8931412708 input, #yiv8931412708 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8931412708
#yiv8931412708ygrp-mlmsg pre, #yiv8931412708 code {font:115%
monospace;}#yiv8931412708 #yiv8931412708ygrp-mlmsg *
{line-height:1.22em;}#yiv8931412708 #yiv8931412708ygrp-mlmsg #yiv8931412708logo
{padding-bottom:10px;}#yiv8931412708 #yiv8931412708ygrp-msg p a
{font-family:Verdana;}#yiv8931412708 #yiv8931412708ygrp-msg
p#yiv8931412708attach-count span {color:#1E66AE;font-weight:700;}#yiv8931412708
#yiv8931412708ygrp-reco #yiv8931412708reco-head
{color:#ff7900;font-weight:700;}#yiv8931412708 #yiv8931412708ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8931412708 #yiv8931412708ygrp-sponsor
#yiv8931412708ov li a {font-size:130%;text-decoration:none;}#yiv8931412708
#yiv8931412708ygrp-sponsor #yiv8931412708ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8931412708
#yiv8931412708ygrp-sponsor #yiv8931412708ov ul {margin:0;padding:0 0 0
8px;}#yiv8931412708 #yiv8931412708ygrp-text
{font-family:Georgia;}#yiv8931412708 #yiv8931412708ygrp-text p {margin:0 0 1em
0;}#yiv8931412708 #yiv8931412708ygrp-text tt {font-size:120%;}#yiv8931412708
#yiv8931412708ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8931412708
