Hai Hairul,Coba Unik= False diganti menjadi Unik = True
Salam,HK
      From: "HAIRUL ALAM [email protected] [belajar-excel]" 
<[email protected]>
 To: [email protected] 
 Sent: Friday, 13 November 2015, 11:37
 Subject: [belajar-excel] Advance Filter sesuai Criteria
   
    
Yth. Para Master
Assalamualaikum
Advance Filter code yang saya buat seperti dibawah ini bisa memfilter sesuai 
criteria yang diinginkan namun tetap sesuai data input jumlah dan urutannya, 
Bagaimana cara filter dengan memisahkan data yang sama dari beberapa data 
misalkan :no. WEL-KIM-KEK-11-15-001 terdapat 5 no yang sama, 
WEL-KIM-KEK-11-15-001
WEL-KIM-KEK-11-15-001
WEL-KIM-KEK-11-15-001
WEL-KIM-KEK-11-15-001
WEL-KIM-KEK-11-15-001
no. WEL-KIM-KEK-11-15-002 terdapat 8 no yang sama 
WEL-KIM-KEK-11-15-002WEL-KIM-KEK-11-15-002
WEL-KIM-KEK-11-15-002
WEL-KIM-KEK-11-15-002
WEL-KIM-KEK-11-15-002
WEL-KIM-KEK-11-15-002
WEL-KIM-KEK-11-15-002
WEL-KIM-KEK-11-15-002
dan begitu seterusnya
saya ingin hasil dari filter tersebut muncul dengan 1 nomor dari masing masing 
dataWEL-KIM-KEK-11-15-001 qty 5
WEL-KIM-KEK-11-15-002 qty 8

code yang saya gunakan seperti dibawah :
Sub STRINGING_KM()Dim TabelData As Range, Kriteria As Range, CopyKe As Range, 
Unik As Boolean
    Set TabelData = ThisWorkbook.Sheets("TRACE").Range("A1")    Set Kriteria = 
ThisWorkbook.Sheets("MAIN").Range("C4:C5")    Set CopyKe = 
ThisWorkbook.Sheets("STR").Range("B11:AT11")    Unik = False
    TabelData.CurrentRegion.AdvancedFilter Action:=xlFilterCopy, 
