Re: [belajar-excel] filter sesuai data di sheet terpilih [1 Attachment]

2016-10-25 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] 
Hai Didon,

Terlampir contohnya.

Regards,
Kid






2016-10-24 21:34 GMT+07:00 achmad adi dido...@ymail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> dear master,,,
> saya mencoba membuat adv filter tapi hanya di sheet 1 aja yang bisa
> difilter...
> yang ingin saya tanyakan,,,
> seadainya saya ingin memfilter data tetapi berdasarkan data sheet
> terpilih..
> bagaimanakah caranya...
> mohon pencerahaannya,,,saya lampirkan file
>
> sebelumnya saya sampaikan terimakasih
>
> 
>


re-Filter Sesuai Data di Sheet Terpilih.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Bls: [belajar-excel] filter sesuai data di sheet terpilih [1 Attachment]

2016-10-25 Terurut Topik Toby kenzo tobyke...@yahoo.co.id [belajar-excel] 
Dear Didon,
Berikut saya kasi contohnya, untuk kriteria berdasarkan NIP dan Sheet aja.
TerimaKasih. 

Pada Selasa, 25 Oktober 2016 4:22, "achmad adi dido...@ymail.com 
[belajar-excel]"  menulis:
 

     dear master,,,saya mencoba membuat adv filter tapi hanya di sheet 1 aja 
yang bisa difilter...yang ingin saya tanyakan,,,seadainya saya ingin memfilter 
data tetapi berdasarkan data sheet terpilih..bagaimanakah caranya...mohon 
pencerahaannya,,,saya lampirkan file 

sebelumnya saya sampaikan terimakasih
  #yiv5356342215 #yiv5356342215 -- #yiv5356342215ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5356342215 
