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 [email protected]
[belajar-excel]" <[email protected]> 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
[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
#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
