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