Hai Josh,Untuk filter di posisi yang sama, coba rekam macro dengan gunakan menu
Data Filter sesuai Kriteria yang diinginkan (krteria 1 dan ke 2)Untuk Filter di
tempat lain, gunakan menu Data Advance Filter (Ada 2 kolom kriteria dan 2 baris
kriteria).
Salam,HK
From: "Josh Pieter [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Monday, 1 August 2016, 23:28
Subject: [belajar-excel] VBA Find atau Lookup Multiple Criteria [1 Attachment]
Yth. Para Suhu
Berikut terlampir aplikasi pelunasan piutang yaitu dengan 1 No Faktur Penjualan
tetapi bisa didalamnya beberapa Pelanggan,
nah gimana ya suhu, supaya dengan memilih no Faktur tertentumemasukkan berapa
yang dibayar dan klik dan Hasilnya Bayar nya bisamasuk ke No Nota dan atas nama
pelanggan tertentu?lebih tepatnya klo di Formula nih pake yang namanya lookup
beberapa kriteria atau index matchNah yang aku inginkan sebenarnya dgn VBA
Macro nya.
Berikut lampirannya untuk lebih jelasnya,
yaitu dengan memilih list no faktur piutang yang dibayar, dan atas pelanggan
mana,
ketikkan jumlah bayar pada text box dan klik bayar.
Terima kasih ya Para Suhu atas bantuaannya.
salam
Josh
#yiv9504712036 #yiv9504712036 -- #yiv9504712036ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9504712036
#yiv9504712036ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9504712036
#yiv9504712036ygrp-mkp #yiv9504712036hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9504712036 #yiv9504712036ygrp-mkp #yiv9504712036ads
{margin-bottom:10px;}#yiv9504712036 #yiv9504712036ygrp-mkp .yiv9504712036ad
{padding:0 0;}#yiv9504712036 #yiv9504712036ygrp-mkp .yiv9504712036ad p
{margin:0;}#yiv9504712036 #yiv9504712036ygrp-mkp .yiv9504712036ad a
{color:#0000ff;text-decoration:none;}#yiv9504712036 #yiv9504712036ygrp-sponsor
#yiv9504712036ygrp-lc {font-family:Arial;}#yiv9504712036
#yiv9504712036ygrp-sponsor #yiv9504712036ygrp-lc #yiv9504712036hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9504712036
#yiv9504712036ygrp-sponsor #yiv9504712036ygrp-lc .yiv9504712036ad
{margin-bottom:10px;padding:0 0;}#yiv9504712036 #yiv9504712036actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9504712036
#yiv9504712036activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9504712036
#yiv9504712036activity span {font-weight:700;}#yiv9504712036
#yiv9504712036activity span:first-child
{text-transform:uppercase;}#yiv9504712036 #yiv9504712036activity span a
{color:#5085b6;text-decoration:none;}#yiv9504712036 #yiv9504712036activity span
span {color:#ff7900;}#yiv9504712036 #yiv9504712036activity span
.yiv9504712036underline {text-decoration:underline;}#yiv9504712036
.yiv9504712036attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9504712036 .yiv9504712036attach div a
{text-decoration:none;}#yiv9504712036 .yiv9504712036attach img
{border:none;padding-right:5px;}#yiv9504712036 .yiv9504712036attach label
{display:block;margin-bottom:5px;}#yiv9504712036 .yiv9504712036attach label a
{text-decoration:none;}#yiv9504712036 blockquote {margin:0 0 0
4px;}#yiv9504712036 .yiv9504712036bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9504712036
.yiv9504712036bold a {text-decoration:none;}#yiv9504712036 dd.yiv9504712036last
p a {font-family:Verdana;font-weight:700;}#yiv9504712036 dd.yiv9504712036last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9504712036
dd.yiv9504712036last p span.yiv9504712036yshortcuts
{margin-right:0;}#yiv9504712036 div.yiv9504712036attach-table div div a
{text-decoration:none;}#yiv9504712036 div.yiv9504712036attach-table
{width:400px;}#yiv9504712036 div.yiv9504712036file-title a, #yiv9504712036
div.yiv9504712036file-title a:active, #yiv9504712036
div.yiv9504712036file-title a:hover, #yiv9504712036 div.yiv9504712036file-title
a:visited {text-decoration:none;}#yiv9504712036 div.yiv9504712036photo-title a,
#yiv9504712036 div.yiv9504712036photo-title a:active, #yiv9504712036
div.yiv9504712036photo-title a:hover, #yiv9504712036
div.yiv9504712036photo-title a:visited {text-decoration:none;}#yiv9504712036
div#yiv9504712036ygrp-mlmsg #yiv9504712036ygrp-msg p a
span.yiv9504712036yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9504712036
.yiv9504712036green {color:#628c2a;}#yiv9504712036 .yiv9504712036MsoNormal
{margin:0 0 0 0;}#yiv9504712036 o {font-size:0;}#yiv9504712036
#yiv9504712036photos div {float:left;width:72px;}#yiv9504712036
#yiv9504712036photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9504712036
#yiv9504712036photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9504712036
#yiv9504712036reco-category {font-size:77%;}#yiv9504712036
#yiv9504712036reco-desc {font-size:77%;}#yiv9504712036 .yiv9504712036replbq
{margin:4px;}#yiv9504712036 #yiv9504712036ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9504712036 #yiv9504712036ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9504712036
#yiv9504712036ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9504712036
#yiv9504712036ygrp-mlmsg select, #yiv9504712036 input, #yiv9504712036 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9504712036
#yiv9504712036ygrp-mlmsg pre, #yiv9504712036 code {font:115%
monospace;}#yiv9504712036 #yiv9504712036ygrp-mlmsg *
{line-height:1.22em;}#yiv9504712036 #yiv9504712036ygrp-mlmsg #yiv9504712036logo
{padding-bottom:10px;}#yiv9504712036 #yiv9504712036ygrp-msg p a
{font-family:Verdana;}#yiv9504712036 #yiv9504712036ygrp-msg
p#yiv9504712036attach-count span {color:#1E66AE;font-weight:700;}#yiv9504712036
#yiv9504712036ygrp-reco #yiv9504712036reco-head
{color:#ff7900;font-weight:700;}#yiv9504712036 #yiv9504712036ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9504712036 #yiv9504712036ygrp-sponsor
#yiv9504712036ov li a {font-size:130%;text-decoration:none;}#yiv9504712036
#yiv9504712036ygrp-sponsor #yiv9504712036ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9504712036
#yiv9504712036ygrp-sponsor #yiv9504712036ov ul {margin:0;padding:0 0 0
8px;}#yiv9504712036 #yiv9504712036ygrp-text
{font-family:Georgia;}#yiv9504712036 #yiv9504712036ygrp-text p {margin:0 0 1em
0;}#yiv9504712036 #yiv9504712036ygrp-text tt {font-size:120%;}#yiv9504712036
#yiv9504712036ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9504712036
