Wa'alaikumussalam warahmatullah, Mas Ari,Saya sebenernya masih bingung perihal penggunaan bahasa 'data validation', tetapi semoga lampirannya sesuai dengan harapan. Konsep yang saya terapkan dalam pengolahan data di excel, meminjam istilah permainan sepak bola, manfaatkan lebar lapangan!!, nah, kalau di excel, jangan ragu untuk memanfaatkan banyaknya sel sebagai dummy cells. Yang terpenting dalam meng-konversi nilai output dari form (list box, dropdown list, scroll, dll) adalah membiasakan untuk merujuk ke nomor unik data dari database atau tabel referensinya, nah dari nomor unik bisa digunakan untuk mencari data-data lain yang diperlukan, gunakan formula yang kamu kuasai, bisa menggunakan Vlookup, atau index match, atau offset, atau formula lainnya. Selamat berkreasi dengan excel. Wassalamu'alaikum. Wid0812 1988 6207
On Monday, July 25, 2016 7:44 PM, Eira I Arie <[email protected]>
wrote:
Assalaamu'alaikum Wr Wb
Mr. Wid, stlh lihat workbook nya, saya lagi coba2 nih data validation (pake
listbox) untuk case kerjaan saya ,hmmmmm tapi masih bingung pas saat nge link
datavalidation pake listbox , gimana yaa cara menghubungkannya ?
terima kasih
wassalaamu'alaikum wr wb
ari
On Sunday, July 24, 2016 4:46 PM, "widodo budi [email protected]
[belajar-excel]" <[email protected]> wrote:
Assalamu'alaikum warahmatullah,
Sahabat excel,Terlampir contoh aplikasi excel tanpa makro, reminder perjanjian
kerjasama yang memuat database (data dinamis) di salah satu sheet, dan
interface reminder di sheet yang lain.Menggunakan conditional formatting,
fungsi IF, dll.
Semoga menjadi inspirasi bagi sahabat excel yang ingin memaksimalkan fungsi
excelnya.Wassalamu'alaikum warahmatullah.
Wid0812 1988 6207
Excel so powerful, only one software for everything we need #yiv9641837165 --
#yiv9641837165ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv9641837165 #yiv9641837165ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv9641837165 #yiv9641837165ygrp-mkp #yiv9641837165hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9641837165 #yiv9641837165ygrp-mkp #yiv9641837165ads
{margin-bottom:10px;}#yiv9641837165 #yiv9641837165ygrp-mkp .yiv9641837165ad
{padding:0 0;}#yiv9641837165 #yiv9641837165ygrp-mkp .yiv9641837165ad p
{margin:0;}#yiv9641837165 #yiv9641837165ygrp-mkp .yiv9641837165ad a
{color:#0000ff;text-decoration:none;}#yiv9641837165 #yiv9641837165ygrp-sponsor
#yiv9641837165ygrp-lc {font-family:Arial;}#yiv9641837165
#yiv9641837165ygrp-sponsor #yiv9641837165ygrp-lc #yiv9641837165hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9641837165
#yiv9641837165ygrp-sponsor #yiv9641837165ygrp-lc .yiv9641837165ad
{margin-bottom:10px;padding:0 0;}#yiv9641837165 #yiv9641837165actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9641837165
#yiv9641837165activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9641837165
#yiv9641837165activity span {font-weight:700;}#yiv9641837165
#yiv9641837165activity span:first-child
{text-transform:uppercase;}#yiv9641837165 #yiv9641837165activity span a
{color:#5085b6;text-decoration:none;}#yiv9641837165 #yiv9641837165activity span
span {color:#ff7900;}#yiv9641837165 #yiv9641837165activity span
.yiv9641837165underline {text-decoration:underline;}#yiv9641837165
.yiv9641837165attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9641837165 .yiv9641837165attach div a
{text-decoration:none;}#yiv9641837165 .yiv9641837165attach img
{border:none;padding-right:5px;}#yiv9641837165 .yiv9641837165attach label
{display:block;margin-bottom:5px;}#yiv9641837165 .yiv9641837165attach label a
{text-decoration:none;}#yiv9641837165 blockquote {margin:0 0 0
4px;}#yiv9641837165 .yiv9641837165bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9641837165
.yiv9641837165bold a {text-decoration:none;}#yiv9641837165 dd.yiv9641837165last
p a {font-family:Verdana;font-weight:700;}#yiv9641837165 dd.yiv9641837165last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9641837165
dd.yiv9641837165last p span.yiv9641837165yshortcuts
{margin-right:0;}#yiv9641837165 div.yiv9641837165attach-table div div a
{text-decoration:none;}#yiv9641837165 div.yiv9641837165attach-table
{width:400px;}#yiv9641837165 div.yiv9641837165file-title a, #yiv9641837165
div.yiv9641837165file-title a:active, #yiv9641837165
div.yiv9641837165file-title a:hover, #yiv9641837165 div.yiv9641837165file-title
a:visited {text-decoration:none;}#yiv9641837165 div.yiv9641837165photo-title a,
#yiv9641837165 div.yiv9641837165photo-title a:active, #yiv9641837165
div.yiv9641837165photo-title a:hover, #yiv9641837165
div.yiv9641837165photo-title a:visited {text-decoration:none;}#yiv9641837165
div#yiv9641837165ygrp-mlmsg #yiv9641837165ygrp-msg p a
span.yiv9641837165yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9641837165
.yiv9641837165green {color:#628c2a;}#yiv9641837165 .yiv9641837165MsoNormal
{margin:0 0 0 0;}#yiv9641837165 o {font-size:0;}#yiv9641837165
#yiv9641837165photos div {float:left;width:72px;}#yiv9641837165
#yiv9641837165photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9641837165
#yiv9641837165photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9641837165
#yiv9641837165reco-category {font-size:77%;}#yiv9641837165
#yiv9641837165reco-desc {font-size:77%;}#yiv9641837165 .yiv9641837165replbq
{margin:4px;}#yiv9641837165 #yiv9641837165ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9641837165 #yiv9641837165ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9641837165
#yiv9641837165ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9641837165
#yiv9641837165ygrp-mlmsg select, #yiv9641837165 input, #yiv9641837165 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9641837165
#yiv9641837165ygrp-mlmsg pre, #yiv9641837165 code {font:115%
monospace;}#yiv9641837165 #yiv9641837165ygrp-mlmsg *
{line-height:1.22em;}#yiv9641837165 #yiv9641837165ygrp-mlmsg #yiv9641837165logo
{padding-bottom:10px;}#yiv9641837165 #yiv9641837165ygrp-msg p a
{font-family:Verdana;}#yiv9641837165 #yiv9641837165ygrp-msg
p#yiv9641837165attach-count span {color:#1E66AE;font-weight:700;}#yiv9641837165
#yiv9641837165ygrp-reco #yiv9641837165reco-head
{color:#ff7900;font-weight:700;}#yiv9641837165 #yiv9641837165ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9641837165 #yiv9641837165ygrp-sponsor
#yiv9641837165ov li a {font-size:130%;text-decoration:none;}#yiv9641837165
#yiv9641837165ygrp-sponsor #yiv9641837165ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9641837165
#yiv9641837165ygrp-sponsor #yiv9641837165ov ul {margin:0;padding:0 0 0
8px;}#yiv9641837165 #yiv9641837165ygrp-text
{font-family:Georgia;}#yiv9641837165 #yiv9641837165ygrp-text p {margin:0 0 1em
0;}#yiv9641837165 #yiv9641837165ygrp-text tt {font-size:120%;}#yiv9641837165
#yiv9641837165ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9641837165
Merger DB- Copy - Edit by Wid.xlsx
Description: MS-Excel 2007 spreadsheet
