Re: ]] XL-mania [[ Input satu data muncul 4 data sekaligus

 

Dear,
Coba gunakan VBA berikut:


Sub Macro1()

KataKunci = Range("F5")
   
    Range("B4:C200").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=1, Criteria1:=KataKunci
    Range("C4:C200").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Range("H4").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Selection.AutoFilter
    Range("F5").Select
    Range("H4") = "Coba Formula"
   
   
End Sub

Rgrds,
Wahyuddin K.

Dwi Prasetyo <prasetyo.dwi57@yahoo.co.id> Sent by: XL-mania@yahoogroups.com 02/23/2010 09:39 PM Please respond to XL-mania

To:        XL-mania@yahoogroups.com         cc:                 Subject:        ]] XL-mania [[ Input satu data muncul 4 data sekaligus

 

Teman temaan Milis minta tolong dong bantuannya gw kesulitan nih mau manggil data > 1 sekaligus aku dah cobain tapi gak juga bisa....klo bisa pakai yang sederhana aja, soalnya gw sambil belajar juga....

 
Aku ucapin Makasih buat Mas  Arif Budiman, Mba Siti Vi dan Mas Dwi Julianto dan tentunya semua teman tema milis yang udah bantu gw selesein masalah sebelumnya dan membuat gw terus semangat mengikuti forum xl mania ..untuk belajar mendalami excel..
Salam
 
 
 
Dwi P
 
file terlampir
 
 

---

Lebih aman saat online.
Upgrade ke Internet Explorer 8 baru dan lebih cepat yang dioptimalkan untuk Yahoo! agar Anda merasa lebih aman. Gratis. Dapatkan IE8 di sini!

=========================================================================== This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. The Trakindo Group of Companies do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by the Tiara Marga Trakindo Group of Companies and this email is not an offer, solicitation, recommendation or agreement of any kind. ===========================================================================

__._,_.___

Reply to sender | Reply to group

Messages in this topic (2)

Recent Activity:

• New Members 97

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| huaaaa... momods sakit... *sob*                                   | 
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___