5 Messages

Digest #4035

Bls: [belajar-excel] pindah data by "Toby kenzo" tobykenzo

Re: pindah data by "dwint ruswanto"

Variable Scope by "Febry Ferian" febryferian

Re: Mohon bantuannya macro vlookup by cheivory_bridge

Re: Alur Data Perhitungan Excel ke Notepad [2 Attachments] by "Susilo -"

Messages

1a

Bls: [belajar-excel] pindah data

Thu Dec 1, 2016 2:39 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Hendro,
Coba buat commandButton baru dan masukan script ini:
Dim a, b As Integer
a = 5
b = 1
Sheet1.Activate
Do While b <= aSheet1.Cells(19 + b, 2).Value = Sheet7.Cells(b, 1).Value
Sheet1.Cells(19 + b, 8).Value = Sheet7.Cells(5 + b, 1).Value
Sheet1.Cells(19 + b, 4).Value = Sheet7.Cells(b, 2).Value
Sheet1.Cells(19 + b, 10).Value = Sheet7.Cells(5 + b, 2).Value
Sheet1.Cells(19 + b, 5).Value = Sheet7.Cells(b, 3).Value
Sheet1.Cells(19 + b, 12).Value = Sheet7.Cells(5 + b, 3).Valueb = b + 1
Loop
Semoga membantu.
TerimaKasih.

Pada Kamis, 1 Desember 2016 16:26, "'Hendro@daya-motor' hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

maaf bp.toby bisa kasih saya contoh nya..soalnya saya sdh mencoba pakai
loop saya belum berhasil..dan sampai sekarang masih blm tau juga harus pakai
loop yg apa?maaf baru belajar.

----- Original Message -----
From: "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: <belajar-excel@yahoogroups.com>
Sent: Thursday, December 01, 2016 3:10 PM
Subject: Bls: [belajar-excel] pindah data

Dear Hendro,
Anda bisa menggunakan "Loop" method
TerimaKasih.

Pada Selasa, 29 November 2016 17:45, "Hendro Arifin
hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:

selamat sore mr.kid dan rekan2..mohon bantuan untuk solusi berikut.saya
bermaksud memindahkan data dari sheet list_ho ke sheet dt_ print dimana
list_ho adalahhasil dari advance filter yang jumlah baris nya akan selalu
berubah tiap kali tonbol print di tekan tetapi jumlah
tidak lebih dari 10 baris dan dengan jumlah kolom tetap yaitu 3 kolom.saya
mempunyai kode macro tetapisaya merasa kode saya tersebut terlalu
panjang.bisakah kode saya tersebut di persingkat?atokah ada kode
lain untuk menggantikan kode macro saya tersebut?mohon petunjukanyaterima
kasih.

salam hendro

