Dear All,
Terima kasih atas pencerahannya.
Wassalammualaikum Wr.Wb
Edo
On Saturday, December 5, 2015 7:12 PM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Wa'alaikumussalam wr wb
Hai Edo,
Advanced filter bisa digunakan, tetapi proses filternya harus dikolom lain
dalam bentuk tabel kriteria. Advanced filter memiliki opsi copy to another
location.
Cara lainnya adalah dengan Autofilter seperti saran mas Toby. Hasil filter di
blok, lalu CTRL G klilk special pilih Visible cells only dan OK, baru di CTRL C
dan di CTRL V pada cells tujuan.
Kedua cara tersebut bisa diotomasi dengan VBA.
Cara yang rada enakan adalah dengan pivot table (bukan Power Pivot ya). Proses
filter bisa dilakukan di sheet hasil akhir. Malah bisa diletakkan di workbook
lain dengan terkoneksi data melalui fitur Get External Data.
Jika tabel sumber datanya memanfaatkan fitur Excel Table, maka pivot table
bekerja lebih efisien karena area sumber datanya menjadi dinamis mengikuti
fitur Excel Table.
Pivot Table membutuhkan refresh, dan bisa diotomasi dengan VBA jika malas
mengklik refresh all yang ada di ribbon Data. Pada xl2010 ke atas, Excel Pivot
Table diberi fitur untuk menampilkan seluruh nama item, sehingga hasil akhirnya
bisa seperti tabel di sumber data, tetapi telah ter-summary.
Wassalamu'alaikum wr wb
Kid
2015-12-05 17:58 GMT+07:00 [email protected] [belajar-excel]
<[email protected]>:
Assalammualaikum Wr.Wb.
Dear All,
Jika seandainyan kita mempunyai data di kolom A3:B13 dapatkah kita melakukan
advanced filter kemudian hasilnya kita kopi di kolom yang berbeda? sebagai
contoh dari data di A3:B13 akan kita filter dan hasilnya akan kita tempatkan
pada kolom I3 dan K3.
Jika bisa bagaimana cara copy untuk ditaruh di kolom tersebut? dan apakh hal
ini harus menggunakan VBA?
Sebagai contohnya saya sertakan file terlampir
Terima kasih
Wassalammualaikum Wr.Wb.
Edo
#yiv5556597988 #yiv5556597988 -- #yiv5556597988ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5556597988
#yiv5556597988ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5556597988
#yiv5556597988ygrp-mkp #yiv5556597988hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5556597988 #yiv5556597988ygrp-mkp #yiv5556597988ads
{margin-bottom:10px;}#yiv5556597988 #yiv5556597988ygrp-mkp .yiv5556597988ad
{padding:0 0;}#yiv5556597988 #yiv5556597988ygrp-mkp .yiv5556597988ad p
{margin:0;}#yiv5556597988 #yiv5556597988ygrp-mkp .yiv5556597988ad a
{color:#0000ff;text-decoration:none;}#yiv5556597988 #yiv5556597988ygrp-sponsor
#yiv5556597988ygrp-lc {font-family:Arial;}#yiv5556597988
#yiv5556597988ygrp-sponsor #yiv5556597988ygrp-lc #yiv5556597988hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5556597988
#yiv5556597988ygrp-sponsor #yiv5556597988ygrp-lc .yiv5556597988ad
{margin-bottom:10px;padding:0 0;}#yiv5556597988 #yiv5556597988actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5556597988
#yiv5556597988activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5556597988
#yiv5556597988activity span {font-weight:700;}#yiv5556597988
#yiv5556597988activity span:first-child
{text-transform:uppercase;}#yiv5556597988 #yiv5556597988activity span a
{color:#5085b6;text-decoration:none;}#yiv5556597988 #yiv5556597988activity span
span {color:#ff7900;}#yiv5556597988 #yiv5556597988activity span
.yiv5556597988underline {text-decoration:underline;}#yiv5556597988
.yiv5556597988attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5556597988 .yiv5556597988attach div a
{text-decoration:none;}#yiv5556597988 .yiv5556597988attach img
{border:none;padding-right:5px;}#yiv5556597988 .yiv5556597988attach label
{display:block;margin-bottom:5px;}#yiv5556597988 .yiv5556597988attach label a
{text-decoration:none;}#yiv5556597988 blockquote {margin:0 0 0
4px;}#yiv5556597988 .yiv5556597988bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5556597988
.yiv5556597988bold a {text-decoration:none;}#yiv5556597988 dd.yiv5556597988last
p a {font-family:Verdana;font-weight:700;}#yiv5556597988 dd.yiv5556597988last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5556597988
dd.yiv5556597988last p span.yiv5556597988yshortcuts
{margin-right:0;}#yiv5556597988 div.yiv5556597988attach-table div div a
{text-decoration:none;}#yiv5556597988 div.yiv5556597988attach-table
{width:400px;}#yiv5556597988 div.yiv5556597988file-title a, #yiv5556597988
div.yiv5556597988file-title a:active, #yiv5556597988
div.yiv5556597988file-title a:hover, #yiv5556597988 div.yiv5556597988file-title
a:visited {text-decoration:none;}#yiv5556597988 div.yiv5556597988photo-title a,
#yiv5556597988 div.yiv5556597988photo-title a:active, #yiv5556597988
div.yiv5556597988photo-title a:hover, #yiv5556597988
div.yiv5556597988photo-title a:visited {text-decoration:none;}#yiv5556597988
div#yiv5556597988ygrp-mlmsg #yiv5556597988ygrp-msg p a
span.yiv5556597988yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5556597988
.yiv5556597988green {color:#628c2a;}#yiv5556597988 .yiv5556597988MsoNormal
{margin:0 0 0 0;}#yiv5556597988 o {font-size:0;}#yiv5556597988
#yiv5556597988photos div {float:left;width:72px;}#yiv5556597988
#yiv5556597988photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5556597988
#yiv5556597988photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5556597988
#yiv5556597988reco-category {font-size:77%;}#yiv5556597988
#yiv5556597988reco-desc {font-size:77%;}#yiv5556597988 .yiv5556597988replbq
{margin:4px;}#yiv5556597988 #yiv5556597988ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5556597988 #yiv5556597988ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5556597988
#yiv5556597988ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5556597988
#yiv5556597988ygrp-mlmsg select, #yiv5556597988 input, #yiv5556597988 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5556597988
#yiv5556597988ygrp-mlmsg pre, #yiv5556597988 code {font:115%
monospace;}#yiv5556597988 #yiv5556597988ygrp-mlmsg *
{line-height:1.22em;}#yiv5556597988 #yiv5556597988ygrp-mlmsg #yiv5556597988logo
{padding-bottom:10px;}#yiv5556597988 #yiv5556597988ygrp-msg p a
{font-family:Verdana;}#yiv5556597988 #yiv5556597988ygrp-msg
p#yiv5556597988attach-count span {color:#1E66AE;font-weight:700;}#yiv5556597988
#yiv5556597988ygrp-reco #yiv5556597988reco-head
{color:#ff7900;font-weight:700;}#yiv5556597988 #yiv5556597988ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5556597988 #yiv5556597988ygrp-sponsor
#yiv5556597988ov li a {font-size:130%;text-decoration:none;}#yiv5556597988
#yiv5556597988ygrp-sponsor #yiv5556597988ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5556597988
#yiv5556597988ygrp-sponsor #yiv5556597988ov ul {margin:0;padding:0 0 0
8px;}#yiv5556597988 #yiv5556597988ygrp-text
{font-family:Georgia;}#yiv5556597988 #yiv5556597988ygrp-text p {margin:0 0 1em
0;}#yiv5556597988 #yiv5556597988ygrp-text tt {font-size:120%;}#yiv5556597988
#yiv5556597988ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5556597988
