Dear Ayub, Untuk Data range yang mobile(dinamis) bisa memanfaatkan NameManager,artinya data tidak terbatas sesuai dengan data yang di ambil untuk membuat NameMeneger, waktu itu khan sudah saya kasi contoh untuk membuat data range yang dinamis pada NameManager. Ok, berikut saya kasi contoh penggunaan AutoFilter pada case yang anda hadapi, semoga bisa membantu.
TerimaKasih.
Pada Sabtu, 28 Mei 2016 14:17, "Ayub Barin ayubba...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Yth, mas toby, mas hendrik, mas nang
dan Masters lainnya,Ini saya coba kirimkan filenya, walau jujur banyak malunya
saya sebab dalam file ini banyak meng akali dan tidak bnyk mengikuti kaidah
excel sebenarnya, mohon maaf krn saya minim ilmu dan pengetahuan ttng excel ini,
Demikian masters, saya haturkan banyak banyak terima kasih atas perhatian dan
semua jawab yg membantu saya.Wassalam, #yiv8000082493 #yiv8000082493 --
#yiv8000082493ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv8000082493 #yiv8000082493ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv8000082493 #yiv8000082493ygrp-mkp #yiv8000082493hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8000082493 #yiv8000082493ygrp-mkp #yiv8000082493ads
{margin-bottom:10px;}#yiv8000082493 #yiv8000082493ygrp-mkp .yiv8000082493ad
{padding:0 0;}#yiv8000082493 #yiv8000082493ygrp-mkp .yiv8000082493ad p
{margin:0;}#yiv8000082493 #yiv8000082493ygrp-mkp .yiv8000082493ad a
{color:#0000ff;text-decoration:none;}#yiv8000082493 #yiv8000082493ygrp-sponsor
#yiv8000082493ygrp-lc {font-family:Arial;}#yiv8000082493
#yiv8000082493ygrp-sponsor #yiv8000082493ygrp-lc #yiv8000082493hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8000082493
#yiv8000082493ygrp-sponsor #yiv8000082493ygrp-lc .yiv8000082493ad
{margin-bottom:10px;padding:0 0;}#yiv8000082493 #yiv8000082493actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8000082493
#yiv8000082493activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8000082493
#yiv8000082493activity span {font-weight:700;}#yiv8000082493
#yiv8000082493activity span:first-child
{text-transform:uppercase;}#yiv8000082493 #yiv8000082493activity span a
{color:#5085b6;text-decoration:none;}#yiv8000082493 #yiv8000082493activity span
span {color:#ff7900;}#yiv8000082493 #yiv8000082493activity span
.yiv8000082493underline {text-decoration:underline;}#yiv8000082493
.yiv8000082493attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8000082493 .yiv8000082493attach div a
{text-decoration:none;}#yiv8000082493 .yiv8000082493attach img
{border:none;padding-right:5px;}#yiv8000082493 .yiv8000082493attach label
{display:block;margin-bottom:5px;}#yiv8000082493 .yiv8000082493attach label a
{text-decoration:none;}#yiv8000082493 blockquote {margin:0 0 0
4px;}#yiv8000082493 .yiv8000082493bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8000082493
.yiv8000082493bold a {text-decoration:none;}#yiv8000082493 dd.yiv8000082493last
p a {font-family:Verdana;font-weight:700;}#yiv8000082493 dd.yiv8000082493last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8000082493
dd.yiv8000082493last p span.yiv8000082493yshortcuts
{margin-right:0;}#yiv8000082493 div.yiv8000082493attach-table div div a
{text-decoration:none;}#yiv8000082493 div.yiv8000082493attach-table
{width:400px;}#yiv8000082493 div.yiv8000082493file-title a, #yiv8000082493
div.yiv8000082493file-title a:active, #yiv8000082493
div.yiv8000082493file-title a:hover, #yiv8000082493 div.yiv8000082493file-title
a:visited {text-decoration:none;}#yiv8000082493 div.yiv8000082493photo-title a,
#yiv8000082493 div.yiv8000082493photo-title a:active, #yiv8000082493
div.yiv8000082493photo-title a:hover, #yiv8000082493
div.yiv8000082493photo-title a:visited {text-decoration:none;}#yiv8000082493
div#yiv8000082493ygrp-mlmsg #yiv8000082493ygrp-msg p a
span.yiv8000082493yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8000082493
.yiv8000082493green {color:#628c2a;}#yiv8000082493 .yiv8000082493MsoNormal
{margin:0 0 0 0;}#yiv8000082493 o {font-size:0;}#yiv8000082493
#yiv8000082493photos div {float:left;width:72px;}#yiv8000082493
#yiv8000082493photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8000082493
#yiv8000082493photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8000082493
#yiv8000082493reco-category {font-size:77%;}#yiv8000082493
#yiv8000082493reco-desc {font-size:77%;}#yiv8000082493 .yiv8000082493replbq
{margin:4px;}#yiv8000082493 #yiv8000082493ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8000082493 #yiv8000082493ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8000082493
#yiv8000082493ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8000082493
#yiv8000082493ygrp-mlmsg select, #yiv8000082493 input, #yiv8000082493 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8000082493
#yiv8000082493ygrp-mlmsg pre, #yiv8000082493 code {font:115%
monospace;}#yiv8000082493 #yiv8000082493ygrp-mlmsg *
{line-height:1.22em;}#yiv8000082493 #yiv8000082493ygrp-mlmsg #yiv8000082493logo
{padding-bottom:10px;}#yiv8000082493 #yiv8000082493ygrp-msg p a
{font-family:Verdana;}#yiv8000082493 #yiv8000082493ygrp-msg
p#yiv8000082493attach-count span {color:#1E66AE;font-weight:700;}#yiv8000082493
#yiv8000082493ygrp-reco #yiv8000082493reco-head
{color:#ff7900;font-weight:700;}#yiv8000082493 #yiv8000082493ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8000082493 #yiv8000082493ygrp-sponsor
#yiv8000082493ov li a {font-size:130%;text-decoration:none;}#yiv8000082493
#yiv8000082493ygrp-sponsor #yiv8000082493ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8000082493
#yiv8000082493ygrp-sponsor #yiv8000082493ov ul {margin:0;padding:0 0 0
8px;}#yiv8000082493 #yiv8000082493ygrp-text
{font-family:Georgia;}#yiv8000082493 #yiv8000082493ygrp-text p {margin:0 0 1em
0;}#yiv8000082493 #yiv8000082493ygrp-text tt {font-size:120%;}#yiv8000082493
#yiv8000082493ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8000082493
DUK dan NOMINATIF mantra excel_toby.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
