Bls: [belajar-excel] mencegah input data ganda

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

Dear Imam,

Perhatikan pembuatan Name Manager, coba di check lagi Name yang ada di Name 
Manager (di lihat refrence Row dan cell nya)
Jika mau membuat data validation pada combobox, tempatkan di tempat yang tepat.

TerimaKasih.



Pada Rab, 24/2/16, imam cahyo yuwono chy...@yahoo.com [belajar-excel] 
<belajar-excel@yahoogroups.com> menulis:

 Judul: [belajar-excel] mencegah input data ganda [1 Attachment]
 Kepada: belajar-excel@yahoogroups.com
 Tanggal: Rabu, 24 Februari, 2016, 10:19 AM
 
 
  
 
 
 
   
 
 
     
       
       
       dear para
 master 
 
 1. saya
 membuat form input data untuk mencegah data ganda script nya
 bagaimana 
 2. saya
 membuat lookup combo box yang berhubungan dengan textbox
 kalo supaya bisa membaca ke kiri bagaimana caranya
 terima
 kasih
 
 
     
      
 
     
     
 
 
 
 #yiv3674497179 #yiv3674497179 --
   #yiv3674497179ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv3674497179 #yiv3674497179ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv3674497179 #yiv3674497179ygrp-mkp #yiv3674497179hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv3674497179 #yiv3674497179ygrp-mkp #yiv3674497179ads {
 margin-bottom:10px;}
 
 #yiv3674497179 #yiv3674497179ygrp-mkp .yiv3674497179ad {
 padding:0 0;}
 
 #yiv3674497179 #yiv3674497179ygrp-mkp .yiv3674497179ad p {
 margin:0;}
 
 #yiv3674497179 #yiv3674497179ygrp-mkp .yiv3674497179ad a {
 color:#0000ff;text-decoration:none;}
 #yiv3674497179 #yiv3674497179ygrp-sponsor
 #yiv3674497179ygrp-lc {
 font-family:Arial;}
 
 #yiv3674497179 #yiv3674497179ygrp-sponsor
 #yiv3674497179ygrp-lc #yiv3674497179hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv3674497179 #yiv3674497179ygrp-sponsor
 #yiv3674497179ygrp-lc .yiv3674497179ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv3674497179 #yiv3674497179actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv3674497179 #yiv3674497179activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv3674497179 #yiv3674497179activity span {
 font-weight:700;}
 
 #yiv3674497179 #yiv3674497179activity span:first-child {
 text-transform:uppercase;}
 
 #yiv3674497179 #yiv3674497179activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv3674497179 #yiv3674497179activity span span {
 color:#ff7900;}
 
 #yiv3674497179 #yiv3674497179activity span
 .yiv3674497179underline {
 text-decoration:underline;}
 
 #yiv3674497179 .yiv3674497179attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv3674497179 .yiv3674497179attach div a {
 text-decoration:none;}
 
 #yiv3674497179 .yiv3674497179attach img {
 border:none;padding-right:5px;}
 
 #yiv3674497179 .yiv3674497179attach label {
 display:block;margin-bottom:5px;}
 
 #yiv3674497179 .yiv3674497179attach label a {
 text-decoration:none;}
 
 #yiv3674497179 blockquote {
 margin:0 0 0 4px;}
 
 #yiv3674497179 .yiv3674497179bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv3674497179 .yiv3674497179bold a {
 text-decoration:none;}
 
 #yiv3674497179 dd.yiv3674497179last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv3674497179 dd.yiv3674497179last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv3674497179 dd.yiv3674497179last p
 span.yiv3674497179yshortcuts {
 margin-right:0;}
 
 #yiv3674497179 div.yiv3674497179attach-table div div a {
 text-decoration:none;}
 
 #yiv3674497179 div.yiv3674497179attach-table {
 width:400px;}
 
 #yiv3674497179 div.yiv3674497179file-title a, #yiv3674497179
 div.yiv3674497179file-title a:active, #yiv3674497179
 div.yiv3674497179file-title a:hover, #yiv3674497179
 div.yiv3674497179file-title a:visited {
 text-decoration:none;}
 
 #yiv3674497179 div.yiv3674497179photo-title a,
 #yiv3674497179 div.yiv3674497179photo-title a:active,
 #yiv3674497179 div.yiv3674497179photo-title a:hover,
 #yiv3674497179 div.yiv3674497179photo-title a:visited {
 text-decoration:none;}
 
 #yiv3674497179 div#yiv3674497179ygrp-mlmsg
 #yiv3674497179ygrp-msg p a span.yiv3674497179yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv3674497179 .yiv3674497179green {
 color:#628c2a;}
 
 #yiv3674497179 .yiv3674497179MsoNormal {
 margin:0 0 0 0;}
 
 #yiv3674497179 o {
 font-size:0;}
 
 #yiv3674497179 #yiv3674497179photos div {
 float:left;width:72px;}
 
 #yiv3674497179 #yiv3674497179photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv3674497179 #yiv3674497179photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv3674497179 #yiv3674497179reco-category {
 font-size:77%;}
 
 #yiv3674497179 #yiv3674497179reco-desc {
 font-size:77%;}
 
 #yiv3674497179 .yiv3674497179replbq {
 margin:4px;}
 
 #yiv3674497179 #yiv3674497179ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv3674497179 #yiv3674497179ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv3674497179 #yiv3674497179ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv3674497179 #yiv3674497179ygrp-mlmsg select,
 #yiv3674497179 input, #yiv3674497179 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv3674497179 #yiv3674497179ygrp-mlmsg pre, #yiv3674497179
 code {
 font:115% monospace;}
 
 #yiv3674497179 #yiv3674497179ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv3674497179 #yiv3674497179ygrp-mlmsg #yiv3674497179logo {
 padding-bottom:10px;}
 
 
 #yiv3674497179 #yiv3674497179ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv3674497179 #yiv3674497179ygrp-msg
 p#yiv3674497179attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv3674497179 #yiv3674497179ygrp-reco
 #yiv3674497179reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv3674497179 #yiv3674497179ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv3674497179 #yiv3674497179ygrp-sponsor #yiv3674497179ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv3674497179 #yiv3674497179ygrp-sponsor #yiv3674497179ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv3674497179 #yiv3674497179ygrp-sponsor #yiv3674497179ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv3674497179 #yiv3674497179ygrp-text {
 font-family:Georgia;}
 
 #yiv3674497179 #yiv3674497179ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv3674497179 #yiv3674497179ygrp-text tt {
 font-size:120%;}
 
 #yiv3674497179 #yiv3674497179ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv3674497179