Senin, 26 Februari 2018

[belajar-excel] Digest Number 4436

13 Messages

Digest #4436
1a
Cell ke Sheet di Workbook lain by "Rian Sutarsa" riansutarsa
1b
Re: Cell ke Sheet di Workbook lain by "hendrik karnadi" hendrikkarnadi
1c
Fw: [belajar-excel] Cell ke Sheet di Workbook lain by "hendrik karnadi" hendrikkarnadi

Messages

Sun Feb 25, 2018 6:09 pm (PST) . Posted by:

"Rian Sutarsa" riansutarsa

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.

Sun Feb 25, 2018 7:08 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

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 riansutarsa@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. #yiv8347167653 #yiv8347167653 -- #yiv8347167653ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8347167653 #yiv8347167653ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8347167653 #yiv8347167653ygrp-mkp #yiv8347167653hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8347167653 #yiv8347167653ygrp-mkp #yiv8347167653ads {margin-bottom:10px;}#yiv8347167653 #yiv8347167653ygrp-mkp .yiv8347167653ad {padding:0 0;}#yiv8347167653 #yiv8347167653ygrp-mkp .yiv8347167653ad p {margin:0;}#yiv8347167653 #yiv8347167653ygrp-mkp .yiv8347167653ad a {color:#0000ff;text-decoration:none;}#yiv8347167653 #yiv8347167653ygrp-sponsor #yiv8347167653ygrp-lc {font-family:Arial;}#yiv8347167653 #yiv8347167653ygrp-sponsor #yiv8347167653ygrp-lc #yiv8347167653hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8347167653 #yiv8347167653ygrp-sponsor #yiv8347167653ygrp-lc .yiv8347167653ad {margin-bottom:10px;padding:0 0;}#yiv8347167653 #yiv8347167653actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8347167653 #yiv8347167653activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8347167653 #yiv8347167653activity span {font-weight:700;}#yiv8347167653 #yiv8347167653activity span:first-child {text-transform:uppercase;}#yiv8347167653 #yiv8347167653activity span a {color:#5085b6;text-decoration:none;}#yiv8347167653 #yiv8347167653activity span span {color:#ff7900;}#yiv8347167653 #yiv8347167653activity span .yiv8347167653underline {text-decoration:underline;}#yiv8347167653 .yiv8347167653attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8347167653 .yiv8347167653attach div a {text-decoration:none;}#yiv8347167653 .yiv8347167653attach img {border:none;padding-right:5px;}#yiv8347167653 .yiv8347167653attach label {display:block;margin-bottom:5px;}#yiv8347167653 .yiv8347167653attach label a {text-decoration:none;}#yiv8347167653 blockquote {margin:0 0 0 4px;}#yiv8347167653 .yiv8347167653bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8347167653 .yiv8347167653bold a {text-decoration:none;}#yiv8347167653 dd.yiv8347167653last p a {font-family:Verdana;font-weight:700;}#yiv8347167653 dd.yiv8347167653last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8347167653 dd.yiv8347167653last p span.yiv8347167653yshortcuts {margin-right:0;}#yiv8347167653 div.yiv8347167653attach-table div div a {text-decoration:none;}#yiv8347167653 div.yiv8347167653attach-table {width:400px;}#yiv8347167653 div.yiv8347167653file-title a, #yiv8347167653 div.yiv8347167653file-title a:active, #yiv8347167653 div.yiv8347167653file-title a:hover, #yiv8347167653 div.yiv8347167653file-title a:visited {text-decoration:none;}#yiv8347167653 div.yiv8347167653photo-title a, #yiv8347167653 div.yiv8347167653photo-title a:active, #yiv8347167653 div.yiv8347167653photo-title a:hover, #yiv8347167653 div.yiv8347167653photo-title a:visited {text-decoration:none;}#yiv8347167653 div#yiv8347167653ygrp-mlmsg #yiv8347167653ygrp-msg p a span.yiv8347167653yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8347167653 .yiv8347167653green {color:#628c2a;}#yiv8347167653 .yiv8347167653MsoNormal {margin:0 0 0 0;}#yiv8347167653 o {font-size:0;}#yiv8347167653 #yiv8347167653photos div {float:left;width:72px;}#yiv8347167653 #yiv8347167653photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8347167653 #yiv8347167653photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8347167653 #yiv8347167653reco-category {font-size:77%;}#yiv8347167653 #yiv8347167653reco-desc {font-size:77%;}#yiv8347167653 .yiv8347167653replbq {margin:4px;}#yiv8347167653 #yiv8347167653ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8347167653 #yiv8347167653ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8347167653 #yiv8347167653ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8347167653 #yiv8347167653ygrp-mlmsg select, #yiv8347167653 input, #yiv8347167653 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8347167653 #yiv8347167653ygrp-mlmsg pre, #yiv8347167653 code {font:115% monospace;}#yiv8347167653 #yiv8347167653ygrp-mlmsg * {line-height:1.22em;}#yiv8347167653 #yiv8347167653ygrp-mlmsg #yiv8347167653logo {padding-bottom:10px;}#yiv8347167653 #yiv8347167653ygrp-msg p a {font-family:Verdana;}#yiv8347167653 #yiv8347167653ygrp-msg p#yiv8347167653attach-count span {color:#1E66AE;font-weight:700;}#yiv8347167653 #yiv8347167653ygrp-reco #yiv8347167653reco-head {color:#ff7900;font-weight:700;}#yiv8347167653 #yiv8347167653ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8347167653 #yiv8347167653ygrp-sponsor #yiv8347167653ov li a {font-size:130%;text-decoration:none;}#yiv8347167653 #yiv8347167653ygrp-sponsor #yiv8347167653ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8347167653 #yiv8347167653ygrp-sponsor #yiv8347167653ov ul {margin:0;padding:0 0 0 8px;}#yiv8347167653 #yiv8347167653ygrp-text {font-family:Georgia;}#yiv8347167653 #yiv8347167653ygrp-text p {margin:0 0 1em 0;}#yiv8347167653 #yiv8347167653ygrp-text tt {font-size:120%;}#yiv8347167653 #yiv8347167653ygrp-vital ul li:last-child {border-right:none !important;}#yiv8347167653

