Hai Fathir,Coba juga pake macro ini yang memanfaatkan Worksheet Event
(Worksheet_BeforeDoubleClick).Jangan lupa aktifkan macronya.Nama lampiran
filenya HK_Cari Saldo.xlsm
Salam,HK
----- Forwarded Message -----
From: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
To: BeExcel <[email protected]>
Sent: Thursday, 27 November 2014, 8:27
Subject: Re: [belajar-excel] cari data sama [1 Attachment]
Wa'alaikumussalam wr wbHai Fathir, File terlampir memanfaatkan fitur Excel Table agar rujukan formula bisa dinamis diatur oleh si Excel alias tidak perlu capek-capek mengubah rujukan formula ketika datanya bertambah. Conditional formatting digunakan untuk memberi tanda. Conditional formatting bisa dibuat melalui : ribbon Home -> group Styles -> Conditional Formatting -> New Rule Wassalamu'alaikum wr wb Kid. 2014-11-27 3:56 GMT+11:00 fathir ali [email protected] [belajar-excel] <[email protected]>: assalamualaikum wrb dear master excel mohon pencerahannnya sy ada data tagihan dan data yg sudah di bayar yg jumlahnya ribuan . sy kesulitan untuk mencocokan data yg sudah di bayarkan di data tagihan selama ini sy menggunakan control find adakah cara yg lebih cepat selain itu menggigat datanya ribuan. berikut file dummy sy lampirkan atas bantuannya sy ucapkan terima kasih #yiv7919157115 #yiv7919157115 -- #yiv7919157115ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7919157115 #yiv7919157115ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7919157115 #yiv7919157115ygrp-mkp #yiv7919157115hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7919157115 #yiv7919157115ygrp-mkp #yiv7919157115ads {margin-bottom:10px;}#yiv7919157115 #yiv7919157115ygrp-mkp .yiv7919157115ad {padding:0 0;}#yiv7919157115 #yiv7919157115ygrp-mkp .yiv7919157115ad p {margin:0;}#yiv7919157115 #yiv7919157115ygrp-mkp .yiv7919157115ad a {color:#0000ff;text-decoration:none;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ygrp-lc {font-family:Arial;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ygrp-lc #yiv7919157115hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ygrp-lc .yiv7919157115ad {margin-bottom:10px;padding:0 0;}#yiv7919157115 #yiv7919157115actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7919157115 #yiv7919157115activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7919157115 #yiv7919157115activity span {font-weight:700;}#yiv7919157115 #yiv7919157115activity span:first-child {text-transform:uppercase;}#yiv7919157115 #yiv7919157115activity span a {color:#5085b6;text-decoration:none;}#yiv7919157115 #yiv7919157115activity span span {color:#ff7900;}#yiv7919157115 #yiv7919157115activity span .yiv7919157115underline {text-decoration:underline;}#yiv7919157115 .yiv7919157115attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7919157115 .yiv7919157115attach div a {text-decoration:none;}#yiv7919157115 .yiv7919157115attach img {border:none;padding-right:5px;}#yiv7919157115 .yiv7919157115attach label {display:block;margin-bottom:5px;}#yiv7919157115 .yiv7919157115attach label a {text-decoration:none;}#yiv7919157115 blockquote {margin:0 0 0 4px;}#yiv7919157115 .yiv7919157115bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7919157115 .yiv7919157115bold a {text-decoration:none;}#yiv7919157115 dd.yiv7919157115last p a {font-family:Verdana;font-weight:700;}#yiv7919157115 dd.yiv7919157115last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7919157115 dd.yiv7919157115last p span.yiv7919157115yshortcuts {margin-right:0;}#yiv7919157115 div.yiv7919157115attach-table div div a {text-decoration:none;}#yiv7919157115 div.yiv7919157115attach-table {width:400px;}#yiv7919157115 div.yiv7919157115file-title a, #yiv7919157115 div.yiv7919157115file-title a:active, #yiv7919157115 div.yiv7919157115file-title a:hover, #yiv7919157115 div.yiv7919157115file-title a:visited {text-decoration:none;}#yiv7919157115 div.yiv7919157115photo-title a, #yiv7919157115 div.yiv7919157115photo-title a:active, #yiv7919157115 div.yiv7919157115photo-title a:hover, #yiv7919157115 div.yiv7919157115photo-title a:visited {text-decoration:none;}#yiv7919157115 div#yiv7919157115ygrp-mlmsg #yiv7919157115ygrp-msg p a span.yiv7919157115yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7919157115 .yiv7919157115green {color:#628c2a;}#yiv7919157115 .yiv7919157115MsoNormal {margin:0 0 0 0;}#yiv7919157115 o {font-size:0;}#yiv7919157115 #yiv7919157115photos div {float:left;width:72px;}#yiv7919157115 #yiv7919157115photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7919157115 #yiv7919157115photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7919157115 #yiv7919157115reco-category {font-size:77%;}#yiv7919157115 #yiv7919157115reco-desc {font-size:77%;}#yiv7919157115 .yiv7919157115replbq {margin:4px;}#yiv7919157115 #yiv7919157115ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7919157115 #yiv7919157115ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7919157115 #yiv7919157115ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7919157115 #yiv7919157115ygrp-mlmsg select, #yiv7919157115 input, #yiv7919157115 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7919157115 #yiv7919157115ygrp-mlmsg pre, #yiv7919157115 code {font:115% monospace;}#yiv7919157115 #yiv7919157115ygrp-mlmsg * {line-height:1.22em;}#yiv7919157115 #yiv7919157115ygrp-mlmsg #yiv7919157115logo {padding-bottom:10px;}#yiv7919157115 #yiv7919157115ygrp-msg p a {font-family:Verdana;}#yiv7919157115 #yiv7919157115ygrp-msg p#yiv7919157115attach-count span {color:#1E66AE;font-weight:700;}#yiv7919157115 #yiv7919157115ygrp-reco #yiv7919157115reco-head {color:#ff7900;font-weight:700;}#yiv7919157115 #yiv7919157115ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ov li a {font-size:130%;text-decoration:none;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7919157115 #yiv7919157115ygrp-sponsor #yiv7919157115ov ul {margin:0;padding:0 0 0 8px;}#yiv7919157115 #yiv7919157115ygrp-text {font-family:Georgia;}#yiv7919157115 #yiv7919157115ygrp-text p {margin:0 0 1em 0;}#yiv7919157115 #yiv7919157115ygrp-text tt {font-size:120%;}#yiv7919157115 #yiv7919157115ygrp-vital ul li:last-child {border-right:none !important;}#yiv7919157115
re-CONTOH.xlsx
Description: MS-Excel 2007 spreadsheet
HK_Cari Saldo.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
