Terima kasih atas bantuannya...it's done!Tadi sempat juga mencoba dengan kolom bantu tersendiri untuk Golongan dan Masa KerjaSempat lupa memanfaatkan fungsi RANGE dan NAME RANGE... :) - prodev simple -
Pada Jumat, 9 Desember 2016 8:33, "Eira I Arie cheivory_bri...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Hai Prodev : silakan dicoba langkah berikut (semoga sesuai keinginan) : 1 buatlah name range di sheet database sell A6:A39 (menunjukkan "masa kerja") dengan nama (misalnya) "masakerja". Blok A6:A39 lalu namai di kotak name range kiri atas dengan nama (misalnya) "masa kerja" 2 buatlah name range di sheet database sell B4:R4 (menunjukkan "golongan") dengan nama (misalnya) "golongan". Blok B4:R4 lalu namai di kotak name range kiri atas dengan nama (misalnya) "golongan" 3 masuk di sheet 2 di kolom C (kolom golongan). di sell C5 buatlah data validationnya dengan cara : blok di sell C5:C530 , klik Data -> DaTA vALIDATION -> di tab setting pada kotak allow silakan pilih LIST. -> di kotak source isikan sesuai dengan keinginan dengan cara tekan F3 pada keyboard, silakan pilih yang mana yang mau dijadikan sumber data validation .. Dalam kasus di kolom C ini, maka kita pilih "golongan" -> lalu tekan OKE 4 untuk kolom masa kerja, pada prinsipnya sama dengan proses nomer 3, cuma waktu memilih source datavalidation, maka yang dipilih adalah "masakerja" sekian semoga sesuai dan bermanfaat On Thursday, December 8, 2016 3:01 PM, "Prodev SIMPLE PB prodev_sim...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote: Assalamu'alaikum Wr. Wb. Maaf ikut nimbrung di case ini... :)Mohon petunjuk, bagaimana cara memanfaatkan fitur DATA VALIDATION sehingga pada pemilihan GOL dan MASA KERJA bisa tinggal Klik Pilih (tidak ditulis manual). Terima kasih atas penjelasannya. Wassalam. - prodev simple - Pada Senin, 28 November 2016 8:09, "Cobain Donk cobaindon...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: thanks for your help mrs eira Pada Jumat, 25 November 2016 19:51, "Eira I Arie cheivory_bri...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Hai Cobain Semoga file terlampir sesuai harapan .. eira_arie On Friday, November 25, 2016 8:05 PM, "Cobain Donk cobaindon...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote: Yth. Bapak-Ibu member belajar excel group mohon bantuan solusi untuk masalah kami, sesuai attach email berikut demikian dan terima kasih salam hormat cobain #yiv5052853262 #yiv5052853262 -- #yiv5052853262ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5052853262 #yiv5052853262ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5052853262 #yiv5052853262ygrp-mkp #yiv5052853262hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5052853262 #yiv5052853262ygrp-mkp #yiv5052853262ads {margin-bottom:10px;}#yiv5052853262 #yiv5052853262ygrp-mkp .yiv5052853262ad {padding:0 0;}#yiv5052853262 #yiv5052853262ygrp-mkp .yiv5052853262ad p {margin:0;}#yiv5052853262 #yiv5052853262ygrp-mkp .yiv5052853262ad a {color:#0000ff;text-decoration:none;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ygrp-lc {font-family:Arial;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ygrp-lc #yiv5052853262hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ygrp-lc .yiv5052853262ad {margin-bottom:10px;padding:0 0;}#yiv5052853262 #yiv5052853262actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5052853262 #yiv5052853262activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5052853262 #yiv5052853262activity span {font-weight:700;}#yiv5052853262 #yiv5052853262activity span:first-child {text-transform:uppercase;}#yiv5052853262 #yiv5052853262activity span a {color:#5085b6;text-decoration:none;}#yiv5052853262 #yiv5052853262activity span span {color:#ff7900;}#yiv5052853262 #yiv5052853262activity span .yiv5052853262underline {text-decoration:underline;}#yiv5052853262 .yiv5052853262attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5052853262 .yiv5052853262attach div a {text-decoration:none;}#yiv5052853262 .yiv5052853262attach img {border:none;padding-right:5px;}#yiv5052853262 .yiv5052853262attach label {display:block;margin-bottom:5px;}#yiv5052853262 .yiv5052853262attach label a {text-decoration:none;}#yiv5052853262 blockquote {margin:0 0 0 4px;}#yiv5052853262 .yiv5052853262bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5052853262 .yiv5052853262bold a {text-decoration:none;}#yiv5052853262 dd.yiv5052853262last p a {font-family:Verdana;font-weight:700;}#yiv5052853262 dd.yiv5052853262last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5052853262 dd.yiv5052853262last p span.yiv5052853262yshortcuts {margin-right:0;}#yiv5052853262 div.yiv5052853262attach-table div div a {text-decoration:none;}#yiv5052853262 div.yiv5052853262attach-table {width:400px;}#yiv5052853262 div.yiv5052853262file-title a, #yiv5052853262 div.yiv5052853262file-title a:active, #yiv5052853262 div.yiv5052853262file-title a:hover, #yiv5052853262 div.yiv5052853262file-title a:visited {text-decoration:none;}#yiv5052853262 div.yiv5052853262photo-title a, #yiv5052853262 div.yiv5052853262photo-title a:active, #yiv5052853262 div.yiv5052853262photo-title a:hover, #yiv5052853262 div.yiv5052853262photo-title a:visited {text-decoration:none;}#yiv5052853262 div#yiv5052853262ygrp-mlmsg #yiv5052853262ygrp-msg p a span.yiv5052853262yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5052853262 .yiv5052853262green {color:#628c2a;}#yiv5052853262 .yiv5052853262MsoNormal {margin:0 0 0 0;}#yiv5052853262 o {font-size:0;}#yiv5052853262 #yiv5052853262photos div {float:left;width:72px;}#yiv5052853262 #yiv5052853262photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5052853262 #yiv5052853262photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5052853262 #yiv5052853262reco-category {font-size:77%;}#yiv5052853262 #yiv5052853262reco-desc {font-size:77%;}#yiv5052853262 .yiv5052853262replbq {margin:4px;}#yiv5052853262 #yiv5052853262ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5052853262 #yiv5052853262ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5052853262 #yiv5052853262ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5052853262 #yiv5052853262ygrp-mlmsg select, #yiv5052853262 input, #yiv5052853262 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5052853262 #yiv5052853262ygrp-mlmsg pre, #yiv5052853262 code {font:115% monospace;}#yiv5052853262 #yiv5052853262ygrp-mlmsg * {line-height:1.22em;}#yiv5052853262 #yiv5052853262ygrp-mlmsg #yiv5052853262logo {padding-bottom:10px;}#yiv5052853262 #yiv5052853262ygrp-msg p a {font-family:Verdana;}#yiv5052853262 #yiv5052853262ygrp-msg p#yiv5052853262attach-count span {color:#1E66AE;font-weight:700;}#yiv5052853262 #yiv5052853262ygrp-reco #yiv5052853262reco-head {color:#ff7900;font-weight:700;}#yiv5052853262 #yiv5052853262ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ov li a {font-size:130%;text-decoration:none;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5052853262 #yiv5052853262ygrp-sponsor #yiv5052853262ov ul {margin:0;padding:0 0 0 8px;}#yiv5052853262 #yiv5052853262ygrp-text {font-family:Georgia;}#yiv5052853262 #yiv5052853262ygrp-text p {margin:0 0 1em 0;}#yiv5052853262 #yiv5052853262ygrp-text tt {font-size:120%;}#yiv5052853262 #yiv5052853262ygrp-vital ul li:last-child {border-right:none !important;}#yiv5052853262