Sun Feb 25, 2018 7:17 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

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 hendrikkarnadi@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 riansutarsa@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

Sun Feb 25, 2018 8:23 pm (PST) . Posted by:

"Rian Sutarsa" riansutarsa

Mas HK ini saya coba lampirkan file nya ya

Pada ‎Senin‎, ‎26‎ ‎Februari‎ ‎2018‎ ‎10‎:‎17‎:‎27‎ ‎WIB, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> 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 hendrikkarnadi@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 riansutarsa@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.

#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:#0000ff;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 #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0269693650 #yiv0269693650photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0269693650 #yiv0269693650reco-category {font-size:77%;}#yiv0269693650 #yiv0269693650reco-desc {font-size:77%;}#yiv0269693650 .yiv0269693650replbq {margin:4px;}#yiv0269693650 #yiv0269693650ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0269693650 #yiv0269693650ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0269693650 #yiv0269693650ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0269693650 #yiv0269693650ygrp-mlmsg select, #yiv0269693650 input, #yiv0269693650 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0269693650 #yiv0269693650ygrp-mlmsg pre, #yiv0269693650 code {font:115% monospace;}#yiv0269693650 #yiv0269693650ygrp-mlmsg * {line-height:1.22em;}#yiv0269693650 #yiv0269693650ygrp-mlmsg #yiv0269693650logo {padding-bottom:10px;}#yiv0269693650 #yiv0269693650ygrp-msg p a {font-family:Verdana;}#yiv0269693650 #yiv0269693650ygrp-msg p#yiv0269693650attach-count span {color:#1E66AE;font-weight:700;}#yiv0269693650 #yiv0269693650ygrp-reco #yiv0269693650reco-head {color:#ff7900;font-weight:700;}#yiv0269693650 #yiv0269693650ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0269693650 #yiv0269693650ygrp-sponsor #yiv0269693650ov li a {font-size:130%;text-decoration:none;}#yiv0269693650 #yiv0269693650ygrp-sponsor #yiv0269693650ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0269693650 #yiv0269693650ygrp-sponsor #yiv0269693650ov ul {margin:0;padding:0 0 0 8px;}#yiv0269693650 #yiv0269693650ygrp-text {font-family:Georgia;}#yiv0269693650 #yiv0269693650ygrp-text p {margin:0 0 1em 0;}#yiv0269693650 #yiv0269693650ygrp-text tt {font-size:120%;}#yiv0269693650 #yiv0269693650ygrp-vital ul li:last-child {border-right:none !important;}#yiv0269693650

Sun Feb 25, 2018 8:28 pm (PST) . Posted by:

"Nangagus"

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 riansutarsa@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.
>

Sun Feb 25, 2018 8:41 pm (PST) . Posted by:

