[belajar-excel] Mengcopy data dari file berbeda menggunakan vba

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Mengcopy data dari file berbeda menggunakan vba

Heru Adi
Assalamu'alaikum.
Mohon bantuannya teman2 semua, bagaimana cara mengcopy data dari file excel yg berbeda menggunakan code macro. Sebelumnya saya ucapkan terimakasih banyak :)
Wassalamu'alaikum.
Best Regards,Heru Adi S
Dikirim dari Yahoo Mail di Android
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mengcopy data dari file berbeda menggunakan vba

hendrik karnadi
Hai Heru,
Coba lakukan rekaman macro.
Langkah2 nya kira2 begini:- Buka file Tujuan- Buka Menu Macro Recording- Buka file sumber- Copy range dari file Sumber.- Kembali ke file Tujuan, klik range tujuan- Klik kanan mouse, pilih paste- Kembali ke file Sumber- Tutup file Sumber- Stop Macro Recording.
Coba lihat hasil rekaman macro dengan menekan tombol Alt+F11 secara bersamaan.
Salam,HK

Sent from Yahoo Mail on Android
 
  On Fri, Feb 7, 2020 at 10:12, Heru Adi [hidden email] [belajar-excel]<[hidden email]> wrote:      
Assalamu'alaikum.

Mohon bantuannya teman2 semua, bagaimana cara mengcopy data dari file excel yg berbeda menggunakan code macro. Sebelumnya saya ucapkan terimakasih banyak :)
Wassalamu'alaikum.
Best Regards,Heru Adi S
Dikirim dari Yahoo Mail di Android  #yiv6707300043 #yiv6707300043 -- #yiv6707300043ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6707300043 #yiv6707300043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043ads {margin-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad {padding:0 0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad p {margin:0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad a {color:#0000ff;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc {font-family:Arial;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc #yiv6707300043hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc .yiv6707300043ad {margin-bottom:10px;padding:0 0;}#yiv6707300043 #yiv6707300043actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6707300043 #yiv6707300043activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6707300043 #yiv6707300043activity span {font-weight:700;}#yiv6707300043 #yiv6707300043activity span:first-child {text-transform:uppercase;}#yiv6707300043 #yiv6707300043activity span a {color:#5085b6;text-decoration:none;}#yiv6707300043 #yiv6707300043activity span span {color:#ff7900;}#yiv6707300043 #yiv6707300043activity span .yiv6707300043underline {text-decoration:underline;}#yiv6707300043 .yiv6707300043attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6707300043 .yiv6707300043attach div a {text-decoration:none;}#yiv6707300043 .yiv6707300043attach img {border:none;padding-right:5px;}#yiv6707300043 .yiv6707300043attach label {display:block;margin-bottom:5px;}#yiv6707300043 .yiv6707300043attach label a {text-decoration:none;}#yiv6707300043 blockquote {margin:0 0 0 4px;}#yiv6707300043 .yiv6707300043bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6707300043 .yiv6707300043bold a {text-decoration:none;}#yiv6707300043 dd.yiv6707300043last p a {font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span.yiv6707300043yshortcuts {margin-right:0;}#yiv6707300043 div.yiv6707300043attach-table div div a {text-decoration:none;}#yiv6707300043 div.yiv6707300043attach-table {width:400px;}#yiv6707300043 div.yiv6707300043file-title a, #yiv6707300043 div.yiv6707300043file-title a:active, #yiv6707300043 div.yiv6707300043file-title a:hover, #yiv6707300043 div.yiv6707300043file-title a:visited {text-decoration:none;}#yiv6707300043 div..yiv6707300043photo-title a, #yiv6707300043 div.yiv6707300043photo-title a:active, #yiv6707300043 div.yiv6707300043photo-title a:hover, #yiv6707300043 div.yiv6707300043photo-title a:visited {text-decoration:none;}#yiv6707300043 div#yiv6707300043ygrp-mlmsg #yiv6707300043ygrp-msg p a span.yiv6707300043yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6707300043 .yiv6707300043green {color:#628c2a;}#yiv6707300043 .yiv6707300043MsoNormal {margin:0 0 0 0;}#yiv6707300043 o {font-size:0;}#yiv6707300043 #yiv6707300043photos div {float:left;width:72px;}#yiv6707300043 #yiv6707300043photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6707300043 #yiv6707300043photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6707300043 #yiv6707300043reco-category {font-size:77%;}#yiv6707300043 #yiv6707300043reco-desc {font-size:77%;}#yiv6707300043 .yiv6707300043replbq {margin:4px;}#yiv6707300043 #yiv6707300043ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6707300043 #yiv6707300043ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6707300043 #yiv6707300043ygrp-mlmsg select, #yiv6707300043 input, #yiv6707300043 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg pre, #yiv6707300043 code {font:115% monospace;}#yiv6707300043 #yiv6707300043ygrp-mlmsg * {line-height:1.22em;}#yiv6707300043 #yiv6707300043ygrp-mlmsg #yiv6707300043logo {padding-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-msg p a {font-family:Verdana;}#yiv6707300043 #yiv6707300043ygrp-msg p#yiv6707300043attach-count span {color:#1E66AE;font-weight:700;}#yiv6707300043 #yiv6707300043ygrp-reco #yiv6707300043reco-head {color:#ff7900;font-weight:700;}#yiv6707300043 #yiv6707300043ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov li a {font-size:130%;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov ul {margin:0;padding:0 0 0 8px;}#yiv6707300043 #yiv6707300043ygrp-text {font-family:Georgia;}#yiv6707300043 #yiv6707300043ygrp-text p {margin:0 0 1em 0;}#yiv6707300043 #yiv6707300043ygrp-text tt {font-size:120%;}#yiv6707300043 #yiv6707300043ygrp-vital ul li:last-child {border-right:none !important;}#yiv6707300043  
 
 
  On Fri, Feb 7, 2020 at 10:12, Heru Adi [hidden email] [belajar-excel]<[hidden email]> wrote:      
