Hai Omez,Perhatikan pesan kesalahannya."The extract range has a missing or illegal field name" Penulisan Judul kolom pada Input, Kriteria dan Ouput harus persis sama, walaupun jumlah kolom outputnya tidak harus sama dengan jumlah kolom input dan tidak boleh ada judul yang kosong. Coba cek judul kolomnya satu persatu lagi...ada beberapa perbedaan di sana. Salam,HK
From: "Icat Omez [email protected] [belajar-excel]" <[email protected]> To: [email protected] Sent: Monday, 23 February 2015, 14:12 Subject: Bls: Bls: [belajar-excel] memangil data sesuai kriteria ke sheet baru [1 Attachment] Kalau ini kira2 kenapa koq belum bisa.apakah karena terlalu banyak range atau gmn Terima Kasih Pada Minggu, 22 Februari 2015 11:48, "Hendrik Karnadi [email protected] [belajar-excel]" <[email protected]> menulis: Hai Omez,Langkah2nya adalah sbb:1. Select sheet Rekap, blok Judul pada sheet tsb2. Klik View, Macro Recording (Excel 2007 ke atas)3. Klik Data, Advance Filter4. Pilih Copy to another sheet, isi kolom sumber, kriteria dan hasil dengan cara memblok rangenya5. Klik unique value, ok6. Klik stop recording. Update macronya pada VBE sheet, Module1 yang ditulis secara otomatis oleh komputer sesuai langkah2 3 s/d 5 di atas.Yang diupdate adalah range sumbernya, menjadi Range ("A1").CurrentRegion dan tambahkan Sheets ("Rekap") pada CrìteriaRange dan CopytoRange, sehingga hasilnya seperti tertulis pada bag bawah. Selamat mencoba. Salam,HK Sent from Samsung Mobile -------- Original message --------From: "Icat Omez [email protected] [belajar-excel]" Date:21/02/2015 23:29 (GMT+07:00) To: [email protected] Subject: Bls: [belajar-excel] memangil data sesuai kriteria ke sheet baru dear master HKtolong di jelaskan langkah2nya dari awal harus seperti apa,,saya sudah berhaasil mengunakan macro itu,tpi saya pgin tahu prosesnya terima kasih,,, terima kasih sebelumnya atas bantuanya salamOmez Pada Sabtu, 21 Februari 2015 18:38, "hendrik karnadi [email protected] [belajar-excel]" <[email protected]> menulis: Mau pakai macro?Coba copas hasil (edit) rekaman macro ini pada module VBE Sheet,Sub Filt_ke_Shlain() 'macro hasil rekaman dari Sheets("Rekap")(diedit sheetnya) Sheets("DATA").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("REKAP").Range("I1:J2"), CopyToRange:=Sheets("REKAP").Range("B7:H7"), Unique:=TrueEnd Sub Kalau No urutnya mau dibuat mulai dari No 1...sila dibuat rekaman macro tersendiri...kmdn digabung dengan macro di atas. Salam,HK NB:Kriterianya harus pas penulisannya From: "omeza [email protected] [belajar-excel]" <[email protected]> To: [email protected] Sent: Saturday, 21 February 2015, 13:19 Subject: [belajar-excel] memangil data sesuai kriteria ke sheet baru Dear Para Master,, bagaimana memangil data ke sheet baru dengan criteria.. saya lampirkan file di sini.. terima kasih wasalam Book1.xlsx <http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729222/Book1.xlsx> -- View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/memangil-data-sesuai-kriteria-ke-sheet-baru-tp5729222.html Sent from the Milis Belajar Excel mailing list archive at Nabble.com. #yiv5127084346 -- #yiv5127084346ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5127084346 #yiv5127084346ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5127084346 #yiv5127084346ygrp-mkp #yiv5127084346hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5127084346 #yiv5127084346ygrp-mkp #yiv5127084346ads {margin-bottom:10px;}#yiv5127084346 #yiv5127084346ygrp-mkp .yiv5127084346ad {padding:0 0;}#yiv5127084346 #yiv5127084346ygrp-mkp .yiv5127084346ad p {margin:0;}#yiv5127084346 #yiv5127084346ygrp-mkp .yiv5127084346ad a {color:#0000ff;text-decoration:none;}#yiv5127084346 #yiv5127084346ygrp-sponsor #yiv5127084346ygrp-lc {font-family:Arial;}#yiv5127084346 #yiv5127084346ygrp-sponsor #yiv5127084346ygrp-lc #yiv5127084346hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5127084346 #yiv5127084346ygrp-sponsor #yiv5127084346ygrp-lc .yiv5127084346ad {margin-bottom:10px;padding:0 0;}#yiv5127084346 #yiv5127084346actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5127084346 #yiv5127084346activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5127084346 #yiv5127084346activity span {font-weight:700;}#yiv5127084346 #yiv5127084346activity span:first-child {text-transform:uppercase;}#yiv5127084346 #yiv5127084346activity span a {color:#5085b6;text-decoration:none;}#yiv5127084346 #yiv5127084346activity span span {color:#ff7900;}#yiv5127084346 #yiv5127084346activity span .yiv5127084346underline {text-decoration:underline;}#yiv5127084346 .yiv5127084346attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5127084346 .yiv5127084346attach div a {text-decoration:none;}#yiv5127084346 .yiv5127084346attach img {border:none;padding-right:5px;}#yiv5127084346 .yiv5127084346attach label {display:block;margin-bottom:5px;}#yiv5127084346 .yiv5127084346attach label a {text-decoration:none;}#yiv5127084346 blockquote {margin:0 0 0 4px;}#yiv5127084346 .yiv5127084346bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5127084346 .yiv5127084346bold a {text-decoration:none;}#yiv5127084346 dd.yiv5127084346last p a {font-family:Verdana;font-weight:700;}#yiv5127084346 dd.yiv5127084346last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5127084346 dd.yiv5127084346last p span.yiv5127084346yshortcuts {margin-right:0;}#yiv5127084346 div.yiv5127084346attach-table div div a {text-decoration:none;}#yiv5127084346 div.yiv5127084346attach-table {width:400px;}#yiv5127084346 div.yiv5127084346file-title a, #yiv5127084346 div.yiv5127084346file-title a:active, #yiv5127084346 div.yiv5127084346file-title a:hover, #yiv5127084346 div.yiv5127084346file-title a:visited {text-decoration:none;}#yiv5127084346 div.yiv5127084346photo-title a, #yiv5127084346 div.yiv5127084346photo-title a:active, #yiv5127084346 div.yiv5127084346photo-title a:hover, #yiv5127084346 div.yiv5127084346photo-title a:visited {text-decoration:none;}#yiv5127084346 div#yiv5127084346ygrp-mlmsg #yiv5127084346ygrp-msg p a span.yiv5127084346yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5127084346 .yiv5127084346green {color:#628c2a;}#yiv5127084346 .yiv5127084346MsoNormal {margin:0 0 0 0;}#yiv5127084346 o {font-size:0;}#yiv5127084346 #yiv5127084346photos div {float:left;width:72px;}#yiv5127084346 #yiv5127084346photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5127084346 #yiv5127084346photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5127084346 #yiv5127084346reco-category {font-size:77%;}#yiv5127084346 #yiv5127084346reco-desc {font-size:77%;}#yiv5127084346 .yiv5127084346replbq {margin:4px;}#yiv5127084346 #yiv5127084346ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5127084346 #yiv5127084346ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5127084346 #yiv5127084346ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5127084346 #yiv5127084346ygrp-mlmsg select, #yiv5127084346 input, #yiv5127084346 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5127084346 #yiv5127084346ygrp-mlmsg pre, #yiv5127084346 code {font:115% monospace;}#yiv5127084346 #yiv5127084346ygrp-mlmsg * {line-height:1.22em;}#yiv5127084346 #yiv5127084346ygrp-mlmsg #yiv5127084346logo {padding-bottom:10px;}#yiv5127084346 #yiv5127084346ygrp-msg p a {font-family:Verdana;}#yiv5127084346 #yiv5127084346ygrp-msg p#yiv5127084346attach-count span {color:#1E66AE;font-weight:700;}#yiv5127084346 #yiv5127084346ygrp-reco #yiv5127084346reco-head {color:#ff7900;font-weight:700;}#yiv5127084346 #yiv5127084346ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5127084346 #yiv5127084346ygrp-sponsor #yiv5127084346ov li a {font-size:130%;text-decoration:none;}#yiv5127084346 #yiv5127084346ygrp-sponsor #yiv5127084346ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5127084346 #yiv5127084346ygrp-sponsor #yiv5127084346ov ul {margin:0;padding:0 0 0 8px;}#yiv5127084346 #yiv5127084346ygrp-text {font-family:Georgia;}#yiv5127084346 #yiv5127084346ygrp-text p {margin:0 0 1em 0;}#yiv5127084346 #yiv5127084346ygrp-text tt {font-size:120%;}#yiv5127084346 #yiv5127084346ygrp-vital ul li:last-child {border-right:none !important;}#yiv5127084346
