mr kid,
thanks a lot yaa..
Pada Selasa, 5 Mei 2015 13:35, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Link antar sheet bisa berbagai macam. Contoh data beserta penjelasan link yang
dibutuhkan dalam pengolahan data tersebut akan memudahkan BeExceller dalam urun
solusi.
Salah satu cara membuat link adalah dengan fitur Excel bernama Excel Formula.
Contoh sederhananya begini :
ada 1 workbook berisi 2 sheet, sheet1 dan sheet2.
sheet1 untuk menyimpan data, misal di A1 berisi nilai 123
pada sheet2 cell G3 diberi formula dengan cara menuliskan (ketik di keyboard)
bunyi berikut :
=sheet1!a1
lalu tekan enter.
Coba ke sheet1 dan ganti angka 123 dengan 456. Lihat di sheet2 range G3.
Wassalam,
Kid
2015-05-05 14:58 GMT+10:00 laily anti [email protected] [belajar-excel]
<[email protected]>:
all,
mohon bantuannya :)
Pada Jumat, 1 Mei 2015 0:59, "[email protected]" <[email protected]>
menulis:
Assalamualaikum ,
Salam kenal semua, mohon pencerahannya..
Bgmn cara nya agar 1 sheet dgn sheet lainya bs saling nge link jika di update
salah satuny sheet nya..
Terima kasih bnyk atas bantuannya..
Wassalam..
Sent from my iPad
#yiv5102415971 -- #yiv5102415971ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5102415971
#yiv5102415971ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5102415971
#yiv5102415971ygrp-mkp #yiv5102415971hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5102415971 #yiv5102415971ygrp-mkp #yiv5102415971ads
{margin-bottom:10px;}#yiv5102415971 #yiv5102415971ygrp-mkp .yiv5102415971ad
{padding:0 0;}#yiv5102415971 #yiv5102415971ygrp-mkp .yiv5102415971ad p
{margin:0;}#yiv5102415971 #yiv5102415971ygrp-mkp .yiv5102415971ad a
{color:#0000ff;text-decoration:none;}#yiv5102415971 #yiv5102415971ygrp-sponsor
#yiv5102415971ygrp-lc {font-family:Arial;}#yiv5102415971
#yiv5102415971ygrp-sponsor #yiv5102415971ygrp-lc #yiv5102415971hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5102415971
#yiv5102415971ygrp-sponsor #yiv5102415971ygrp-lc .yiv5102415971ad
{margin-bottom:10px;padding:0 0;}#yiv5102415971 #yiv5102415971actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5102415971
#yiv5102415971activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5102415971
#yiv5102415971activity span {font-weight:700;}#yiv5102415971
#yiv5102415971activity span:first-child
{text-transform:uppercase;}#yiv5102415971 #yiv5102415971activity span a
{color:#5085b6;text-decoration:none;}#yiv5102415971 #yiv5102415971activity span
span {color:#ff7900;}#yiv5102415971 #yiv5102415971activity span
.yiv5102415971underline {text-decoration:underline;}#yiv5102415971
.yiv5102415971attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5102415971 .yiv5102415971attach div a
{text-decoration:none;}#yiv5102415971 .yiv5102415971attach img
{border:none;padding-right:5px;}#yiv5102415971 .yiv5102415971attach label
{display:block;margin-bottom:5px;}#yiv5102415971 .yiv5102415971attach label a
{text-decoration:none;}#yiv5102415971 blockquote {margin:0 0 0
4px;}#yiv5102415971 .yiv5102415971bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5102415971
.yiv5102415971bold a {text-decoration:none;}#yiv5102415971 dd.yiv5102415971last
p a {font-family:Verdana;font-weight:700;}#yiv5102415971 dd.yiv5102415971last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5102415971
dd.yiv5102415971last p span.yiv5102415971yshortcuts
{margin-right:0;}#yiv5102415971 div.yiv5102415971attach-table div div a
{text-decoration:none;}#yiv5102415971 div.yiv5102415971attach-table
{width:400px;}#yiv5102415971 div.yiv5102415971file-title a, #yiv5102415971
div.yiv5102415971file-title a:active, #yiv5102415971
div.yiv5102415971file-title a:hover, #yiv5102415971 div.yiv5102415971file-title
a:visited {text-decoration:none;}#yiv5102415971 div.yiv5102415971photo-title a,
#yiv5102415971 div.yiv5102415971photo-title a:active, #yiv5102415971
div.yiv5102415971photo-title a:hover, #yiv5102415971
div.yiv5102415971photo-title a:visited {text-decoration:none;}#yiv5102415971
div#yiv5102415971ygrp-mlmsg #yiv5102415971ygrp-msg p a
span.yiv5102415971yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5102415971
.yiv5102415971green {color:#628c2a;}#yiv5102415971 .yiv5102415971MsoNormal
{margin:0 0 0 0;}#yiv5102415971 o {font-size:0;}#yiv5102415971
#yiv5102415971photos div {float:left;width:72px;}#yiv5102415971
#yiv5102415971photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5102415971
#yiv5102415971photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5102415971
#yiv5102415971reco-category {font-size:77%;}#yiv5102415971
#yiv5102415971reco-desc {font-size:77%;}#yiv5102415971 .yiv5102415971replbq
{margin:4px;}#yiv5102415971 #yiv5102415971ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5102415971 #yiv5102415971ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5102415971
#yiv5102415971ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5102415971
#yiv5102415971ygrp-mlmsg select, #yiv5102415971 input, #yiv5102415971 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5102415971
#yiv5102415971ygrp-mlmsg pre, #yiv5102415971 code {font:115%
monospace;}#yiv5102415971 #yiv5102415971ygrp-mlmsg *
{line-height:1.22em;}#yiv5102415971 #yiv5102415971ygrp-mlmsg #yiv5102415971logo
{padding-bottom:10px;}#yiv5102415971 #yiv5102415971ygrp-msg p a
{font-family:Verdana;}#yiv5102415971 #yiv5102415971ygrp-msg
p#yiv5102415971attach-count span {color:#1E66AE;font-weight:700;}#yiv5102415971
#yiv5102415971ygrp-reco #yiv5102415971reco-head
{color:#ff7900;font-weight:700;}#yiv5102415971 #yiv5102415971ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5102415971 #yiv5102415971ygrp-sponsor
#yiv5102415971ov li a {font-size:130%;text-decoration:none;}#yiv5102415971
#yiv5102415971ygrp-sponsor #yiv5102415971ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5102415971
#yiv5102415971ygrp-sponsor #yiv5102415971ov ul {margin:0;padding:0 0 0
8px;}#yiv5102415971 #yiv5102415971ygrp-text
{font-family:Georgia;}#yiv5102415971 #yiv5102415971ygrp-text p {margin:0 0 1em
0;}#yiv5102415971 #yiv5102415971ygrp-text tt {font-size:120%;}#yiv5102415971
#yiv5102415971ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5102415971
