Hai Edo,
Codenya tinggal di ganti aja, misal di Sheet2 maka code yang ada tulisannya
Sheet1 di ganti dengan Sheet2 dan seterusnya. di perhatikan juga untuk data
validation, kalo datanya di kolom 2, ya di ganti di kolom 2.
TerimaKasih.
Pada Rabu, 15 Juni 2016 0:22, "Edo Hanggoro [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Tobi,
Terima kasih atas bantuannya untuk kode VBA yang anda berikan. Saya ingin
menanyakan satu hal lagi mengenai kode VBA tersebut jika seandainya listnya
berada di lain sheet, bagaimana dengan kode VBA-nya?
Terima kasih
Edo
On Tuesday, June 14, 2016 9:33 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Edo,
Coba gunakan code VBA ini pada Event Worksheet_Activate()
Sheet1.Range("D2").Value = Sheet1.Cells(Cells(1, 1).End(xlDown).Row, 1).Value
TerimaKasih
Pada Selasa, 14 Juni 2016 16:54, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Dear Master,
Bagaimana caranya agar setiap kita membuka "Sheet1" (file terlampir) maka pada
data validation di sel "D2" akan selalu merujuk pada item terakhir pada list
data validation ?
Terima kasih
Edo
#yiv0343809837 #yiv0343809837 -- #yiv0343809837ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0343809837
#yiv0343809837ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0343809837
#yiv0343809837ygrp-mkp #yiv0343809837hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0343809837 #yiv0343809837ygrp-mkp #yiv0343809837ads
{margin-bottom:10px;}#yiv0343809837 #yiv0343809837ygrp-mkp .yiv0343809837ad
{padding:0 0;}#yiv0343809837 #yiv0343809837ygrp-mkp .yiv0343809837ad p
{margin:0;}#yiv0343809837 #yiv0343809837ygrp-mkp .yiv0343809837ad a
{color:#0000ff;text-decoration:none;}#yiv0343809837 #yiv0343809837ygrp-sponsor
#yiv0343809837ygrp-lc {font-family:Arial;}#yiv0343809837
#yiv0343809837ygrp-sponsor #yiv0343809837ygrp-lc #yiv0343809837hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0343809837
#yiv0343809837ygrp-sponsor #yiv0343809837ygrp-lc .yiv0343809837ad
{margin-bottom:10px;padding:0 0;}#yiv0343809837 #yiv0343809837actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0343809837
#yiv0343809837activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0343809837
#yiv0343809837activity span {font-weight:700;}#yiv0343809837
#yiv0343809837activity span:first-child
{text-transform:uppercase;}#yiv0343809837 #yiv0343809837activity span a
{color:#5085b6;text-decoration:none;}#yiv0343809837 #yiv0343809837activity span
span {color:#ff7900;}#yiv0343809837 #yiv0343809837activity span
.yiv0343809837underline {text-decoration:underline;}#yiv0343809837
.yiv0343809837attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0343809837 .yiv0343809837attach div a
{text-decoration:none;}#yiv0343809837 .yiv0343809837attach img
{border:none;padding-right:5px;}#yiv0343809837 .yiv0343809837attach label
{display:block;margin-bottom:5px;}#yiv0343809837 .yiv0343809837attach label a
{text-decoration:none;}#yiv0343809837 blockquote {margin:0 0 0
4px;}#yiv0343809837 .yiv0343809837bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0343809837
.yiv0343809837bold a {text-decoration:none;}#yiv0343809837 dd.yiv0343809837last
p a {font-family:Verdana;font-weight:700;}#yiv0343809837 dd.yiv0343809837last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0343809837
dd.yiv0343809837last p span.yiv0343809837yshortcuts
{margin-right:0;}#yiv0343809837 div.yiv0343809837attach-table div div a
{text-decoration:none;}#yiv0343809837 div.yiv0343809837attach-table
{width:400px;}#yiv0343809837 div.yiv0343809837file-title a, #yiv0343809837
div.yiv0343809837file-title a:active, #yiv0343809837
div.yiv0343809837file-title a:hover, #yiv0343809837 div.yiv0343809837file-title
a:visited {text-decoration:none;}#yiv0343809837 div.yiv0343809837photo-title a,
#yiv0343809837 div.yiv0343809837photo-title a:active, #yiv0343809837
div.yiv0343809837photo-title a:hover, #yiv0343809837
div.yiv0343809837photo-title a:visited {text-decoration:none;}#yiv0343809837
div#yiv0343809837ygrp-mlmsg #yiv0343809837ygrp-msg p a
span.yiv0343809837yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0343809837
.yiv0343809837green {color:#628c2a;}#yiv0343809837 .yiv0343809837MsoNormal
{margin:0 0 0 0;}#yiv0343809837 o {font-size:0;}#yiv0343809837
#yiv0343809837photos div {float:left;width:72px;}#yiv0343809837
#yiv0343809837photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0343809837
#yiv0343809837photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0343809837
#yiv0343809837reco-category {font-size:77%;}#yiv0343809837
#yiv0343809837reco-desc {font-size:77%;}#yiv0343809837 .yiv0343809837replbq
{margin:4px;}#yiv0343809837 #yiv0343809837ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0343809837 #yiv0343809837ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0343809837
#yiv0343809837ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0343809837
#yiv0343809837ygrp-mlmsg select, #yiv0343809837 input, #yiv0343809837 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0343809837
#yiv0343809837ygrp-mlmsg pre, #yiv0343809837 code {font:115%
monospace;}#yiv0343809837 #yiv0343809837ygrp-mlmsg *
{line-height:1.22em;}#yiv0343809837 #yiv0343809837ygrp-mlmsg #yiv0343809837logo
{padding-bottom:10px;}#yiv0343809837 #yiv0343809837ygrp-msg p a
{font-family:Verdana;}#yiv0343809837 #yiv0343809837ygrp-msg
p#yiv0343809837attach-count span {color:#1E66AE;font-weight:700;}#yiv0343809837
#yiv0343809837ygrp-reco #yiv0343809837reco-head
{color:#ff7900;font-weight:700;}#yiv0343809837 #yiv0343809837ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0343809837 #yiv0343809837ygrp-sponsor
#yiv0343809837ov li a {font-size:130%;text-decoration:none;}#yiv0343809837
#yiv0343809837ygrp-sponsor #yiv0343809837ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0343809837
#yiv0343809837ygrp-sponsor #yiv0343809837ov ul {margin:0;padding:0 0 0
8px;}#yiv0343809837 #yiv0343809837ygrp-text
{font-family:Georgia;}#yiv0343809837 #yiv0343809837ygrp-text p {margin:0 0 1em
0;}#yiv0343809837 #yiv0343809837ygrp-text tt {font-size:120%;}#yiv0343809837
#yiv0343809837ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0343809837