"Rian Sutarsa" riansutarsa


file nya sudah saya kirim diatas mas. terimakasih sebelumnya


Pada Sen, 26 Feb 2018 pada 11:30, Nangagus nangagus@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 riansutarsa@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.

#yiv5501865590 #yiv5501865590 -- #yiv5501865590ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5501865590 #yiv5501865590ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5501865590 #yiv5501865590ygrp-mkp #yiv5501865590hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5501865590 #yiv5501865590ygrp-mkp #yiv5501865590ads {margin-bottom:10px;}#yiv5501865590 #yiv5501865590ygrp-mkp .yiv5501865590ad {padding:0 0;}#yiv5501865590 #yiv5501865590ygrp-mkp .yiv5501865590ad p {margin:0;}#yiv5501865590 #yiv5501865590ygrp-mkp .yiv5501865590ad a {color:#0000ff;text-decoration:none;}#yiv5501865590 #yiv5501865590ygrp-sponsor #yiv5501865590ygrp-lc {font-family:Arial;}#yiv5501865590 #yiv5501865590ygrp-sponsor #yiv5501865590ygrp-lc #yiv5501865590hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5501865590 #yiv5501865590ygrp-sponsor #yiv5501865590ygrp-lc .yiv5501865590ad {margin-bottom:10px;padding:0 0;}#yiv5501865590 #yiv5501865590actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5501865590 #yiv5501865590activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5501865590 #yiv5501865590activity span {font-weight:700;}#yiv5501865590 #yiv5501865590activity span:first-child {text-transform:uppercase;}#yiv5501865590 #yiv5501865590activity span a {color:#5085b6;text-decoration:none;}#yiv5501865590 #yiv5501865590activity span span {color:#ff7900;}#yiv5501865590 #yiv5501865590activity span .yiv5501865590underline {text-decoration:underline;}#yiv5501865590 .yiv5501865590attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5501865590 .yiv5501865590attach div a {text-decoration:none;}#yiv5501865590 .yiv5501865590attach img {border:none;padding-right:5px;}#yiv5501865590 .yiv5501865590attach label {display:block;margin-bottom:5px;}#yiv5501865590 .yiv5501865590attach label a {text-decoration:none;}#yiv5501865590 blockquote {margin:0 0 0 4px;}#yiv5501865590 .yiv5501865590bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5501865590 .yiv5501865590bold a {text-decoration:none;}#yiv5501865590 dd.yiv5501865590last p a {font-family:Verdana;font-weight:700;}#yiv5501865590 dd.yiv5501865590last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5501865590 dd.yiv5501865590last p span.yiv5501865590yshortcuts {margin-right:0;}#yiv5501865590 div.yiv5501865590attach-table div div a {text-decoration:none;}#yiv5501865590 div.yiv5501865590attach-table {width:400px;}#yiv5501865590 div..yiv5501865590file-title a, #yiv5501865590 div.yiv5501865590file-title a:active, #yiv5501865590 div.yiv5501865590file-title a:hover, #yiv5501865590 div.yiv5501865590file-title a:visited {text-decoration:none;}#yiv5501865590 div.yiv5501865590photo-title a, #yiv5501865590 div.yiv5501865590photo-title a:active, #yiv5501865590 div.yiv5501865590photo-title a:hover, #yiv5501865590 div.yiv5501865590photo-title a:visited {text-decoration:none;}#yiv5501865590 div#yiv5501865590ygrp-mlmsg #yiv5501865590ygrp-msg p a span.yiv5501865590yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5501865590 .yiv5501865590green {color:#628c2a;}#yiv5501865590 .yiv5501865590MsoNormal {margin:0 0 0 0;}#yiv5501865590 o {font-size:0;}#yiv5501865590 #yiv5501865590photos div {float:left;width:72px;}#yiv5501865590 #yiv5501865590photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5501865590 #yiv5501865590photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5501865590 #yiv5501865590reco-category {font-size:77%;}#yiv5501865590 #yiv5501865590reco-desc {font-size:77%;}#yiv5501865590 .yiv5501865590replbq {margin:4px;}#yiv5501865590 #yiv5501865590ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5501865590 #yiv5501865590ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5501865590 #yiv5501865590ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5501865590 #yiv5501865590ygrp-mlmsg select, #yiv5501865590 input, #yiv5501865590 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5501865590 #yiv5501865590ygrp-mlmsg pre, #yiv5501865590 code {font:115% monospace;}#yiv5501865590 #yiv5501865590ygrp-mlmsg * {line-height:1.22em;}#yiv5501865590 #yiv5501865590ygrp-mlmsg #yiv5501865590logo {padding-bottom:10px;}#yiv5501865590 #yiv5501865590ygrp-msg p a {font-family:Verdana;}#yiv5501865590 #yiv5501865590ygrp-msg p#yiv5501865590attach-count span {color:#1E66AE;font-weight:700;}#yiv5501865590 #yiv5501865590ygrp-reco #yiv5501865590reco-head {color:#ff7900;font-weight:700;}#yiv5501865590 #yiv5501865590ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5501865590 #yiv5501865590ygrp-sponsor #yiv5501865590ov li a {font-size:130%;text-decoration:none;}#yiv5501865590 #yiv5501865590ygrp-sponsor #yiv5501865590ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5501865590 #yiv5501865590ygrp-sponsor #yiv5501865590ov ul {margin:0;padding:0 0 0 8px;}#yiv5501865590 #yiv5501865590ygrp-text {font-family:Georgia;}#yiv5501865590 #yiv5501865590ygrp-text p {margin:0 0 1em 0;}#yiv5501865590 #yiv5501865590ygrp-text tt {font-size:120%;}#yiv5501865590 #yiv5501865590ygrp-vital ul li:last-child {border-right:none !important;}#yiv5501865590

