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
[email protected] [belajar-excel]" <[email protected]> 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 [email protected]
[belajar-excel]" <[email protected]> menulis:
thanks for your help mrs eira
Pada Jumat, 25 November 2016 19:51, "Eira I Arie [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Cobain
Semoga file terlampir sesuai harapan ..
eira_arie
On Friday, November 25, 2016 8:05 PM, "Cobain Donk [email protected]
[belajar-excel]" <[email protected]> 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
#yiv0331084944 #yiv0331084944 -- #yiv0331084944ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0331084944
#yiv0331084944ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0331084944
#yiv0331084944ygrp-mkp #yiv0331084944hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0331084944 #yiv0331084944ygrp-mkp #yiv0331084944ads
{margin-bottom:10px;}#yiv0331084944 #yiv0331084944ygrp-mkp .yiv0331084944ad
{padding:0 0;}#yiv0331084944 #yiv0331084944ygrp-mkp .yiv0331084944ad p
{margin:0;}#yiv0331084944 #yiv0331084944ygrp-mkp .yiv0331084944ad a
{color:#0000ff;text-decoration:none;}#yiv0331084944 #yiv0331084944ygrp-sponsor
#yiv0331084944ygrp-lc {font-family:Arial;}#yiv0331084944
#yiv0331084944ygrp-sponsor #yiv0331084944ygrp-lc #yiv0331084944hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0331084944
#yiv0331084944ygrp-sponsor #yiv0331084944ygrp-lc .yiv0331084944ad
{margin-bottom:10px;padding:0 0;}#yiv0331084944 #yiv0331084944actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0331084944
#yiv0331084944activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0331084944
#yiv0331084944activity span {font-weight:700;}#yiv0331084944
#yiv0331084944activity span:first-child
{text-transform:uppercase;}#yiv0331084944 #yiv0331084944activity span a
{color:#5085b6;text-decoration:none;}#yiv0331084944 #yiv0331084944activity span
span {color:#ff7900;}#yiv0331084944 #yiv0331084944activity span
.yiv0331084944underline {text-decoration:underline;}#yiv0331084944
.yiv0331084944attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0331084944 .yiv0331084944attach div a
{text-decoration:none;}#yiv0331084944 .yiv0331084944attach img
{border:none;padding-right:5px;}#yiv0331084944 .yiv0331084944attach label
{display:block;margin-bottom:5px;}#yiv0331084944 .yiv0331084944attach label a
{text-decoration:none;}#yiv0331084944 blockquote {margin:0 0 0
4px;}#yiv0331084944 .yiv0331084944bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0331084944
.yiv0331084944bold a {text-decoration:none;}#yiv0331084944 dd.yiv0331084944last
p a {font-family:Verdana;font-weight:700;}#yiv0331084944 dd.yiv0331084944last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0331084944
dd.yiv0331084944last p span.yiv0331084944yshortcuts
{margin-right:0;}#yiv0331084944 div.yiv0331084944attach-table div div a
{text-decoration:none;}#yiv0331084944 div.yiv0331084944attach-table
{width:400px;}#yiv0331084944 div.yiv0331084944file-title a, #yiv0331084944
div.yiv0331084944file-title a:active, #yiv0331084944
div.yiv0331084944file-title a:hover, #yiv0331084944 div.yiv0331084944file-title
a:visited {text-decoration:none;}#yiv0331084944 div.yiv0331084944photo-title a,
#yiv0331084944 div.yiv0331084944photo-title a:active, #yiv0331084944
div.yiv0331084944photo-title a:hover, #yiv0331084944
div.yiv0331084944photo-title a:visited {text-decoration:none;}#yiv0331084944
div#yiv0331084944ygrp-mlmsg #yiv0331084944ygrp-msg p a
span.yiv0331084944yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0331084944
.yiv0331084944green {color:#628c2a;}#yiv0331084944 .yiv0331084944MsoNormal
{margin:0 0 0 0;}#yiv0331084944 o {font-size:0;}#yiv0331084944
#yiv0331084944photos div {float:left;width:72px;}#yiv0331084944
#yiv0331084944photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0331084944
#yiv0331084944photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0331084944
#yiv0331084944reco-category {font-size:77%;}#yiv0331084944
#yiv0331084944reco-desc {font-size:77%;}#yiv0331084944 .yiv0331084944replbq
{margin:4px;}#yiv0331084944 #yiv0331084944ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0331084944 #yiv0331084944ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0331084944
#yiv0331084944ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0331084944
#yiv0331084944ygrp-mlmsg select, #yiv0331084944 input, #yiv0331084944 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0331084944
#yiv0331084944ygrp-mlmsg pre, #yiv0331084944 code {font:115%
monospace;}#yiv0331084944 #yiv0331084944ygrp-mlmsg *
{line-height:1.22em;}#yiv0331084944 #yiv0331084944ygrp-mlmsg #yiv0331084944logo
{padding-bottom:10px;}#yiv0331084944 #yiv0331084944ygrp-msg p a
{font-family:Verdana;}#yiv0331084944 #yiv0331084944ygrp-msg
p#yiv0331084944attach-count span {color:#1E66AE;font-weight:700;}#yiv0331084944
#yiv0331084944ygrp-reco #yiv0331084944reco-head
{color:#ff7900;font-weight:700;}#yiv0331084944 #yiv0331084944ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0331084944 #yiv0331084944ygrp-sponsor
#yiv0331084944ov li a {font-size:130%;text-decoration:none;}#yiv0331084944
#yiv0331084944ygrp-sponsor #yiv0331084944ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0331084944
#yiv0331084944ygrp-sponsor #yiv0331084944ov ul {margin:0;padding:0 0 0
8px;}#yiv0331084944 #yiv0331084944ygrp-text
{font-family:Georgia;}#yiv0331084944 #yiv0331084944ygrp-text p {margin:0 0 1em
0;}#yiv0331084944 #yiv0331084944ygrp-text tt {font-size:120%;}#yiv0331084944
#yiv0331084944ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0331084944
re2-lookup baris kolom.xlsx
Description: MS-Excel 2007 spreadsheet