Assalamu'alaikum.

Mohon bantuannya teman2 semua, bagaimana cara mengcopy data dari file excel yg berbeda menggunakan code macro. Sebelumnya saya ucapkan terimakasih banyak :)
Wassalamu'alaikum.
Best Regards,Heru Adi S
Dikirim dari Yahoo Mail di Android  #yiv6707300043 #yiv6707300043 -- #yiv6707300043ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6707300043 #yiv6707300043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043ads {margin-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad {padding:0 0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad p {margin:0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad a {color:#0000ff;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc {font-family:Arial;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc #yiv6707300043hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc .yiv6707300043ad {margin-bottom:10px;padding:0 0;}#yiv6707300043 #yiv6707300043actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6707300043 #yiv6707300043activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6707300043 #yiv6707300043activity span {font-weight:700;}#yiv6707300043 #yiv6707300043activity span:first-child {text-transform:uppercase;}#yiv6707300043 #yiv6707300043activity span a {color:#5085b6;text-decoration:none;}#yiv6707300043 #yiv6707300043activity span span {color:#ff7900;}#yiv6707300043 #yiv6707300043activity span .yiv6707300043underline {text-decoration:underline;}#yiv6707300043 .yiv6707300043attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6707300043 .yiv6707300043attach div a {text-decoration:none;}#yiv6707300043 .yiv6707300043attach img {border:none;padding-right:5px;}#yiv6707300043 .yiv6707300043attach label {display:block;margin-bottom:5px;}#yiv6707300043 .yiv6707300043attach label a {text-decoration:none;}#yiv6707300043 blockquote {margin:0 0 0 4px;}#yiv6707300043 .yiv6707300043bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6707300043 .yiv6707300043bold a {text-decoration:none;}#yiv6707300043 dd.yiv6707300043last p a {font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span.yiv6707300043yshortcuts {margin-right:0;}#yiv6707300043 div.yiv6707300043attach-table div div a {text-decoration:none;}#yiv6707300043 div.yiv6707300043attach-table {width:400px;}#yiv6707300043 div.yiv6707300043file-title a, #yiv6707300043 div.yiv6707300043file-title a:active, #yiv6707300043 div.yiv6707300043file-title a:hover, #yiv6707300043 div.yiv6707300043file-title a:visited {text-decoration:none;}#yiv6707300043 div..yiv6707300043photo-title a, #yiv6707300043 div.yiv6707300043photo-title a:active, #yiv6707300043 div.yiv6707300043photo-title a:hover, #yiv6707300043 div.yiv6707300043photo-title a:visited {text-decoration:none;}#yiv6707300043 div#yiv6707300043ygrp-mlmsg #yiv6707300043ygrp-msg p a span.yiv6707300043yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6707300043 .yiv6707300043green {color:#628c2a;}#yiv6707300043 .yiv6707300043MsoNormal {margin:0 0 0 0;}#yiv6707300043 o {font-size:0;}#yiv6707300043 #yiv6707300043photos div {float:left;width:72px;}#yiv6707300043 #yiv6707300043photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6707300043 #yiv6707300043photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6707300043 #yiv6707300043reco-category {font-size:77%;}#yiv6707300043 #yiv6707300043reco-desc {font-size:77%;}#yiv6707300043 .yiv6707300043replbq {margin:4px;}#yiv6707300043 #yiv6707300043ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6707300043 #yiv6707300043ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6707300043 #yiv6707300043ygrp-mlmsg select, #yiv6707300043 input, #yiv6707300043 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg pre, #yiv6707300043 code {font:115% monospace;}#yiv6707300043 #yiv6707300043ygrp-mlmsg * {line-height:1.22em;}#yiv6707300043 #yiv6707300043ygrp-mlmsg #yiv6707300043logo {padding-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-msg p a {font-family:Verdana;}#yiv6707300043 #yiv6707300043ygrp-msg p#yiv6707300043attach-count span {color:#1E66AE;font-weight:700;}#yiv6707300043 #yiv6707300043ygrp-reco #yiv6707300043reco-head {color:#ff7900;font-weight:700;}#yiv6707300043 #yiv6707300043ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov li a {font-size:130%;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov ul {margin:0;padding:0 0 0 8px;}#yiv6707300043 #yiv6707300043ygrp-text {font-family:Georgia;}#yiv6707300043 #yiv6707300043ygrp-text p {margin:0 0 1em 0;}#yiv6707300043 #yiv6707300043ygrp-text tt {font-size:120%;}#yiv6707300043 #yiv6707300043ygrp-vital ul li:last-child {border-right:none !important;}#yiv6707300043  
 
 
  On Fri, Feb 7, 2020 at 10:12, Heru Adi [hidden email] [belajar-excel]<[hidden email]> wrote:      