Sun Feb 25, 2018 8:41 pm (PST) . Posted by:

"Pak Cik Lukman"

Jika data cukup banyak tiap sheet, Manfaatkan Hyperlink, hanya hyperlink 1 koloum untuk berisi 1 link sheet... Kalau mau banyak sheet sptnya hrs banyak kolom yg merefer sheet2 lain.

Maaf jika jawaban tidak sesaui harapn, maklum msh tahap belajar.

Sent from my iPhone

> On Feb 26, 2018, at 8:37 AM, Rian Sutarsa riansutarsa@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.
>

Sun Feb 25, 2018 9:29 pm (PST) . Posted by:

"Nangagus"

Dear Riyan, Pakai satu file saja yaaa...

Cara bukanya, buka dahulu di tabs Formulas > Name Manager, add a name,
KLik Sheettss dengan formula =TRANSPOSE(GET.WORKBOOK(1))&T(NOW())

Sehingga nama sheet akan muncul di Sheet Bulanan, Range H1:H10 dan dapat
digunakan di menu pulldown di A1

On 25/02/2018 20:36, Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]
wrote:
>
>
> file nya sudah saya kirim diatas mas. terimakasih sebelumnya
>
>
> Pada Sen, 26 Feb 2018 pada 11:30, Nangagus nangagus@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 riansutarsa@yahoo.com
> <mailto:riansutarsa@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.
>
>

Sun Feb 25, 2018 10:05 pm (PST) . Posted by:

"Nangagus"

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 riansutarsa@yahoo.com [belajar-excel]
wrote:
>
>
> file nya sudah saya kirim diatas mas. terimakasih sebelumnya
>
>
> Pada Sen, 26 Feb 2018 pada 11:30, Nangagus nangagus@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 riansutarsa@yahoo.com
> <mailto:riansutarsa@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.
>
>

Sun Feb 25, 2018 8:23 pm (PST) . Posted by:

"Stephen Saputro"

Terima kasih Banyak Pak Kid, Pak Hendrik dan juga Pak Soni.

Saya lagi coba pelajari script yang di kasih pak Roni, dan lagi coba
menelaah penjelasan Pak Kid.

Mohon kiranya dapat di bantu :

1. Script ini maksudnya file output dan file input di folder yang sama ya :

Workbooks.Open fileku & "\" & "Master.xls"

2. Saya lagi coba buat untuk di input dan output ada di folder yang
berbeda. Saya coba script dibawah ini :'

workbooks.Open fileku,W:\"Master.xls" tapi tetap tidak bisa . Mohon kiranya
dapat di bantu scriptnya untuk input dan output di folder yang berbeda

2018-02-19 10:16 GMT+07:00 y.roni35@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Pelajaran yang bagus, bisa menambah referensi,, terimakasih buat semua
>
>

Sun Feb 25, 2018 8:49 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Stephen,Ya pasti ga bisa, mau cari Luna yang diklik Siska.....Yang harus diubah adalah setting direktori fileku nya atau ditulis lengkap dalam tanda petik "Dir\SubDir\namafile.ext"
Salam,HK

Sent from Yahoo Mail on Android