CriteriaRange:=Kriteria, CopyToRange:=CopyKe, Unique:=Unik    
ThisWorkbook.Sheets("STR").Activate        
ThisWorkbook.Sheets("MAIN").Range("B2").Value = _        "STRINGING KM : " & 
JmlDataCocok & " data cocok dengan kriteria"End Sub
Mohon bantuan bagaimanakah code seperti maksud saya diatas
Terimakasih Banyak
WassalamualaikumHairul Alam  #yiv4400361002 #yiv4400361002 -- 
#yiv4400361002ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv4400361002 #yiv4400361002ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv4400361002 #yiv4400361002ygrp-mkp #yiv4400361002hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4400361002 #yiv4400361002ygrp-mkp #yiv4400361002ads 
{margin-bottom:10px;}#yiv4400361002 #yiv4400361002ygrp-mkp .yiv4400361002ad 
{padding:0 0;}#yiv4400361002 #yiv4400361002ygrp-mkp .yiv4400361002ad p 
{margin:0;}#yiv4400361002 #yiv4400361002ygrp-mkp .yiv4400361002ad a 
{color:#0000ff;text-decoration:none;}#yiv4400361002 #yiv4400361002ygrp-sponsor 
#yiv4400361002ygrp-lc {font-family:Arial;}#yiv4400361002 
#yiv4400361002ygrp-sponsor #yiv4400361002ygrp-lc #yiv4400361002hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4400361002 
#yiv4400361002ygrp-sponsor #yiv4400361002ygrp-lc .yiv4400361002ad 
{margin-bottom:10px;padding:0 0;}#yiv4400361002 #yiv4400361002actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4400361002 
#yiv4400361002activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4400361002
 #yiv4400361002activity span {font-weight:700;}#yiv4400361002 
#yiv4400361002activity span:first-child 
{text-transform:uppercase;}#yiv4400361002 #yiv4400361002activity span a 
{color:#5085b6;text-decoration:none;}#yiv4400361002 #yiv4400361002activity span 
span {color:#ff7900;}#yiv4400361002 #yiv4400361002activity span 
.yiv4400361002underline {text-decoration:underline;}#yiv4400361002 
.yiv4400361002attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4400361002 .yiv4400361002attach div a 
{text-decoration:none;}#yiv4400361002 .yiv4400361002attach img 
{border:none;padding-right:5px;}#yiv4400361002 .yiv4400361002attach label 
{display:block;margin-bottom:5px;}#yiv4400361002 .yiv4400361002attach label a 
{text-decoration:none;}#yiv4400361002 blockquote {margin:0 0 0 
4px;}#yiv4400361002 .yiv4400361002bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4400361002 
.yiv4400361002bold a {text-decoration:none;}#yiv4400361002 dd.yiv4400361002last 
p a {font-family:Verdana;font-weight:700;}#yiv4400361002 dd.yiv4400361002last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4400361002 
dd.yiv4400361002last p span.yiv4400361002yshortcuts 
{margin-right:0;}#yiv4400361002 div.yiv4400361002attach-table div div a 
{text-decoration:none;}#yiv4400361002 div.yiv4400361002attach-table 
{width:400px;}#yiv4400361002 div.yiv4400361002file-title a, #yiv4400361002 
div.yiv4400361002file-title a:active, #yiv4400361002 
div.yiv4400361002file-title a:hover, #yiv4400361002 div.yiv4400361002file-title 
a:visited {text-decoration:none;}#yiv4400361002 div.yiv4400361002photo-title a, 
#yiv4400361002 div.yiv4400361002photo-title a:active, #yiv4400361002 
div.yiv4400361002photo-title a:hover, #yiv4400361002 
div.yiv4400361002photo-title a:visited {text-decoration:none;}#yiv4400361002 
div#yiv4400361002ygrp-mlmsg #yiv4400361002ygrp-msg p a 
span.yiv4400361002yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4400361002 
.yiv4400361002green {color:#628c2a;}#yiv4400361002 .yiv4400361002MsoNormal 
{margin:0 0 0 0;}#yiv4400361002 o {font-size:0;}#yiv4400361002 
#yiv4400361002photos div {float:left;width:72px;}#yiv4400361002 
#yiv4400361002photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv4400361002 
#yiv4400361002photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4400361002
 #yiv4400361002reco-category {font-size:77%;}#yiv4400361002 
#yiv4400361002reco-desc {font-size:77%;}#yiv4400361002 .yiv4400361002replbq 
{margin:4px;}#yiv4400361002 #yiv4400361002ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv4400361002 #yiv4400361002ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4400361002 
#yiv4400361002ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4400361002 
#yiv4400361002ygrp-mlmsg select, #yiv4400361002 input, #yiv4400361002 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4400361002 
#yiv4400361002ygrp-mlmsg pre, #yiv4400361002 code {font:115% 
monospace;}#yiv4400361002 #yiv4400361002ygrp-mlmsg * 
{line-height:1.22em;}#yiv4400361002 #yiv4400361002ygrp-mlmsg #yiv4400361002logo 
{padding-bottom:10px;}#yiv4400361002 #yiv4400361002ygrp-msg p a 
{font-family:Verdana;}#yiv4400361002 #yiv4400361002ygrp-msg 
p#yiv4400361002attach-count span {color:#1E66AE;font-weight:700;}#yiv4400361002 
#yiv4400361002ygrp-reco #yiv4400361002reco-head 
{color:#ff7900;font-weight:700;}#yiv4400361002 #yiv4400361002ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv4400361002 #yiv4400361002ygrp-sponsor 
#yiv4400361002ov li a {font-size:130%;text-decoration:none;}#yiv4400361002 
#yiv4400361002ygrp-sponsor #yiv4400361002ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4400361002 
#yiv4400361002ygrp-sponsor #yiv4400361002ov ul {margin:0;padding:0 0 0 
8px;}#yiv4400361002 #yiv4400361002ygrp-text 
{font-family:Georgia;}#yiv4400361002 #yiv4400361002ygrp-text p {margin:0 0 1em 
0;}#yiv4400361002 #yiv4400361002ygrp-text tt {font-size:120%;}#yiv4400361002 
#yiv4400361002ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv4400361002 

  

Kirim email ke