Re: Fw: [belajar-excel] Cell ke Sheet di Workbook lain

[Rian Sutarsa riansuta...@yahoo.com [belajar-excel]]

 Mas HK ini saya coba lampirkan file nya ya

Pada ‎Senin‎, ‎26‎ ‎Februari‎ ‎2018‎ ‎10‎:‎17‎:‎27‎ ‎WIB, hendrik karnadi 
hendrikkarn...@yahoo.com [belajar-excel]  
menulis:

  
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] 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] 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.

  #yiv0269693650 #yiv0269693650 -- #yiv0269693650ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0269693650 
#yiv0269693650ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0269693650 
#yiv0269693650ygrp-mkp #yiv0269693650hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0269693650 #yiv0269693650ygrp-mkp #yiv0269693650ads 
{margin-bottom:10px;}#yiv0269693650 #yiv0269693650ygrp-mkp .yiv0269693650ad 
{padding:0 0;}#yiv0269693650 #yiv0269693650ygrp-mkp .yiv0269693650ad p 
{margin:0;}#yiv0269693650 #yiv0269693650ygrp-mkp .yiv0269693650ad a 
{color:#ff;text-decoration:none;}#yiv0269693650 #yiv0269693650ygrp-sponsor 
#yiv0269693650ygrp-lc {font-family:Arial;}#yiv0269693650 
#yiv0269693650ygrp-sponsor #yiv0269693650ygrp-lc #yiv0269693650hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0269693650 
#yiv0269693650ygrp-sponsor #yiv0269693650ygrp-lc .yiv0269693650ad 
{margin-bottom:10px;padding:0 0;}#yiv0269693650 #yiv0269693650actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0269693650 
#yiv0269693650activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0269693650
 #yiv0269693650activity span {font-weight:700;}#yiv0269693650 
#yiv0269693650activity span:first-child 
{text-transform:uppercase;}#yiv0269693650 #yiv0269693650activity span a 
{color:#5085b6;text-decoration:none;}#yiv0269693650 #yiv0269693650activity span 
span {color:#ff7900;}#yiv0269693650 #yiv0269693650activity span 
.yiv0269693650underline {text-decoration:underline;}#yiv0269693650 
.yiv0269693650attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0269693650 .yiv0269693650attach div a 
{text-decoration:none;}#yiv0269693650 .yiv0269693650attach img 
{border:none;padding-right:5px;}#yiv0269693650 .yiv0269693650attach label 
{display:block;margin-bottom:5px;}#yiv0269693650 .yiv0269693650attach label a 
{text-decoration:none;}#yiv0269693650 blockquote {margin:0 0 0 
4px;}#yiv0269693650 .yiv0269693650bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0269693650 
.yiv0269693650bold a {text-decoration:none;}#yiv0269693650 dd.yiv0269693650last 
p a {font-family:Verdana;font-weight:700;}#yiv0269693650 dd...yiv0269693650last 
p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0269693650 
dd.yiv0269693650last p span.yiv0269693650yshortcuts 
{margin-right:0;}#yiv0269693650 div.yiv0269693650attach-table div div a 
{text-decoration:none;}#yiv0269693650 div.yiv0269693650attach-table 
{width:400px;}#yiv0269693650 div.yiv0269693650file-title a, #yiv0269693650 
div.yiv0269693650file-title a:active, #yiv0269693650 
div.yiv0269693650file-title a:hover, #yiv0269693650 div.yiv0269693650file-title 
a:visited {text-decoration:none;}#yiv0269693650 div.yiv0269693650photo-title a, 
#yiv0269693650 div.yiv0269693650photo-title a:active, #yiv0269693650 
div.yiv0269693650photo-title a:hover, #yiv0269693650 
div.yiv0269693650photo-title a:visited {text-decoration:none;}#yiv0269693650 
div#yiv0269693650ygrp-mlmsg #yiv0269693650ygrp-msg p a 
span.yiv0269693650yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0269693650 
.yiv0269693650green {color:#628c2a;}#yiv0269693650 .yiv0269693650MsoNormal 
{margin:0 0 0 0;}#yiv0269693650 o {font-size:0;}#yiv0269693650 
#yiv0269693650photos div {float:left;width:72px;}#yiv0269693650 
#yiv0269693650photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0269693650 
#yiv0269693650photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0269693650
 #yiv0269693650reco-category 

Fw: [belajar-excel] Cell ke Sheet di Workbook lain

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

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] 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] 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:#ff;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 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1956991124 
#yiv1956991124photos div label 
{color:#66;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