#yiv5356342215ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5356342215 
#yiv5356342215ygrp-mkp #yiv5356342215hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5356342215 #yiv5356342215ygrp-mkp #yiv5356342215ads 
{margin-bottom:10px;}#yiv5356342215 #yiv5356342215ygrp-mkp .yiv5356342215ad 
{padding:0 0;}#yiv5356342215 #yiv5356342215ygrp-mkp .yiv5356342215ad p 
{margin:0;}#yiv5356342215 #yiv5356342215ygrp-mkp .yiv5356342215ad a 
{color:#ff;text-decoration:none;}#yiv5356342215 #yiv5356342215ygrp-sponsor 
#yiv5356342215ygrp-lc {font-family:Arial;}#yiv5356342215 
#yiv5356342215ygrp-sponsor #yiv5356342215ygrp-lc #yiv5356342215hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5356342215 
#yiv5356342215ygrp-sponsor #yiv5356342215ygrp-lc .yiv5356342215ad 
{margin-bottom:10px;padding:0 0;}#yiv5356342215 #yiv5356342215actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5356342215 
#yiv5356342215activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5356342215
 #yiv5356342215activity span {font-weight:700;}#yiv5356342215 
#yiv5356342215activity span:first-child 
{text-transform:uppercase;}#yiv5356342215 #yiv5356342215activity span a 
{color:#5085b6;text-decoration:none;}#yiv5356342215 #yiv5356342215activity span 
span {color:#ff7900;}#yiv5356342215 #yiv5356342215activity span 
.yiv5356342215underline {text-decoration:underline;}#yiv5356342215 
.yiv5356342215attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv5356342215 .yiv5356342215attach div a 
{text-decoration:none;}#yiv5356342215 .yiv5356342215attach img 
{border:none;padding-right:5px;}#yiv5356342215 .yiv5356342215attach label 
{display:block;margin-bottom:5px;}#yiv5356342215 .yiv5356342215attach label a 
{text-decoration:none;}#yiv5356342215 blockquote {margin:0 0 0 
4px;}#yiv5356342215 .yiv5356342215bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5356342215 
.yiv5356342215bold a {text-decoration:none;}#yiv5356342215 dd.yiv5356342215last 
p a {font-family:Verdana;font-weight:700;}#yiv5356342215 dd.yiv5356342215last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5356342215 
dd.yiv5356342215last p span.yiv5356342215yshortcuts 
{margin-right:0;}#yiv5356342215 div.yiv5356342215attach-table div div a 
{text-decoration:none;}#yiv5356342215 div.yiv5356342215attach-table 
{width:400px;}#yiv5356342215 div.yiv5356342215file-title a, #yiv5356342215 
div.yiv5356342215file-title a:active, #yiv5356342215 
div.yiv5356342215file-title a:hover, #yiv5356342215 div.yiv5356342215file-title 
a:visited {text-decoration:none;}#yiv5356342215 div.yiv5356342215photo-title a, 
#yiv5356342215 div.yiv5356342215photo-title a:active, #yiv5356342215 
div.yiv5356342215photo-title a:hover, #yiv5356342215 
div.yiv5356342215photo-title a:visited {text-decoration:none;}#yiv5356342215 
div#yiv5356342215ygrp-mlmsg #yiv5356342215ygrp-msg p a 
span.yiv5356342215yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5356342215 
.yiv5356342215green {color:#628c2a;}#yiv5356342215 .yiv5356342215MsoNormal 
{margin:0 0 0 0;}#yiv5356342215 o {font-size:0;}#yiv5356342215 
#yiv5356342215photos div {float:left;width:72px;}#yiv5356342215 
#yiv5356342215photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv5356342215 
#yiv5356342215photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5356342215
 #yiv5356342215reco-category {font-size:77%;}#yiv5356342215 
#yiv5356342215reco-desc {font-size:77%;}#yiv5356342215 .yiv5356342215replbq 
{margin:4px;}#yiv5356342215 #yiv5356342215ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv5356342215 #yiv5356342215ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5356342215 
#yiv5356342215ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5356342215 
#yiv5356342215ygrp-mlmsg select, #yiv5356342215 input, #yiv5356342215 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5356342215 
#yiv5356342215ygrp-mlmsg pre, #yiv5356342215 code {font:115% 
monospace;}#yiv5356342215 #yiv5356342215ygrp-mlmsg * 
{line-height:1.22em;}#yiv5356342215

Re: [belajar-excel] filter sesuai data di sheet terpilih [1 Attachment]

2016-10-24 Terurut Topik hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] 
Coba yang ini.
Salam,HK

  From: "achmad adi dido...@ymail.com [belajar-excel]" 
<belajar-excel@yahoogroups.com>
 To: belajar-excel@yahoogroups.com 
 Sent: Monday, 24 October 2016, 21:34
 Subject: [belajar-excel] filter sesuai data di sheet terpilih [1 Attachment]
   
    dear master,,,saya mencoba membuat adv filter tapi hanya di sheet 1 aja 
yang bisa difilter...yang ingin saya tanyakan,,,seadainya saya ingin memfilter 
data tetapi berdasarkan data sheet terpilih..bagaimanakah caranya...mohon 
pencerahaannya,,,saya lampirkan file 

sebelumnya saya sampaikan terimakasih
  #yiv8106867230 #yiv8106867230 -- #yiv8106867230ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8106867230 
#yiv8106867230ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8106867230 
#yiv8106867230ygrp-mkp #yiv8106867230hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8106867230 #yiv8106867230ygrp-mkp #yiv8106867230ads 
{margin-bottom:10px;}#yiv8106867230 #yiv8106867230ygrp-mkp .yiv8106867230ad 
{padding:0 0;}#yiv8106867230 #yiv8106867230ygrp-mkp .yiv8106867230ad p 
{margin:0;}#yiv8106867230 #yiv8106867230ygrp-mkp .yiv8106867230ad a 
{color:#ff;text-decoration:none;}#yiv8106867230 #yiv8106867230ygrp-sponsor 
#yiv8106867230ygrp-lc {font-family:Arial;}#yiv8106867230 
#yiv8106867230ygrp-sponsor #yiv8106867230ygrp-lc #yiv8106867230hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8106867230 
#yiv8106867230ygrp-sponsor #yiv8106867230ygrp-lc .yiv8106867230ad 
{margin-bottom:10px;padding:0 0;}#yiv8106867230 #yiv8106867230actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8106867230 
#yiv8106867230activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8106867230
 #yiv8106867230activity span {font-weight:700;}#yiv8106867230 
#yiv8106867230activity span:first-child 
{text-transform:uppercase;}#yiv8106867230 #yiv8106867230activity span a 
{color:#5085b6;text-decoration:none;}#yiv8106867230 #yiv8106867230activity span 
span {color:#ff7900;}#yiv8106867230 #yiv8106867230activity span 
.yiv8106867230underline {text-decoration:underline;}#yiv8106867230 
.yiv8106867230attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8106867230 .yiv8106867230attach div a 
{text-decoration:none;}#yiv8106867230 .yiv8106867230attach img 
{border:none;padding-right:5px;}#yiv8106867230 .yiv8106867230attach label 
{display:block;margin-bottom:5px;}#yiv8106867230 .yiv8106867230attach label a 
{text-decoration:none;}#yiv8106867230 blockquote {margin:0 0 0 
4px;}#yiv8106867230 .yiv8106867230bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8106867230 
.yiv8106867230bold a {text-decoration:none;}#yiv8106867230 dd.yiv8106867230last 
p a {font-family:Verdana;font-weight:700;}#yiv8106867230 dd.yiv8106867230last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8106867230 
dd.yiv8106867230last p span.yiv8106867230yshortcuts 
{margin-right:0;}#yiv8106867230 div.yiv8106867230attach-table div div a 
{text-decoration:none;}#yiv8106867230 div.yiv8106867230attach-table 
{width:400px;}#yiv8106867230 div.yiv8106867230file-title a, #yiv8106867230 
div.yiv8106867230file-title a:active, #yiv8106867230 
div.yiv8106867230file-title a:hover, #yiv8106867230 div.yiv8106867230file-title 
a:visited {text-decoration:none;}#yiv8106867230 div.yiv8106867230photo-title a, 
#yiv8106867230 div.yiv8106867230photo-title a:active, #yiv8106867230 
div.yiv8106867230photo-title a:hover, #yiv8106867230 
div.yiv8106867230photo-title a:visited {text-decoration:none;}#yiv8106867230 
div#yiv8106867230ygrp-mlmsg #yiv8106867230ygrp-msg p a 
span.yiv8106867230yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8106867230 
.yiv8106867230green {color:#628c2a;}#yiv8106867230 .yiv8106867230MsoNormal 
{margin:0 0 0 0;}#yiv8106867230 o {font-size:0;}#yiv8106867230 
#yiv8106867230photos div {float:left;width:72px;}#yiv8106867230 
#yiv8106867230photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv8106867230 
#yiv8106867230photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8106867230
 #yiv8106867230reco-category {font-size:77%;}#yiv8106867230 
#yiv8106867230reco-desc {font-size:77%;}#yiv8106867230 .yiv8106867230replbq 
{margin:4px;}#yiv8106867230 #yiv8106867230ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8106867230 #yiv8106867230ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8106867230 
#yiv8106867230ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8106867230 
#yiv8106867230ygrp-mlmsg select, #yiv8106867230 input, #yiv8106867230 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8106867230 
#yiv8106867230ygrp-mlmsg pre, #yiv8106867230 code {font:115% 
monospace;}#yiv8106867230 #yiv8106

[belajar-excel] filter sesuai data di sheet terpilih [1 Attachment]

2016-10-24 Terurut Topik achmad adi dido...@ymail.com [belajar-excel] 
dear master,,,saya mencoba membuat adv filter tapi hanya di sheet 1 aja yang 
bisa difilter...yang ingin saya tanyakan,,,seadainya saya ingin memfilter data 
tetapi berdasarkan data sheet terpilih..bagaimanakah caranya...mohon 
pencerahaannya,,,saya lampirkan file 


sebelumnya saya sampaikan terimakasih


FILTER SESUAI DATA DI SHEET TERPILIH.rar
Description: Binary data