Dear Mr. Kid
Sebelumnya mohon maaf, file yang saya kirimkan tersebut sudah dibuatkan nama
range nya,tetapi tidak dapat dibuatkan data validasi nya.Mohon pencerahannya,
mungkin ada yang salah saat penulisan formulanya dan barangkali bisa dibuatkan
1 contohnya saja.
Terima kasihWassalam
Pada Senin, 15 Februari 2016 21:41, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
Sumber data validation list sebaiknya dibuatkan nama range.
Coretan tentang data validation list banyak tingkat ada disini. Pembahasan
tentang data validation list dimulai dari sini.
Wassalamu'alaikum wr wb
Kid
2016-02-15 21:12 GMT+07:00 Rudhie [email protected] [belajar-excel]
<[email protected]>:
Dear Be Exceller
Assalam wrwbMohon bantuannya bagaimana caranya membuat suatu data validasi
bertingkat yang bersumber dilain sheet.Saya sudah mencoba membuatnya, tetapi
tidak bisa.Pada File yang Saya lampirkan ini, saya mencoba membuat data
validasi bertingkat di Sheet "Data" pada kolom N, O dan P dengan sumber data di
sheet yang sama.Tetapi ketika Saya mencoba membuatnya di Sheet "Sales" dengan
formula yang sama pada sheet "Data" hasilnya formulanya tidak bisa digunakan /
ditolak karena "mengunakan data dilain sheet".Kira - kira apakah data validasi
bertingkat yang bersumber dilain sheet bisa dibuat ?Mohon kiranya penjelasan
dan bantuannya untuk rumus formulanya jika ada.
Terima KasihWassalam
Rudhie
#yiv4843411809 #yiv4843411809 -- #yiv4843411809ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4843411809
#yiv4843411809ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4843411809
#yiv4843411809ygrp-mkp #yiv4843411809hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4843411809 #yiv4843411809ygrp-mkp #yiv4843411809ads
{margin-bottom:10px;}#yiv4843411809 #yiv4843411809ygrp-mkp .yiv4843411809ad
{padding:0 0;}#yiv4843411809 #yiv4843411809ygrp-mkp .yiv4843411809ad p
{margin:0;}#yiv4843411809 #yiv4843411809ygrp-mkp .yiv4843411809ad a
{color:#0000ff;text-decoration:none;}#yiv4843411809 #yiv4843411809ygrp-sponsor
#yiv4843411809ygrp-lc {font-family:Arial;}#yiv4843411809
#yiv4843411809ygrp-sponsor #yiv4843411809ygrp-lc #yiv4843411809hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4843411809
#yiv4843411809ygrp-sponsor #yiv4843411809ygrp-lc .yiv4843411809ad
{margin-bottom:10px;padding:0 0;}#yiv4843411809 #yiv4843411809actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4843411809
#yiv4843411809activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4843411809
#yiv4843411809activity span {font-weight:700;}#yiv4843411809
#yiv4843411809activity span:first-child
{text-transform:uppercase;}#yiv4843411809 #yiv4843411809activity span a
{color:#5085b6;text-decoration:none;}#yiv4843411809 #yiv4843411809activity span
span {color:#ff7900;}#yiv4843411809 #yiv4843411809activity span
.yiv4843411809underline {text-decoration:underline;}#yiv4843411809
.yiv4843411809attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4843411809 .yiv4843411809attach div a
{text-decoration:none;}#yiv4843411809 .yiv4843411809attach img
{border:none;padding-right:5px;}#yiv4843411809 .yiv4843411809attach label
{display:block;margin-bottom:5px;}#yiv4843411809 .yiv4843411809attach label a
{text-decoration:none;}#yiv4843411809 blockquote {margin:0 0 0
4px;}#yiv4843411809 .yiv4843411809bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4843411809
.yiv4843411809bold a {text-decoration:none;}#yiv4843411809 dd.yiv4843411809last
p a {font-family:Verdana;font-weight:700;}#yiv4843411809 dd.yiv4843411809last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4843411809
dd.yiv4843411809last p span.yiv4843411809yshortcuts
{margin-right:0;}#yiv4843411809 div.yiv4843411809attach-table div div a
{text-decoration:none;}#yiv4843411809 div.yiv4843411809attach-table
{width:400px;}#yiv4843411809 div.yiv4843411809file-title a, #yiv4843411809
div.yiv4843411809file-title a:active, #yiv4843411809
div.yiv4843411809file-title a:hover, #yiv4843411809 div.yiv4843411809file-title
a:visited {text-decoration:none;}#yiv4843411809 div.yiv4843411809photo-title a,
#yiv4843411809 div.yiv4843411809photo-title a:active, #yiv4843411809
div.yiv4843411809photo-title a:hover, #yiv4843411809
div.yiv4843411809photo-title a:visited {text-decoration:none;}#yiv4843411809
div#yiv4843411809ygrp-mlmsg #yiv4843411809ygrp-msg p a
span.yiv4843411809yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4843411809
.yiv4843411809green {color:#628c2a;}#yiv4843411809 .yiv4843411809MsoNormal
{margin:0 0 0 0;}#yiv4843411809 o {font-size:0;}#yiv4843411809
#yiv4843411809photos div {float:left;width:72px;}#yiv4843411809
#yiv4843411809photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4843411809
#yiv4843411809photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4843411809
#yiv4843411809reco-category {font-size:77%;}#yiv4843411809
#yiv4843411809reco-desc {font-size:77%;}#yiv4843411809 .yiv4843411809replbq
{margin:4px;}#yiv4843411809 #yiv4843411809ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4843411809 #yiv4843411809ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4843411809
#yiv4843411809ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4843411809
#yiv4843411809ygrp-mlmsg select, #yiv4843411809 input, #yiv4843411809 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4843411809
#yiv4843411809ygrp-mlmsg pre, #yiv4843411809 code {font:115%
monospace;}#yiv4843411809 #yiv4843411809ygrp-mlmsg *
{line-height:1.22em;}#yiv4843411809 #yiv4843411809ygrp-mlmsg #yiv4843411809logo
{padding-bottom:10px;}#yiv4843411809 #yiv4843411809ygrp-msg p a
{font-family:Verdana;}#yiv4843411809 #yiv4843411809ygrp-msg
p#yiv4843411809attach-count span {color:#1E66AE;font-weight:700;}#yiv4843411809
#yiv4843411809ygrp-reco #yiv4843411809reco-head
{color:#ff7900;font-weight:700;}#yiv4843411809 #yiv4843411809ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4843411809 #yiv4843411809ygrp-sponsor
#yiv4843411809ov li a {font-size:130%;text-decoration:none;}#yiv4843411809
#yiv4843411809ygrp-sponsor #yiv4843411809ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4843411809
#yiv4843411809ygrp-sponsor #yiv4843411809ov ul {margin:0;padding:0 0 0
8px;}#yiv4843411809 #yiv4843411809ygrp-text
{font-family:Georgia;}#yiv4843411809 #yiv4843411809ygrp-text p {margin:0 0 1em
0;}#yiv4843411809 #yiv4843411809ygrp-text tt {font-size:120%;}#yiv4843411809
#yiv4843411809ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4843411809