On Mon, Feb 26, 2018 at 11:23, Stephen Saputro stephensaputro@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Terima kasih Banyak Pak Kid, Pak Hendrik dan juga Pak Soni..
Saya lagi coba pelajari script yang di kasih pak Roni, dan lagi coba menelaah penjelasan Pak Kid.
Mohon kiranya dapat di bantu :
1. Script ini maksudnya file output dan file input di folder yang sama ya :
Workbooks.Open fileku & "\" & "Master.xls"

2. Saya lagi coba buat untuk di input dan output ada di folder yang berbeda.. Saya coba script dibawah ini :'

workbooks.Open fileku,W:\"Master.xls" tapi tetap tidak bisa . Mohon kiranya dapat di bantu scriptnya untuk input dan output di folder yang berbeda

2018-02-19 10:16 GMT+07:00 y.roni35@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

 
Pelajaran yang bagus, bisa menambah referensi,, terimakasih buat semua


#yiv5456734646 #yiv5456734646 -- #yiv5456734646ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5456734646 #yiv5456734646ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5456734646 #yiv5456734646ygrp-mkp #yiv5456734646hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5456734646 #yiv5456734646ygrp-mkp #yiv5456734646ads {margin-bottom:10px;}#yiv5456734646 #yiv5456734646ygrp-mkp .yiv5456734646ad {padding:0 0;}#yiv5456734646 #yiv5456734646ygrp-mkp .yiv5456734646ad p {margin:0;}#yiv5456734646 #yiv5456734646ygrp-mkp .yiv5456734646ad a {color:#0000ff;text-decoration:none;}#yiv5456734646 #yiv5456734646ygrp-sponsor #yiv5456734646ygrp-lc {font-family:Arial;}#yiv5456734646 #yiv5456734646ygrp-sponsor #yiv5456734646ygrp-lc #yiv5456734646hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5456734646 #yiv5456734646ygrp-sponsor #yiv5456734646ygrp-lc .yiv5456734646ad {margin-bottom:10px;padding:0 0;}#yiv5456734646 #yiv5456734646actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5456734646 #yiv5456734646activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5456734646 #yiv5456734646activity span {font-weight:700;}#yiv5456734646 #yiv5456734646activity span:first-child {text-transform:uppercase;}#yiv5456734646 #yiv5456734646activity span a {color:#5085b6;text-decoration:none;}#yiv5456734646 #yiv5456734646activity span span {color:#ff7900;}#yiv5456734646 #yiv5456734646activity span .yiv5456734646underline {text-decoration:underline;}#yiv5456734646 .yiv5456734646attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5456734646 .yiv5456734646attach div a {text-decoration:none;}#yiv5456734646 .yiv5456734646attach img {border:none;padding-right:5px;}#yiv5456734646 .yiv5456734646attach label {display:block;margin-bottom:5px;}#yiv5456734646 .yiv5456734646attach label a {text-decoration:none;}#yiv5456734646 blockquote {margin:0 0 0 4px;}#yiv5456734646 .yiv5456734646bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5456734646 .yiv5456734646bold a {text-decoration:none;}#yiv5456734646 dd.yiv5456734646last p a {font-family:Verdana;font-weight:700;}#yiv5456734646 dd.yiv5456734646last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5456734646 dd.yiv5456734646last p span.yiv5456734646yshortcuts {margin-right:0;}#yiv5456734646 div.yiv5456734646attach-table div div a {text-decoration:none;}#yiv5456734646 div.yiv5456734646attach-table {width:400px;}#yiv5456734646 div.yiv5456734646file-title a, #yiv5456734646 div.yiv5456734646file-title a:active, #yiv5456734646 div.yiv5456734646file-title a:hover, #yiv5456734646 div.yiv5456734646file-title a:visited {text-decoration:none;}#yiv5456734646 div.yiv5456734646photo-title a, #yiv5456734646 div.yiv5456734646photo-title a:active, #yiv5456734646 div.yiv5456734646photo-title a:hover, #yiv5456734646 div.yiv5456734646photo-title a:visited {text-decoration:none;}#yiv5456734646 div#yiv5456734646ygrp-mlmsg #yiv5456734646ygrp-msg p a span.yiv5456734646yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5456734646 .yiv5456734646green {color:#628c2a;}#yiv5456734646 .yiv5456734646MsoNormal {margin:0 0 0 0;}#yiv5456734646 o {font-size:0;}#yiv5456734646 #yiv5456734646photos div {float:left;width:72px;}#yiv5456734646 #yiv5456734646photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5456734646 #yiv5456734646photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5456734646 #yiv5456734646reco-category {font-size:77%;}#yiv5456734646 #yiv5456734646reco-desc {font-size:77%;}#yiv5456734646 .yiv5456734646replbq {margin:4px;}#yiv5456734646 #yiv5456734646ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5456734646 #yiv5456734646ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5456734646 #yiv5456734646ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5456734646 #yiv5456734646ygrp-mlmsg select, #yiv5456734646 input, #yiv5456734646 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5456734646 #yiv5456734646ygrp-mlmsg pre, #yiv5456734646 code {font:115% monospace;}#yiv5456734646 #yiv5456734646ygrp-mlmsg * {line-height:1.22em;}#yiv5456734646 #yiv5456734646ygrp-mlmsg #yiv5456734646logo {padding-bottom:10px;}#yiv5456734646 #yiv5456734646ygrp-msg p a {font-family:Verdana;}#yiv5456734646 #yiv5456734646ygrp-msg p#yiv5456734646attach-count span {color:#1E66AE;font-weight:700;}#yiv5456734646 #yiv5456734646ygrp-reco #yiv5456734646reco-head {color:#ff7900;font-weight:700;}#yiv5456734646 #yiv5456734646ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5456734646 #yiv5456734646ygrp-sponsor #yiv5456734646ov li a {font-size:130%;text-decoration:none;}#yiv5456734646 #yiv5456734646ygrp-sponsor #yiv5456734646ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5456734646 #yiv5456734646ygrp-sponsor #yiv5456734646ov ul {margin:0;padding:0 0 0 8px;}#yiv5456734646 #yiv5456734646ygrp-text {font-family:Georgia;}#yiv5456734646 #yiv5456734646ygrp-text p {margin:0 0 1em 0;}#yiv5456734646 #yiv5456734646ygrp-text tt {font-size:120%;}#yiv5456734646 #yiv5456734646ygrp-vital ul li:last-child {border-right:none !important;}#yiv5456734646