#yiv4553733650 #yiv4553733650 -- #yiv4553733650ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4553733650
#yiv4553733650ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4553733650
#yiv4553733650ygrp-mkp #yiv4553733650hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4553733650 #yiv4553733650ygrp-mkp #yiv4553733650ads
{margin-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad
{padding:0 0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad p
{margin:0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad a
{color:#0000ff;text-decoration:none;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc
{font-family:Arial;}#yiv4553733650 #yiv4553733650ygrp-sponsor
#yiv4553733650ygrp-lc #yiv4553733650hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc .yiv4553733650ad
{margin-bottom:10px;padding:0 0;}#yiv4553733650 #yiv4553733650actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4553733650
#yiv4553733650activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4553733650
#yiv4553733650activity span {font-weight:700;}#yiv4553733650
#yiv4553733650activity span:first-child
{text-transform:uppercase;}#yiv4553733650 #yiv4553733650activity span a
{color:#5085b6;text-decoration:none;}#yiv4553733650 #yiv4553733650activity
span span {color:#ff7900;}#yiv4553733650 #yiv4553733650activity span
.yiv4553733650underline {text-decoration:underline;}#yiv4553733650
.yiv4553733650attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4553733650 .yiv4553733650attach div a
{text-decoration:none;}#yiv4553733650 .yiv4553733650attach img
{border:none;padding-right:5px;}#yiv4553733650 .yiv4553733650attach label
{display:block;margin-bottom:5px;}#yiv4553733650 .yiv4553733650attach label
a {text-decoration:none;}#yiv4553733650 blockquote {margin:0 0 0
4px;}#yiv4553733650 .yiv4553733650bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4553733650
.yiv4553733650bold a {text-decoration:none;}#yiv4553733650
dd.yiv4553733650last p a
{font-family:Verdana;font-weight:700;}#yiv4553733650 dd.yiv4553733650last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4553733650
dd.yiv4553733650last p span.yiv4553733650yshortcuts
{margin-right:0;}#yiv4553733650 div.yiv4553733650attach-table div div a
{text-decoration:none;}#yiv4553733650 div.yiv4553733650attach-table
{width:400px;}#yiv4553733650 div.yiv4553733650file-title a, #yiv4553733650
div.yiv4553733650file-title a:active, #yiv4553733650
div.yiv4553733650file-title a:hover, #yiv4553733650
div.yiv4553733650file-title a:visited {text-decoration:none;}#yiv4553733650
div.yiv4553733650photo-title a, #yiv4553733650 div.yiv4553733650photo-title
a:active, #yiv4553733650 div.yiv4553733650photo-title a:hover,
#yiv4553733650 div.yiv4553733650photo-title a:visited
{text-decoration:none;}#yiv4553733650 div#yiv4553733650ygrp-mlmsg
#yiv4553733650ygrp-msg p a span.yiv4553733650yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4553733650
.yiv4553733650green {color:#628c2a;}#yiv4553733650 .yiv4553733650MsoNormal
{margin:0 0 0 0;}#yiv4553733650 o {font-size:0;}#yiv4553733650
#yiv4553733650photos div {float:left;width:72px;}#yiv4553733650
#yiv4553733650photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4553733650
#yiv4553733650photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4553733650
#yiv4553733650reco-category {font-size:77%;}#yiv4553733650
#yiv4553733650reco-desc {font-size:77%;}#yiv4553733650 .yiv4553733650replbq
{margin:4px;}#yiv4553733650 #yiv4553733650ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4553733650 #yiv4553733650ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg table
{font-size:inherit;font:100%;}#yiv4553733650 #yiv4553733650ygrp-mlmsg
select, #yiv4553733650 input, #yiv4553733650 textarea {font:99% Arial,
Helvetica, clean, sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg pre,
#yiv4553733650 code {font:115% monospace;}#yiv4553733650
#yiv4553733650ygrp-mlmsg * {line-height:1.22em;}#yiv4553733650
#yiv4553733650ygrp-mlmsg #yiv4553733650logo
{padding-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-msg p a
{font-family:Verdana;}#yiv4553733650 #yiv4553733650ygrp-msg
p#yiv4553733650attach-count span
{color:#1E66AE;font-weight:700;}#yiv4553733650 #yiv4553733650ygrp-reco
#yiv4553733650reco-head {color:#ff7900;font-weight:700;}#yiv4553733650
#yiv4553733650ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ov li a
{font-size:130%;text-decoration:none;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ov ul {margin:0;padding:0 0 0
8px;}#yiv4553733650 #yiv4553733650ygrp-text
{font-family:Georgia;}#yiv4553733650 #yiv4553733650ygrp-text p {margin:0 0
1em 0;}#yiv4553733650 #yiv4553733650ygrp-text tt
{font-size:120%;}#yiv4553733650 #yiv4553733650ygrp-vital ul li:last-child
{border-right:none !important;}#yiv4553733650

#yiv4177498898 #yiv4177498898 -- #yiv4177498898ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4177498898 #yiv4177498898ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4177498898 #yiv4177498898ygrp-mkp #yiv4177498898hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4177498898 #yiv4177498898ygrp-mkp #yiv4177498898ads {margin-bottom:10px;}#yiv4177498898 #yiv4177498898ygrp-mkp .yiv4177498898ad {padding:0 0;}#yiv4177498898 #yiv4177498898ygrp-mkp .yiv4177498898ad p {margin:0;}#yiv4177498898 #yiv4177498898ygrp-mkp .yiv4177498898ad a {color:#0000ff;text-decoration:none;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ygrp-lc {font-family:Arial;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ygrp-lc #yiv4177498898hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ygrp-lc .yiv4177498898ad {margin-bottom:10px;padding:0 0;}#yiv4177498898 #yiv4177498898actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4177498898 #yiv4177498898activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4177498898 #yiv4177498898activity span {font-weight:700;}#yiv4177498898 #yiv4177498898activity span:first-child {text-transform:uppercase;}#yiv4177498898 #yiv4177498898activity span a {color:#5085b6;text-decoration:none;}#yiv4177498898 #yiv4177498898activity span span {color:#ff7900;}#yiv4177498898 #yiv4177498898activity span .yiv4177498898underline {text-decoration:underline;}#yiv4177498898 .yiv4177498898attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4177498898 .yiv4177498898attach div a {text-decoration:none;}#yiv4177498898 .yiv4177498898attach img {border:none;padding-right:5px;}#yiv4177498898 .yiv4177498898attach label {display:block;margin-bottom:5px;}#yiv4177498898 .yiv4177498898attach label a {text-decoration:none;}#yiv4177498898 blockquote {margin:0 0 0 4px;}#yiv4177498898 .yiv4177498898bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4177498898 .yiv4177498898bold a {text-decoration:none;}#yiv4177498898 dd.yiv4177498898last p a {font-family:Verdana;font-weight:700;}#yiv4177498898 dd.yiv4177498898last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4177498898 dd.yiv4177498898last p span.yiv4177498898yshortcuts {margin-right:0;}#yiv4177498898 div.yiv4177498898attach-table div div a {text-decoration:none;}#yiv4177498898 div.yiv4177498898attach-table {width:400px;}#yiv4177498898 div.yiv4177498898file-title a, #yiv4177498898 div.yiv4177498898file-title a:active, #yiv4177498898 div.yiv4177498898file-title a:hover, #yiv4177498898 div.yiv4177498898file-title a:visited {text-decoration:none;}#yiv4177498898 div.yiv4177498898photo-title a, #yiv4177498898 div.yiv4177498898photo-title a:active, #yiv4177498898 div.yiv4177498898photo-title a:hover, #yiv4177498898 div.yiv4177498898photo-title a:visited {text-decoration:none;}#yiv4177498898 div#yiv4177498898ygrp-mlmsg #yiv4177498898ygrp-msg p a span.yiv4177498898yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4177498898 .yiv4177498898green {color:#628c2a;}#yiv4177498898 .yiv4177498898MsoNormal {margin:0 0 0 0;}#yiv4177498898 o {font-size:0;}#yiv4177498898 #yiv4177498898photos div {float:left;width:72px;}#yiv4177498898 #yiv4177498898photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4177498898 #yiv4177498898photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4177498898 #yiv4177498898reco-category {font-size:77%;}#yiv4177498898 #yiv4177498898reco-desc {font-size:77%;}#yiv4177498898 .yiv4177498898replbq {margin:4px;}#yiv4177498898 #yiv4177498898ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4177498898 #yiv4177498898ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4177498898 #yiv4177498898ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4177498898 #yiv4177498898ygrp-mlmsg select, #yiv4177498898 input, #yiv4177498898 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4177498898 #yiv4177498898ygrp-mlmsg pre, #yiv4177498898 code {font:115% monospace;}#yiv4177498898 #yiv4177498898ygrp-mlmsg * {line-height:1.22em;}#yiv4177498898 #yiv4177498898ygrp-mlmsg #yiv4177498898logo {padding-bottom:10px;}#yiv4177498898 #yiv4177498898ygrp-msg p a {font-family:Verdana;}#yiv4177498898 #yiv4177498898ygrp-msg p#yiv4177498898attach-count span {color:#1E66AE;font-weight:700;}#yiv4177498898 #yiv4177498898ygrp-reco #yiv4177498898reco-head {color:#ff7900;font-weight:700;}#yiv4177498898 #yiv4177498898ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ov li a {font-size:130%;text-decoration:none;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ov ul {margin:0;padding:0 0 0 8px;}#yiv4177498898 #yiv4177498898ygrp-text {font-family:Georgia;}#yiv4177498898 #yiv4177498898ygrp-text p {margin:0 0 1em 0;}#yiv4177498898 #yiv4177498898ygrp-text tt {font-size:120%;}#yiv4177498898 #yiv4177498898ygrp-vital ul li:last-child {border-right:none !important;}#yiv4177498898

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

1b

Re: pindah data

Thu Dec 1, 2016 2:48 am (PST) . Posted by:

"dwint ruswanto"

Dear rekans,

sedikit menambahkan,

Dim a, b As Integer

akan menghasilkan:
variabel a dengan type data Variant
variabel b dengan type data Integer

maaf belum sempat ngintip filenya jadi tidak bisa ikutan solusi.

Wassalam,

-dwint-

2016-12-01 17:32 GMT+07:00 Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:

>
>
> Dear Hendro,
>
> Coba buat commandButton baru dan masukan script ini:
>
> Dim a, b As Integer
> a = 5
> b = 1
>
> Sheet1.Activate
>
> Do While b <= a
> Sheet1.Cells(19 + b, 2).Value = Sheet7.Cells(b, 1).Value
> Sheet1.Cells(19 + b, 8).Value = Sheet7.Cells(5 + b, 1).Value
> Sheet1.Cells(19 + b, 4).Value = Sheet7.Cells(b, 2).Value
> Sheet1.Cells(19 + b, 10).Value = Sheet7.Cells(5 + b, 2).Value
> Sheet1.Cells(19 + b, 5).Value = Sheet7.Cells(b, 3).Value
> Sheet1.Cells(19 + b, 12).Value = Sheet7.Cells(5 + b, 3).Value
> b = b + 1
> Loop
>
> Semoga membantu.
>
> TerimaKasih.
>
>
> Pada Kamis, 1 Desember 2016 16:26, "'Hendro@daya-motor'
> hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> menulis:
>
>
>
> maaf bp.toby bisa kasih saya contoh nya..soalnya saya sdh mencoba pakai
> loop saya belum berhasil..dan sampai sekarang masih blm tau juga harus
> pakai
> loop yg apa?maaf baru belajar.
>
> ----- Original Message -----
> From: "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]"
> <belajar-excel@yahoogroups.com>
> To: <belajar-excel@yahoogroups.com>
> Sent: Thursday, December 01, 2016 3:10 PM
> Subject: Bls: [belajar-excel] pindah data
>
> Dear Hendro,
> Anda bisa menggunakan "Loop" method
> TerimaKasih.
>
> Pada Selasa, 29 November 2016 17:45, "Hendro Arifin
> hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> menulis:
>
> selamat sore mr.kid dan rekan2..mohon bantuan untuk solusi berikut.saya
> bermaksud memindahkan data dari sheet list_ho ke sheet dt_ print dimana
> list_ho adalahhasil dari advance filter yang jumlah baris nya akan selalu
> berubah tiap kali tonbol print di tekan tetapi jumlah
> tidak lebih dari 10 baris dan dengan jumlah kolom tetap yaitu 3 kolom.saya
> mempunyai kode macro tetapisaya merasa kode saya tersebut terlalu
> panjang.bisakah kode saya tersebut di persingkat?atokah ada kode
> lain untuk menggantikan kode macro saya tersebut?mohon petunjukanyaterima
> kasih.
>
> salam hendro
>
> #yiv4553733650 #yiv4553733650 -- #yiv4553733650ygrp-mkp {border:1px
> solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
> 10px;}#yiv4553733650
> #yiv4553733650ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4553733650
> #yiv4553733650ygrp-mkp #yiv4553733650hd
> {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}#yiv4553733650 #yiv4553733650ygrp-mkp #yiv4553733650ads
> {margin-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-mkp
> .yiv4553733650ad
> {padding:0 0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad p
> {margin:0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad a
> {color:#0000ff;text-decoration:none;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc
> {font-family:Arial;}#yiv4553733650 #yiv4553733650ygrp-sponsor
> #yiv4553733650ygrp-lc #yiv4553733650hd {margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc .yiv4553733650ad
> {margin-bottom:10px;padding:0 0;}#yiv4553733650 #yiv4553733650actions
> {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4553733650
> #yiv4553733650activity
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4553733650
>
> #yiv4553733650activity span {font-weight:700;}#yiv4553733650
> #yiv4553733650activity span:first-child
> {text-transform:uppercase;}#yiv4553733650 #yiv4553733650activity span a
> {color:#5085b6;text-decoration:none;}#yiv4553733650
> #yiv4553733650activity
> span span {color:#ff7900;}#yiv4553733650 #yiv4553733650activity span
> .yiv4553733650underline {text-decoration:underline;}#yiv4553733650
> .yiv4553733650attach
> {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}#yiv4553733650 .yiv4553733650attach div a
> {text-decoration:none;}#yiv4553733650 .yiv4553733650attach img
> {border:none;padding-right:5px;}#yiv4553733650 .yiv4553733650attach label
> {display:block;margin-bottom:5px;}#yiv4553733650 .yiv4553733650attach
> label
> a {text-decoration:none;}#yiv4553733650 blockquote {margin:0 0 0
> 4px;}#yiv4553733650 .yiv4553733650bold
> {font-family:Arial;font-size:13px;font-weight:700;}#yiv4553733650
> .yiv4553733650bold a {text-decoration:none;}#yiv4553733650
> dd.yiv4553733650last p a
> {font-family:Verdana;font-weight:700;}#yiv4553733650 dd.yiv4553733650last
> p
> span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4553733650
>
> dd.yiv4553733650last p span.yiv4553733650yshortcuts
> {margin-right:0;}#yiv4553733650 div.yiv4553733650attach-table div div a
> {text-decoration:none;}#yiv4553733650 div.yiv4553733650attach-table
> {width:400px;}#yiv4553733650 div.yiv4553733650file-title a, #yiv4553733650
> div.yiv4553733650file-title a:active, #yiv4553733650
> div.yiv4553733650file-title a:hover, #yiv4553733650
> div.yiv4553733650file-title a:visited {text-decoration:none;}#yiv4553733650
>
> div.yiv4553733650photo-title a, #yiv4553733650
> div.yiv4553733650photo-title
> a:active, #yiv4553733650 div.yiv4553733650photo-title a:hover,
> #yiv4553733650 div.yiv4553733650photo-title a:visited
> {text-decoration:none;}#yiv4553733650 div#yiv4553733650ygrp-mlmsg
> #yiv4553733650ygrp-msg p a span.yiv4553733650yshortcuts
> {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4553733650
> .yiv4553733650green {color:#628c2a;}#yiv4553733650 .yiv4553733650MsoNormal
> {margin:0 0 0 0;}#yiv4553733650 o {font-size:0;}#yiv4553733650
> #yiv4553733650photos div {float:left;width:72px;}#yiv4553733650
> #yiv4553733650photos div div {border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}#yiv4553733650
> #yiv4553733650photos div label
> {color:#666666;font-size:10px;overflow:hidden;text-align:
> center;white-space:nowrap;width:64px;}#yiv4553733650
> #yiv4553733650reco-category {font-size:77%;}#yiv4553733650
> #yiv4553733650reco-desc {font-size:77%;}#yiv4553733650
> .yiv4553733650replbq
> {margin:4px;}#yiv4553733650 #yiv4553733650ygrp-actbar div a:first-child
> {margin-right:2px;padding-right:5px;}#yiv4553733650
> #yiv4553733650ygrp-mlmsg
> {font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg table
> {font-size:inherit;font:100%;}#yiv4553733650 #yiv4553733650ygrp-mlmsg
> select, #yiv4553733650 input, #yiv4553733650 textarea {font:99% Arial,
> Helvetica, clean, sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg pre,
> #yiv4553733650 code {font:115% monospace;}#yiv4553733650
> #yiv4553733650ygrp-mlmsg * {line-height:1.22em;}#yiv4553733650
> #yiv4553733650ygrp-mlmsg #yiv4553733650logo
> {padding-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-msg p a
> {font-family:Verdana;}#yiv4553733650 #yiv4553733650ygrp-msg
> p#yiv4553733650attach-count span
> {color:#1E66AE;font-weight:700;}#yiv4553733650 #yiv4553733650ygrp-reco
> #yiv4553733650reco-head {color:#ff7900;font-weight:700;}#yiv4553733650
> #yiv4553733650ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ov li a
> {font-size:130%;text-decoration:none;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ov li
> {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ov ul {margin:0;padding:0 0 0
> 8px;}#yiv4553733650 #yiv4553733650ygrp-text
> {font-family:Georgia;}#yiv4553733650 #yiv4553733650ygrp-text p {margin:0
> 0
> 1em 0;}#yiv4553733650 #yiv4553733650ygrp-text tt
> {font-size:120%;}#yiv4553733650 #yiv4553733650ygrp-vital ul li:last-child
> {border-right:none !important;}#yiv4553733650
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2 Variable Scope

Thu Dec 1, 2016 3:52 am (PST) . Posted by:

"Febry Ferian" febryferian

Selamat sore rekan dan admin belajar excel,
Saya mengalami kesulitan dalam menemukan jawaban atas error dalam percobaan variable scope yg saya coba latih. Kebetulan saya dalam tahap mempelajari macro dari tahap dasar, namun mentok di tahap ini karena apa yg diinstruksikan di buku tidak berhasil ketika saya lakukan.
Saya lampirkan contoh macro yg saya buat.
Saya sedang mencoba untuk input value pada sheet satu, secara berurutan utk subrutin InputData dan TambahDataBuku pada module vbBuku. Tadinya subrutin tsb terletak di module vbSeleksiSel, namun muncul error, "Only comment may appear at end sub, etc." Ketika dipindahkan ke module vbBuku, data yg saya input malah tidak berhasil masuk sesuai yg diharapkan.
Mohon bantuannya. Terima kasih.

Sent from Yahoo Mail on Android

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

3a

Re: Mohon bantuannya macro vlookup

Thu Dec 1, 2016 4:02 am (PST) . Posted by:

cheivory_bridge

Yth. Mr. Kid

Mohon pencerahannya atas vba merger file tersebut.
Saya coba terapkan pada beberapa file yang berisi banyak sheet, belum berhasil.
kondisinya :
- saya punya 30an file workbook dengan 20 sheet tiap workbook (nama tiap sheetnya SAMA antar workbook).
- saya ingin menggabungkan data yang ada pada sheet "Nilai per DM" pada setiap workbook tersebut ke dalam workbaru baru.
- saya coba dengan vba merge file punya Mr. Kid belum berhasil. coba saya cari di kode vba yang menunjukkan rujukan untuk nama sheet sumber ("Nilai per DM") belum ketemu - kalau di file Mr. Kid , nama sheet sumber tiap workbook kan "Sales" ..

mohon kiranya diberi tahu, di bagian mana dari kode vba merge file tersebut yang mesti disesuaikan ..

terima kasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

4a

Re: Alur Data Perhitungan Excel ke Notepad [2 Attachments]

Thu Dec 1, 2016 6:49 pm (PST) . Posted by:

"Susilo -"

Dear Zerlinda

Saya masih mencoba-coba dengan apa yang dimaksud oleh attachment

Untuk perpindahan data dari notepad ke excel (dan sebaliknya) saya
menggunakan copy paste
Rumus yang saya gunakan hanya mengikuti bentuk hasilnya saja

Sebenernya rumusnya bisa saja salah. Saya hanya ingin ada komen:
- maksud saya tidak begitu
- seharusnya kan kalau yang ini begini jadinya begini
- kalau datanya begini harusnya hasilnya begitu

dsb dsb semakin banyak persyaratan akan semakin mudah identifikasi soal

Terima kasih
Susilo

Pada 1 Desember 2016 13.29, Zerlinda Seismica seismica@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

>
>
> Assalamualaikum wrwb
>
> Rasanya ilmu excel ini akan senantiasa haus untuk dipelajari...
> problem ini tergolong sangat baru buat saya untuk melakukan perhitungan di
> excel tapi data berada di file txt
> berikut saya kirimkan data dengan kronologisnya.
> Terima kasih untuk berkenan mebaca dan bantuannya
>
> Wassalam
> Seismica
>
> --- Mods ---
> File lampiran yang melebihi 250KB dilepas dari email. Silakan melampirkan
> ulang file berukuran maksimal 250KB dengan cara me-reply email ini.
> ------------
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
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
---------------------------------------------------------------------

Visit Your Group

New Members 3

• Privacy • Unsubscribe • Terms of Use

EXCEL FEED

Jumat, 02 Desember 2016

[belajar-excel] Digest Number 4035