Assalamu'alaikum.

Mohon bantuannya teman2 semua, bagaimana cara mengcopy data dari file excel yg berbeda menggunakan code macro. Sebelumnya saya ucapkan terimakasih banyak :)
Wassalamu'alaikum.
Best Regards,Heru Adi S
Dikirim dari Yahoo Mail di Android  #yiv6707300043 #yiv6707300043 -- #yiv6707300043ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6707300043 #yiv6707300043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043ads {margin-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad {padding:0 0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad p {margin:0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad a {color:#0000ff;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc {font-family:Arial;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc #yiv6707300043hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc .yiv6707300043ad {margin-bottom:10px;padding:0 0;}#yiv6707300043 #yiv6707300043actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6707300043 #yiv6707300043activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6707300043 #yiv6707300043activity span {font-weight:700;}#yiv6707300043 #yiv6707300043activity span:first-child {text-transform:uppercase;}#yiv6707300043 #yiv6707300043activity span a {color:#5085b6;text-decoration:none;}#yiv6707300043 #yiv6707300043activity span span {color:#ff7900;}#yiv6707300043 #yiv6707300043activity span .yiv6707300043underline {text-decoration:underline;}#yiv6707300043 .yiv6707300043attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6707300043 .yiv6707300043attach div a {text-decoration:none;}#yiv6707300043 .yiv6707300043attach img {border:none;padding-right:5px;}#yiv6707300043 .yiv6707300043attach label {display:block;margin-bottom:5px;}#yiv6707300043 .yiv6707300043attach label a {text-decoration:none;}#yiv6707300043 blockquote {margin:0 0 0 4px;}#yiv6707300043 .yiv6707300043bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6707300043 .yiv6707300043bold a {text-decoration:none;}#yiv6707300043 dd.yiv6707300043last p a {font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span.yiv6707300043yshortcuts {margin-right:0;}#yiv6707300043 div.yiv6707300043attach-table div div a {text-decoration:none;}#yiv6707300043 div.yiv6707300043attach-table {width:400px;}#yiv6707300043 div.yiv6707300043file-title a, #yiv6707300043 div.yiv6707300043file-title a:active, #yiv6707300043 div.yiv6707300043file-title a:hover, #yiv6707300043 div.yiv6707300043file-title a:visited {text-decoration:none;}#yiv6707300043 div..yiv6707300043photo-title a, #yiv6707300043 div.yiv6707300043photo-title a:active, #yiv6707300043 div.yiv6707300043photo-title a:hover, #yiv6707300043 div.yiv6707300043photo-title a:visited {text-decoration:none;}#yiv6707300043 div#yiv6707300043ygrp-mlmsg #yiv6707300043ygrp-msg p a span.yiv6707300043yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6707300043 .yiv6707300043green {color:#628c2a;}#yiv6707300043 .yiv6707300043MsoNormal {margin:0 0 0 0;}#yiv6707300043 o {font-size:0;}#yiv6707300043 #yiv6707300043photos div {float:left;width:72px;}#yiv6707300043 #yiv6707300043photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6707300043 #yiv6707300043photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6707300043 #yiv6707300043reco-category {font-size:77%;}#yiv6707300043 #yiv6707300043reco-desc {font-size:77%;}#yiv6707300043 .yiv6707300043replbq {margin:4px;}#yiv6707300043 #yiv6707300043ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6707300043 #yiv6707300043ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6707300043 #yiv6707300043ygrp-mlmsg select, #yiv6707300043 input, #yiv6707300043 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg pre, #yiv6707300043 code {font:115% monospace;}#yiv6707300043 #yiv6707300043ygrp-mlmsg * {line-height:1.22em;}#yiv6707300043 #yiv6707300043ygrp-mlmsg #yiv6707300043logo {padding-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-msg p a {font-family:Verdana;}#yiv6707300043 #yiv6707300043ygrp-msg p#yiv6707300043attach-count span {color:#1E66AE;font-weight:700;}#yiv6707300043 #yiv6707300043ygrp-reco #yiv6707300043reco-head {color:#ff7900;font-weight:700;}#yiv6707300043 #yiv6707300043ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov li a {font-size:130%;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ov ul {margin:0;padding:0 0 0 8px;}#yiv6707300043 #yiv6707300043ygrp-text {font-family:Georgia;}#yiv6707300043 #yiv6707300043ygrp-text p {margin:0 0 1em 0;}#yiv6707300043 #yiv6707300043ygrp-text tt {font-size:120%;}#yiv6707300043 #yiv6707300043ygrp-vital ul li:last-child {border-right:none !important;}#yiv6707300043