Mon Feb 26, 2018 5:02 am (PST) . Posted by:

"Stephen Saputro"

Dear Pak Hendrik dan semuanya,

Mohon di bantu lagi, apakah seperti ini :

Workbooks.Open fileku, "D:\SS\Master Test2.xls:" sudah di coba tapi debug.
mohon bantuannya.

Script lengkapnya masih seperti script yang di kasih pak Roni :

Dim rc As Long
Dim fileku As String
Dim wb As Workbook

Application.ScreenUpdating = False
fileku = ActiveWorkbook.Path
rc = ActiveSheet.UsedRange.Rows.Count

Workbooks.Open fileku, "D:\SS\Master Test2.xls:"
Set wb = ActiveWorkbook
rc = ActiveSheet.UsedRange.Rows.Count
With Sheets(1).Range("A1")
...Offset(rc, 0).Value = Me.TextBox1.Value
...Offset(rc, 1).Value = Me.TextBox2.Value
...Offset(rc, 2).Value = Me.TextBox3.Value
...Offset(rc, 3).Value = Left(Thisheet.Name, Len(Thissheet.Name) - 4) 'nama
dari workbook yang entry
End With

wb.Save
wb.Close 'tutup workbook master
Application.ScreenUpdating = True
Unload Me
Entry_Form.Show
End Sub

On Mon, Feb 26, 2018 at 11:48 AM, hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Hai Stephen,
> Ya pasti ga bisa, mau cari Luna yang diklik Siska....
> Yang harus diubah adalah setting direktori fileku nya atau ditulis lengkap
> dalam tanda petik "Dir\SubDir\namafile.ext"
>
> Salam,
> HK
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Mon, Feb 26, 2018 at 11:23, Stephen Saputro stephensaputro@gmail.com
> [belajar-excel]
> <belajar-excel@yahoogroups.com> wrote:
>
>
> Terima kasih Banyak Pak Kid, Pak Hendrik dan juga Pak Soni..
>
> Saya lagi coba pelajari script yang di kasih pak Roni, dan lagi coba
> menelaah penjelasan Pak Kid.
>
> Mohon kiranya dapat di bantu :
>
> 1. Script ini maksudnya file output dan file input di folder yang sama ya :
>
> Workbooks.Open fileku & "\" & "Master.xls"
>
> 2. Saya lagi coba buat untuk di input dan output ada di folder yang
> berbeda. Saya coba script dibawah ini :'
>
>
> workbooks.Open fileku,W:\"Master.xls" tapi tetap tidak bisa . Mohon
> kiranya dapat di bantu scriptnya untuk input dan output di folder yang
> berbeda
>
>
>
>
> 2018-02-19 10:16 GMT+07:00 y.roni35@yahoo.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>
>
> Pelajaran yang bagus, bisa menambah referensi,, terimakasih buat semua
>
>
>
>

