mas agus saya jadi terpesona dengan yang namanya macro.. hehe..btw yang ini
macronya gimana mas?
Pada Sen, 26 Feb 2018 pada 13:05, Nangagus nanga...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
menampilkan nama sheet dapat menggunakan macro, namun harus selalu mengaktifkan
macro pada saat dibuka.
menampilkan nama sheet tanpa macro, harus selalu dibuka dahulu name manager.
On 25/02/2018 20:36, Rian Sutarsa riansuta...@yahoo.com [belajar-excel] wrote:
file nya sudah saya kirim diatas mas. terimakasih sebelumnya
Pada Sen, 26 Feb 2018 pada 11:30, Nangagus nanga...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com> menulis:
Wa'alaikumusalam Warahmatullah.
Dear Rian, biasanya saya menggunakan index match, dapat juga diganti dengan
formula vlookup, hlookup atau If,
Silahkan dikirim file contoh, akan lebih mudah menjawabnya.
Salam
NangAgus
On 25/02/2018 17:37, 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.
#yiv2423077772 #yiv2423077772 -- #yiv2423077772ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2423077772
#yiv2423077772ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2423077772
#yiv2423077772ygrp-mkp #yiv2423077772hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2423077772 #yiv2423077772ygrp-mkp #yiv2423077772ads
{margin-bottom:10px;}#yiv2423077772 #yiv2423077772ygrp-mkp .yiv2423077772ad
{padding:0 0;}#yiv2423077772 #yiv2423077772ygrp-mkp .yiv2423077772ad p
{margin:0;}#yiv2423077772 #yiv2423077772ygrp-mkp .yiv2423077772ad a
{color:#0000ff;text-decoration:none;}#yiv2423077772 #yiv2423077772ygrp-sponsor
#yiv2423077772ygrp-lc {font-family:Arial;}#yiv2423077772
#yiv2423077772ygrp-sponsor #yiv2423077772ygrp-lc #yiv2423077772hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2423077772
#yiv2423077772ygrp-sponsor #yiv2423077772ygrp-lc .yiv2423077772ad
{margin-bottom:10px;padding:0 0;}#yiv2423077772 #yiv2423077772actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2423077772
#yiv2423077772activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2423077772
#yiv2423077772activity span {font-weight:700;}#yiv2423077772
#yiv2423077772activity span:first-child
{text-transform:uppercase;}#yiv2423077772 #yiv2423077772activity span a
{color:#5085b6;text-decoration:none;}#yiv2423077772 #yiv2423077772activity span
span {color:#ff7900;}#yiv2423077772 #yiv2423077772activity span
.yiv2423077772underline {text-decoration:underline;}#yiv2423077772
...yiv2423077772attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2423077772 .yiv2423077772attach div a
{text-decoration:none;}#yiv2423077772 .yiv2423077772attach img
{border:none;padding-right:5px;}#yiv2423077772 .yiv2423077772attach label
{display:block;margin-bottom:5px;}#yiv2423077772 .yiv2423077772attach label a
{text-decoration:none;}#yiv2423077772 blockquote {margin:0 0 0
4px;}#yiv2423077772 .yiv2423077772bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2423077772
.yiv2423077772bold a {text-decoration:none;}#yiv2423077772 dd.yiv2423077772last
p a {font-family:Verdana;font-weight:700;}#yiv2423077772 dd.yiv2423077772last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2423077772
dd.yiv2423077772last p span.yiv2423077772yshortcuts
{margin-right:0;}#yiv2423077772 div.yiv2423077772attach-table div div a
{text-decoration:none;}#yiv2423077772 div.yiv2423077772attach-table
{width:400px;}#yiv2423077772 div.yiv2423077772file-title a, #yiv2423077772
div.yiv2423077772file-title a:active, #yiv2423077772
div.yiv2423077772file-title a:hover, #yiv2423077772 div.yiv2423077772file-title
a:visited {text-decoration:none;}#yiv2423077772 div.yiv2423077772photo-title a,
#yiv2423077772 div.yiv2423077772photo-title a:active, #yiv2423077772
div.yiv2423077772photo-title a:hover, #yiv2423077772
div.yiv2423077772photo-title a:visited {text-decoration:none;}#yiv2423077772
div#yiv2423077772ygrp-mlmsg #yiv2423077772ygrp-msg p a
span.yiv2423077772yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2423077772
.yiv2423077772green {color:#628c2a;}#yiv2423077772 .yiv2423077772MsoNormal
{margin:0 0 0 0;}#yiv2423077772 o {font-size:0;}#yiv2423077772
#yiv2423077772photos div {float:left;width:72px;}#yiv2423077772
#yiv2423077772photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2423077772
#yiv2423077772photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2423077772
#yiv2423077772reco-category {font-size:77%;}#yiv2423077772
#yiv2423077772reco-desc {font-size:77%;}#yiv2423077772 .yiv2423077772replbq
{margin:4px;}#yiv2423077772 #yiv2423077772ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2423077772 #yiv2423077772ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2423077772
#yiv2423077772ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2423077772
#yiv2423077772ygrp-mlmsg select, #yiv2423077772 input, #yiv2423077772 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2423077772
#yiv2423077772ygrp-mlmsg pre, #yiv2423077772 code {font:115%
monospace;}#yiv2423077772 #yiv2423077772ygrp-mlmsg *
{line-height:1.22em;}#yiv2423077772 #yiv2423077772ygrp-mlmsg #yiv2423077772logo
{padding-bottom:10px;}#yiv2423077772 #yiv2423077772ygrp-msg p a
{font-family:Verdana;}#yiv2423077772 #yiv2423077772ygrp-msg
p#yiv2423077772attach-count span {color:#1E66AE;font-weight:700;}#yiv2423077772
#yiv2423077772ygrp-reco #yiv2423077772reco-head
{color:#ff7900;font-weight:700;}#yiv2423077772 #yiv2423077772ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2423077772 #yiv2423077772ygrp-sponsor
#yiv2423077772ov li a {font-size:130%;text-decoration:none;}#yiv2423077772
#yiv2423077772ygrp-sponsor #yiv2423077772ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2423077772
#yiv2423077772ygrp-sponsor #yiv2423077772ov ul {margin:0;padding:0 0 0
8px;}#yiv2423077772 #yiv2423077772ygrp-text
{font-family:Georgia;}#yiv2423077772 #yiv2423077772ygrp-text p {margin:0 0 1em
0;}#yiv2423077772 #yiv2423077772ygrp-text tt {font-size:120%;}#yiv2423077772
#yiv2423077772ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2423077772
