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.
#yiv5466199004 #yiv5466199004 -- #yiv5466199004ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5466199004
#yiv5466199004ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5466199004
#yiv5466199004ygrp-mkp #yiv5466199004hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5466199004 #yiv5466199004ygrp-mkp #yiv5466199004ads
{margin-bottom:10px;}#yiv5466199004 #yiv5466199004ygrp-mkp .yiv5466199004ad
{padding:0 0;}#yiv5466199004 #yiv5466199004ygrp-mkp .yiv5466199004ad p
{margin:0;}#yiv5466199004 #yiv5466199004ygrp-mkp .yiv5466199004ad a
{color:#0000ff;text-decoration:none;}#yiv5466199004 #yiv5466199004ygrp-sponsor
#yiv5466199004ygrp-lc {font-family:Arial;}#yiv5466199004
#yiv5466199004ygrp-sponsor #yiv5466199004ygrp-lc #yiv5466199004hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5466199004
#yiv5466199004ygrp-sponsor #yiv5466199004ygrp-lc .yiv5466199004ad
{margin-bottom:10px;padding:0 0;}#yiv5466199004 #yiv5466199004actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5466199004
#yiv5466199004activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5466199004
#yiv5466199004activity span {font-weight:700;}#yiv5466199004
#yiv5466199004activity span:first-child
{text-transform:uppercase;}#yiv5466199004 #yiv5466199004activity span a
{color:#5085b6;text-decoration:none;}#yiv5466199004 #yiv5466199004activity span
span {color:#ff7900;}#yiv5466199004 #yiv5466199004activity span
.yiv5466199004underline {text-decoration:underline;}#yiv5466199004
.yiv5466199004attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5466199004 .yiv5466199004attach div a
{text-decoration:none;}#yiv5466199004 .yiv5466199004attach img
{border:none;padding-right:5px;}#yiv5466199004 .yiv5466199004attach label
{display:block;margin-bottom:5px;}#yiv5466199004 .yiv5466199004attach label a
{text-decoration:none;}#yiv5466199004 blockquote {margin:0 0 0
4px;}#yiv5466199004 .yiv5466199004bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5466199004
.yiv5466199004bold a {text-decoration:none;}#yiv5466199004 dd.yiv5466199004last
p a {font-family:Verdana;font-weight:700;}#yiv5466199004 dd.yiv5466199004last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5466199004
dd.yiv5466199004last p span.yiv5466199004yshortcuts
{margin-right:0;}#yiv5466199004 div.yiv5466199004attach-table div div a
{text-decoration:none;}#yiv5466199004 div.yiv5466199004attach-table
{width:400px;}#yiv5466199004 div.yiv5466199004file-title a, #yiv5466199004
div.yiv5466199004file-title a:active, #yiv5466199004
div.yiv5466199004file-title a:hover, #yiv5466199004 div.yiv5466199004file-title
a:visited {text-decoration:none;}#yiv5466199004 div.yiv5466199004photo-title a,
#yiv5466199004 div.yiv5466199004photo-title a:active, #yiv5466199004
div.yiv5466199004photo-title a:hover, #yiv5466199004
div.yiv5466199004photo-title a:visited {text-decoration:none;}#yiv5466199004
div#yiv5466199004ygrp-mlmsg #yiv5466199004ygrp-msg p a
span.yiv5466199004yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5466199004
.yiv5466199004green {color:#628c2a;}#yiv5466199004 .yiv5466199004MsoNormal
{margin:0 0 0 0;}#yiv5466199004 o {font-size:0;}#yiv5466199004
#yiv5466199004photos div {float:left;width:72px;}#yiv5466199004
#yiv5466199004photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5466199004
#yiv5466199004photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5466199004
#yiv5466199004reco-category {font-size:77%;}#yiv5466199004
#yiv5466199004reco-desc {font-size:77%;}#yiv5466199004 .yiv5466199004replbq
{margin:4px;}#yiv5466199004 #yiv5466199004ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5466199004 #yiv5466199004ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5466199004
#yiv5466199004ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5466199004
#yiv5466199004ygrp-mlmsg select, #yiv5466199004 input, #yiv5466199004 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5466199004
#yiv5466199004ygrp-mlmsg pre, #yiv5466199004 code {font:115%
monospace;}#yiv5466199004 #yiv5466199004ygrp-mlmsg *
{line-height:1.22em;}#yiv5466199004 #yiv5466199004ygrp-mlmsg #yiv5466199004logo
{padding-bottom:10px;}#yiv5466199004 #yiv5466199004ygrp-msg p a
{font-family:Verdana;}#yiv5466199004 #yiv5466199004ygrp-msg
p#yiv5466199004attach-count span {color:#1E66AE;font-weight:700;}#yiv5466199004
#yiv5466199004ygrp-reco #yiv5466199004reco-head
{color:#ff7900;font-weight:700;}#yiv5466199004 #yiv5466199004ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5466199004 #yiv5466199004ygrp-sponsor
#yiv5466199004ov li a {font-size:130%;text-decoration:none;}#yiv5466199004
#yiv5466199004ygrp-sponsor #yiv5466199004ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5466199004
#yiv5466199004ygrp-sponsor #yiv5466199004ov ul {margin:0;padding:0 0 0
8px;}#yiv5466199004 #yiv5466199004ygrp-text
{font-family:Georgia;}#yiv5466199004 #yiv5466199004ygrp-text p {margin:0 0 1em
0;}#yiv5466199004 #yiv5466199004ygrp-text tt {font-size:120%;}#yiv5466199004
#yiv5466199004ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5466199004