Mon Feb 26, 2018 7:12 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Stephen,Jika diassumsikan ActiveWorkbook.Path = "D:\SS" makaWorkbooks.Open fileku, "D:\SS\Master Test2.xls:" diganti dengan :Workbooks.Open fileku & "\" & "Master Test2.xls"Selamat mencoba.
Salam,
HK

Sent from Yahoo Mail on Android

On Mon, Feb 26, 2018 at 20:07, Stephen Saputro stephensaputro@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Dear Pak Hendrik dan semuanya,  Mohon di bantu lagi, apakah seperti ini :
Workbooks.Open fileku, "D:\SS\Master Test2.xls:" sudah di coba tapi debug. mohon bantuannya.

Script lengkapnya masih seperti script yang di kasih pak Roni :
Dim rc As LongDim fileku As StringDim wb As Workbook
Application.ScreenUpdating = Falsefileku = ActiveWorkbook.Pathrc = ActiveSheet.UsedRange.Rows.Count
Workbooks.Open fileku, "D:\SS\Master Test2.xls:"Set wb = ActiveWorkbookrc = ActiveSheet.UsedRange.Rows.CountWith Sheets(1).Range("A1").Offset(rc, 0).Value = Me.TextBox1.Value.Offset(rc, 1).Value = Me.TextBox2.Value.Offset(rc, 2).Value = Me.TextBox3.Value.Offset(rc, 3).Value = Left(Thisheet.Name, Len(Thissheet.Name) - 4) 'nama dari workbook yang entryEnd With
wb.Savewb.Close 'tutup workbook masterApplication.ScreenUpdating = TrueUnload MeEntry_Form.ShowEnd Sub
On Mon, Feb 26, 2018 at 11:48 AM, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 
Hai Stephen,
Ya pasti ga bisa, mau cari Luna yang diklik Siska.....Yang harus diubah adalah setting direktori fileku nya atau ditulis lengkap dalam tanda petik "Dir\SubDir\namafile.ext"
Salam,HK

Sent from Yahoo Mail on Android

On Mon, Feb 26, 2018 at 11:23, Stephen Saputro stephensaputro@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com > wrote:  

Terima kasih Banyak Pak Kid, Pak Hendrik dan juga Pak Soni..
Saya lagi coba pelajari script yang di kasih pak Roni, dan lagi coba menelaah penjelasan Pak Kid.
Mohon kiranya dapat di bantu :
1. Script ini maksudnya file output dan file input di folder yang sama ya :
Workbooks.Open fileku & "\" & "Master.xls"

2. Saya lagi coba buat untuk di input dan output ada di folder yang berbeda.. Saya coba script dibawah ini :'

workbooks.Open fileku,W:\"Master.xls" tapi tetap tidak bisa . Mohon kiranya dapat di bantu scriptnya untuk input dan output di folder yang berbeda

2018-02-19 10:16 GMT+07:00 y.roni35@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com >:

 
Pelajaran yang bagus, bisa menambah referensi,, terimakasih buat semua


