Kalau pake perasaan, kira2 begini jawabannya...Insert hyperlink, place in this
document, pilih sheet dan sel yang mau di link, tekan OK.Kalau mau edit harus
diulangi prosesnya, tidak bisa diedit di formula bar.
Salam,HK
Sent from Yahoo Mail on Android
On Mon, Feb 26, 2018 at 10:09, hendrik karnadi hendrikkarn...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com> wrote:
Hai Rian,
Coba lampirkan dummy filenya..Jawabannya pasti akan lebih pas....
Salam,HK
Sent from Yahoo Mail on Android
On Mon, Feb 26, 2018 at 9:10, Rian Sutarsa riansuta...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com> wrote:
Assalamu'alaikum Wr.Wb..adakah formula untuk menghubungkan satu cell ke sheet
tertentu?misal di sheet Bulanan, A1=Sheet1 kemudian hasilnya akan menampilkan
data hasil formula vlookup yang ada di sheet1 dan ketika saya merubah A1 dengan
Sheet2 hasilnya akan menampilkan data hasil formula vlookup yang ada di sheet2
dan seterusnya dan seterusnya.mohon solusinya para Master
Wassalamu'alaikum Wr.Wb.
#yiv1956991124 #yiv1956991124 -- #yiv1956991124ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1956991124
#yiv1956991124ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1956991124
#yiv1956991124ygrp-mkp #yiv1956991124hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1956991124 #yiv1956991124ygrp-mkp #yiv1956991124ads
{margin-bottom:10px;}#yiv1956991124 #yiv1956991124ygrp-mkp .yiv1956991124ad
{padding:0 0;}#yiv1956991124 #yiv1956991124ygrp-mkp .yiv1956991124ad p
{margin:0;}#yiv1956991124 #yiv1956991124ygrp-mkp .yiv1956991124ad a
{color:#0000ff;text-decoration:none;}#yiv1956991124 #yiv1956991124ygrp-sponsor
#yiv1956991124ygrp-lc {font-family:Arial;}#yiv1956991124
#yiv1956991124ygrp-sponsor #yiv1956991124ygrp-lc #yiv1956991124hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1956991124
#yiv1956991124ygrp-sponsor #yiv1956991124ygrp-lc .yiv1956991124ad
{margin-bottom:10px;padding:0 0;}#yiv1956991124 #yiv1956991124actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1956991124
#yiv1956991124activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1956991124
#yiv1956991124activity span {font-weight:700;}#yiv1956991124
#yiv1956991124activity span:first-child
{text-transform:uppercase;}#yiv1956991124 #yiv1956991124activity span a
{color:#5085b6;text-decoration:none;}#yiv1956991124 #yiv1956991124activity span
span {color:#ff7900;}#yiv1956991124 #yiv1956991124activity span
.yiv1956991124underline {text-decoration:underline;}#yiv1956991124
.yiv1956991124attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1956991124 .yiv1956991124attach div a
{text-decoration:none;}#yiv1956991124 .yiv1956991124attach img
{border:none;padding-right:5px;}#yiv1956991124 .yiv1956991124attach label
{display:block;margin-bottom:5px;}#yiv1956991124 .yiv1956991124attach label a
{text-decoration:none;}#yiv1956991124 blockquote {margin:0 0 0
4px;}#yiv1956991124 .yiv1956991124bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1956991124
.yiv1956991124bold a {text-decoration:none;}#yiv1956991124 dd.yiv1956991124last
p a {font-family:Verdana;font-weight:700;}#yiv1956991124 dd.yiv1956991124last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1956991124
dd.yiv1956991124last p span.yiv1956991124yshortcuts
{margin-right:0;}#yiv1956991124 div.yiv1956991124attach-table div div a
{text-decoration:none;}#yiv1956991124 div.yiv1956991124attach-table
{width:400px;}#yiv1956991124 div.yiv1956991124file-title a, #yiv1956991124
div.yiv1956991124file-title a:active, #yiv1956991124
div.yiv1956991124file-title a:hover, #yiv1956991124 div.yiv1956991124file-title
a:visited {text-decoration:none;}#yiv1956991124 div.yiv1956991124photo-title a,
#yiv1956991124 div.yiv1956991124photo-title a:active, #yiv1956991124
div.yiv1956991124photo-title a:hover, #yiv1956991124
div.yiv1956991124photo-title a:visited {text-decoration:none;}#yiv1956991124
div#yiv1956991124ygrp-mlmsg #yiv1956991124ygrp-msg p a
span.yiv1956991124yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1956991124
.yiv1956991124green {color:#628c2a;}#yiv1956991124 .yiv1956991124MsoNormal
{margin:0 0 0 0;}#yiv1956991124 o {font-size:0;}#yiv1956991124
#yiv1956991124photos div {float:left;width:72px;}#yiv1956991124
#yiv1956991124photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1956991124
#yiv1956991124photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1956991124
#yiv1956991124reco-category {font-size:77%;}#yiv1956991124
#yiv1956991124reco-desc {font-size:77%;}#yiv1956991124 .yiv1956991124replbq
{margin:4px;}#yiv1956991124 #yiv1956991124ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1956991124 #yiv1956991124ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1956991124
#yiv1956991124ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1956991124
#yiv1956991124ygrp-mlmsg select, #yiv1956991124 input, #yiv1956991124 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1956991124
#yiv1956991124ygrp-mlmsg pre, #yiv1956991124 code {font:115%
monospace;}#yiv1956991124 #yiv1956991124ygrp-mlmsg *
{line-height:1.22em;}#yiv1956991124 #yiv1956991124ygrp-mlmsg #yiv1956991124logo
{padding-bottom:10px;}#yiv1956991124 #yiv1956991124ygrp-msg p a
{font-family:Verdana;}#yiv1956991124 #yiv1956991124ygrp-msg
p#yiv1956991124attach-count span {color:#1E66AE;font-weight:700;}#yiv1956991124
#yiv1956991124ygrp-reco #yiv1956991124reco-head
{color:#ff7900;font-weight:700;}#yiv1956991124 #yiv1956991124ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1956991124 #yiv1956991124ygrp-sponsor
#yiv1956991124ov li a {font-size:130%;text-decoration:none;}#yiv1956991124
#yiv1956991124ygrp-sponsor #yiv1956991124ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1956991124
#yiv1956991124ygrp-sponsor #yiv1956991124ov ul {margin:0;padding:0 0 0
8px;}#yiv1956991124 #yiv1956991124ygrp-text
{font-family:Georgia;}#yiv1956991124 #yiv1956991124ygrp-text p {margin:0 0 1em
0;}#yiv1956991124 #yiv1956991124ygrp-text tt {font-size:120%;}#yiv1956991124
#yiv1956991124ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1956991124
