Terima kasih Mr. Wid atas pelajarannya ..oiya yaaa maaf jika pemilihan kata
"data validation" tidak sesuai dengan case ..kmrin bingung, saya coba2 konversi
number hasil listbox belum berhasil .sekali lagi terima kasih Mr. Wid
On Tuesday, July 26, 2016 6:51 AM, "widodo budi [email protected]
[belajar-excel]" <[email protected]> wrote:
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
#yiv0462875405 #yiv0462875405 -- #yiv0462875405ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0462875405
#yiv0462875405ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0462875405
#yiv0462875405ygrp-mkp #yiv0462875405hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0462875405 #yiv0462875405ygrp-mkp #yiv0462875405ads
{margin-bottom:10px;}#yiv0462875405 #yiv0462875405ygrp-mkp .yiv0462875405ad
{padding:0 0;}#yiv0462875405 #yiv0462875405ygrp-mkp .yiv0462875405ad p
{margin:0;}#yiv0462875405 #yiv0462875405ygrp-mkp .yiv0462875405ad a
{color:#0000ff;text-decoration:none;}#yiv0462875405 #yiv0462875405ygrp-sponsor
#yiv0462875405ygrp-lc {font-family:Arial;}#yiv0462875405
#yiv0462875405ygrp-sponsor #yiv0462875405ygrp-lc #yiv0462875405hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0462875405
#yiv0462875405ygrp-sponsor #yiv0462875405ygrp-lc .yiv0462875405ad
{margin-bottom:10px;padding:0 0;}#yiv0462875405 #yiv0462875405actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0462875405
#yiv0462875405activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0462875405
#yiv0462875405activity span {font-weight:700;}#yiv0462875405
#yiv0462875405activity span:first-child
{text-transform:uppercase;}#yiv0462875405 #yiv0462875405activity span a
{color:#5085b6;text-decoration:none;}#yiv0462875405 #yiv0462875405activity span
span {color:#ff7900;}#yiv0462875405 #yiv0462875405activity span
.yiv0462875405underline {text-decoration:underline;}#yiv0462875405
.yiv0462875405attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0462875405 .yiv0462875405attach div a
{text-decoration:none;}#yiv0462875405 .yiv0462875405attach img
{border:none;padding-right:5px;}#yiv0462875405 .yiv0462875405attach label
{display:block;margin-bottom:5px;}#yiv0462875405 .yiv0462875405attach label a
{text-decoration:none;}#yiv0462875405 blockquote {margin:0 0 0
4px;}#yiv0462875405 .yiv0462875405bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0462875405
.yiv0462875405bold a {text-decoration:none;}#yiv0462875405 dd.yiv0462875405last
p a {font-family:Verdana;font-weight:700;}#yiv0462875405 dd.yiv0462875405last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0462875405
dd.yiv0462875405last p span.yiv0462875405yshortcuts
{margin-right:0;}#yiv0462875405 div.yiv0462875405attach-table div div a
{text-decoration:none;}#yiv0462875405 div.yiv0462875405attach-table
{width:400px;}#yiv0462875405 div.yiv0462875405file-title a, #yiv0462875405
div.yiv0462875405file-title a:active, #yiv0462875405
div.yiv0462875405file-title a:hover, #yiv0462875405 div.yiv0462875405file-title
a:visited {text-decoration:none;}#yiv0462875405 div.yiv0462875405photo-title a,
#yiv0462875405 div.yiv0462875405photo-title a:active, #yiv0462875405
div.yiv0462875405photo-title a:hover, #yiv0462875405
div.yiv0462875405photo-title a:visited {text-decoration:none;}#yiv0462875405
div#yiv0462875405ygrp-mlmsg #yiv0462875405ygrp-msg p a
span.yiv0462875405yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0462875405
.yiv0462875405green {color:#628c2a;}#yiv0462875405 .yiv0462875405MsoNormal
{margin:0 0 0 0;}#yiv0462875405 o {font-size:0;}#yiv0462875405
#yiv0462875405photos div {float:left;width:72px;}#yiv0462875405
#yiv0462875405photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0462875405
#yiv0462875405photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0462875405
#yiv0462875405reco-category {font-size:77%;}#yiv0462875405
#yiv0462875405reco-desc {font-size:77%;}#yiv0462875405 .yiv0462875405replbq
{margin:4px;}#yiv0462875405 #yiv0462875405ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0462875405 #yiv0462875405ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0462875405
#yiv0462875405ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0462875405
#yiv0462875405ygrp-mlmsg select, #yiv0462875405 input, #yiv0462875405 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0462875405
#yiv0462875405ygrp-mlmsg pre, #yiv0462875405 code {font:115%
monospace;}#yiv0462875405 #yiv0462875405ygrp-mlmsg *
{line-height:1.22em;}#yiv0462875405 #yiv0462875405ygrp-mlmsg #yiv0462875405logo
{padding-bottom:10px;}#yiv0462875405 #yiv0462875405ygrp-msg p a
{font-family:Verdana;}#yiv0462875405 #yiv0462875405ygrp-msg
p#yiv0462875405attach-count span {color:#1E66AE;font-weight:700;}#yiv0462875405
#yiv0462875405ygrp-reco #yiv0462875405reco-head
{color:#ff7900;font-weight:700;}#yiv0462875405 #yiv0462875405ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0462875405 #yiv0462875405ygrp-sponsor
#yiv0462875405ov li a {font-size:130%;text-decoration:none;}#yiv0462875405
#yiv0462875405ygrp-sponsor #yiv0462875405ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0462875405
#yiv0462875405ygrp-sponsor #yiv0462875405ov ul {margin:0;padding:0 0 0
8px;}#yiv0462875405 #yiv0462875405ygrp-text
{font-family:Georgia;}#yiv0462875405 #yiv0462875405ygrp-text p {margin:0 0 1em
0;}#yiv0462875405 #yiv0462875405ygrp-text tt {font-size:120%;}#yiv0462875405
#yiv0462875405ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0462875405