#yiv8575045297 #yiv8575045297 -- #yiv8575045297ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8575045297 #yiv8575045297ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8575045297 #yiv8575045297ygrp-mkp #yiv8575045297hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8575045297 #yiv8575045297ygrp-mkp #yiv8575045297ads {margin-bottom:10px;}#yiv8575045297 #yiv8575045297ygrp-mkp .yiv8575045297ad {padding:0 0;}#yiv8575045297 #yiv8575045297ygrp-mkp .yiv8575045297ad p {margin:0;}#yiv8575045297 #yiv8575045297ygrp-mkp .yiv8575045297ad a {color:#0000ff;text-decoration:none;}#yiv8575045297 #yiv8575045297ygrp-sponsor #yiv8575045297ygrp-lc {font-family:Arial;}#yiv8575045297 #yiv8575045297ygrp-sponsor #yiv8575045297ygrp-lc #yiv8575045297hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8575045297 #yiv8575045297ygrp-sponsor #yiv8575045297ygrp-lc .yiv8575045297ad {margin-bottom:10px;padding:0 0;}#yiv8575045297 #yiv8575045297actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8575045297 #yiv8575045297activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8575045297 #yiv8575045297activity span {font-weight:700;}#yiv8575045297 #yiv8575045297activity span:first-child {text-transform:uppercase;}#yiv8575045297 #yiv8575045297activity span a {color:#5085b6;text-decoration:none;}#yiv8575045297 #yiv8575045297activity span span {color:#ff7900;}#yiv8575045297 #yiv8575045297activity span .yiv8575045297underline {text-decoration:underline;}#yiv8575045297 .yiv8575045297attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8575045297 .yiv8575045297attach div a {text-decoration:none;}#yiv8575045297 .yiv8575045297attach img {border:none;padding-right:5px;}#yiv8575045297 .yiv8575045297attach label {display:block;margin-bottom:5px;}#yiv8575045297 .yiv8575045297attach label a {text-decoration:none;}#yiv8575045297 blockquote {margin:0 0 0 4px;}#yiv8575045297 .yiv8575045297bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8575045297 .yiv8575045297bold a {text-decoration:none;}#yiv8575045297 dd.yiv8575045297last p a {font-family:Verdana;font-weight:700;}#yiv8575045297 dd.yiv8575045297last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8575045297 dd.yiv8575045297last p span.yiv8575045297yshortcuts {margin-right:0;}#yiv8575045297 div.yiv8575045297attach-table div div a {text-decoration:none;}#yiv8575045297 div.yiv8575045297attach-table {width:400px;}#yiv8575045297 div.yiv8575045297file-title a, #yiv8575045297 div.yiv8575045297file-title a:active, #yiv8575045297 div.yiv8575045297file-title a:hover, #yiv8575045297 div.yiv8575045297file-title a:visited {text-decoration:none;}#yiv8575045297 div.yiv8575045297photo-title a, #yiv8575045297 div.yiv8575045297photo-title a:active, #yiv8575045297 div.yiv8575045297photo-title a:hover, #yiv8575045297 div.yiv8575045297photo-title a:visited {text-decoration:none;}#yiv8575045297 div#yiv8575045297ygrp-mlmsg #yiv8575045297ygrp-msg p a span.yiv8575045297yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8575045297 .yiv8575045297green {color:#628c2a;}#yiv8575045297 .yiv8575045297MsoNormal {margin:0 0 0 0;}#yiv8575045297 o {font-size:0;}#yiv8575045297 #yiv8575045297photos div {float:left;width:72px;}#yiv8575045297 #yiv8575045297photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8575045297 #yiv8575045297photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8575045297 #yiv8575045297reco-category {font-size:77%;}#yiv8575045297 #yiv8575045297reco-desc {font-size:77%;}#yiv8575045297 .yiv8575045297replbq {margin:4px;}#yiv8575045297 #yiv8575045297ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8575045297 #yiv8575045297ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8575045297 #yiv8575045297ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8575045297 #yiv8575045297ygrp-mlmsg select, #yiv8575045297 input, #yiv8575045297 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8575045297 #yiv8575045297ygrp-mlmsg pre, #yiv8575045297 code {font:115% monospace;}#yiv8575045297 #yiv8575045297ygrp-mlmsg * {line-height:1.22em;}#yiv8575045297 #yiv8575045297ygrp-mlmsg #yiv8575045297logo {padding-bottom:10px;}#yiv8575045297 #yiv8575045297ygrp-msg p a {font-family:Verdana;}#yiv8575045297 #yiv8575045297ygrp-msg p#yiv8575045297attach-count span {color:#1E66AE;font-weight:700;}#yiv8575045297 #yiv8575045297ygrp-reco #yiv8575045297reco-head {color:#ff7900;font-weight:700;}#yiv8575045297 #yiv8575045297ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8575045297 #yiv8575045297ygrp-sponsor #yiv8575045297ov li a {font-size:130%;text-decoration:none;}#yiv8575045297 #yiv8575045297ygrp-sponsor #yiv8575045297ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8575045297 #yiv8575045297ygrp-sponsor #yiv8575045297ov ul {margin:0;padding:0 0 0 8px;}#yiv8575045297 #yiv8575045297ygrp-text {font-family:Georgia;}#yiv8575045297 #yiv8575045297ygrp-text p {margin:0 0 1em 0;}#yiv8575045297 #yiv8575045297ygrp-text tt {font-size:120%;}#yiv8575045297 #yiv8575045297ygrp-vital ul li:last-child {border-right:none !important;}#yiv8575045297
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Diposting oleh EXCEL FEED LEARNING di 08.11

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)