Bang Andrie,
coba rumah macro2 menjadi:
Sub Macro2()
With Worksheets("Sheet1")
AD = .Range("A1:A25").Value
End With
With Worksheets("Sheet2")
columnterakhir = .Cells(1, .Columns.Count).End(xlToLeft).Column '=kolom
jumlah
columnterakhir = .Cells(1,
columnterakhir).End(xlToLeft).Column'tambahan baris baru
ColumnTujuan = columnterakhir + 1
.Range(.Cells(1, ColumnTujuan), .Cells(25, ColumnTujuan)).Value = AD
End With
End Sub
#dikirim_pakai_mail.yahoo.com_tanpa_pulsa#
--------------------------------------------
On Fri, 4/5/18, Andrie Amorius bm7...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
Subject: [belajar-excel] Copy Paste Data ke Sheet Berbeda pada Range Data [1
Attachment]
To: belajar-excel@yahoogroups.com
Date: Friday, 4 May, 2018, 3:05 PM
Dear Master Excel...
Mohon bantuannya, ane punya data disheet1 dan
ingin mengcopy pastekannya ketabel disheet2 (range A1:I25)
dikolom terakhir yg kosong dengan menggunakan:
With Worksheets("Sheet1") AD
= .Range("A1:A25").Value End
With
With
Worksheets("Sheet2")
ColumnTerakhir = .Cells(1,
.Columns.Count).End(xlToLeft).Column
ColumnTujuan = ColumnTerakhir + 1
.Range(.Cells(1, ColumnTujuan), .Cells(25,
ColumnTujuan)).Value = AD End
With
Permasalahannya diujung tabel ada
kolom untuk jumlah, ketika script dijalankan data sheet1
malah terpaste keujung kolom disebelah kanan kolom jumlah
bkn dikolom terakhir yg kosong didalam range table...
Mohon kiranya dapat memberikan
solusi untuk permasalahan ane, terimakasih sebelumnya...
File ane
lampirkan....
Andrie
Amorius, SE. Ak
Task Force PSAK
71
PT. Bank Riau Kepri
Gedung Menara Dang Merdu Bank Riau Kepri
JL. Jend. Sudirman No. 462
Pekanbaru - Riau (28116)
#yiv0454282446 #yiv0454282446 --
#yiv0454282446ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv0454282446 #yiv0454282446ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv0454282446 #yiv0454282446ygrp-mkp #yiv0454282446hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv0454282446 #yiv0454282446ygrp-mkp #yiv0454282446ads {
margin-bottom:10px;}
#yiv0454282446 #yiv0454282446ygrp-mkp .yiv0454282446ad {
padding:0 0;}
#yiv0454282446 #yiv0454282446ygrp-mkp .yiv0454282446ad p {
margin:0;}
#yiv0454282446 #yiv0454282446ygrp-mkp .yiv0454282446ad a {
color:#0000ff;text-decoration:none;}
#yiv0454282446 #yiv0454282446ygrp-sponsor
#yiv0454282446ygrp-lc {
font-family:Arial;}
#yiv0454282446 #yiv0454282446ygrp-sponsor
#yiv0454282446ygrp-lc #yiv0454282446hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv0454282446 #yiv0454282446ygrp-sponsor
#yiv0454282446ygrp-lc .yiv0454282446ad {
margin-bottom:10px;padding:0 0;}
#yiv0454282446 #yiv0454282446actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv0454282446 #yiv0454282446activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv0454282446 #yiv0454282446activity span {
font-weight:700;}
#yiv0454282446 #yiv0454282446activity span:first-child {
text-transform:uppercase;}
#yiv0454282446 #yiv0454282446activity span a {
color:#5085b6;text-decoration:none;}
#yiv0454282446 #yiv0454282446activity span span {
color:#ff7900;}
#yiv0454282446 #yiv0454282446activity span
.yiv0454282446underline {
text-decoration:underline;}
#yiv0454282446 .yiv0454282446attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv0454282446 .yiv0454282446attach div a {
text-decoration:none;}
#yiv0454282446 .yiv0454282446attach img {
border:none;padding-right:5px;}
#yiv0454282446 .yiv0454282446attach label {
display:block;margin-bottom:5px;}
#yiv0454282446 .yiv0454282446attach label a {
text-decoration:none;}
#yiv0454282446 blockquote {
margin:0 0 0 4px;}
#yiv0454282446 .yiv0454282446bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv0454282446 .yiv0454282446bold a {
text-decoration:none;}
#yiv0454282446 dd.yiv0454282446last p a {
font-family:Verdana;font-weight:700;}
#yiv0454282446 dd.yiv0454282446last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv0454282446 dd.yiv0454282446last p
span.yiv0454282446yshortcuts {
margin-right:0;}
#yiv0454282446 div.yiv0454282446attach-table div div a {
text-decoration:none;}
#yiv0454282446 div.yiv0454282446attach-table {
width:400px;}
#yiv0454282446 div.yiv0454282446file-title a, #yiv0454282446
div.yiv0454282446file-title a:active, #yiv0454282446
div.yiv0454282446file-title a:hover, #yiv0454282446
div.yiv0454282446file-title a:visited {
text-decoration:none;}
#yiv0454282446 div.yiv0454282446photo-title a,
#yiv0454282446 div.yiv0454282446photo-title a:active,
#yiv0454282446 div.yiv0454282446photo-title a:hover,
#yiv0454282446 div.yiv0454282446photo-title a:visited {
text-decoration:none;}
#yiv0454282446 div#yiv0454282446ygrp-mlmsg
#yiv0454282446ygrp-msg p a span.yiv0454282446yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv0454282446 .yiv0454282446green {
color:#628c2a;}
#yiv0454282446 .yiv0454282446MsoNormal {
margin:0 0 0 0;}
#yiv0454282446 o {
font-size:0;}
#yiv0454282446 #yiv0454282446photos div {
float:left;width:72px;}
#yiv0454282446 #yiv0454282446photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}
#yiv0454282446 #yiv0454282446photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv0454282446 #yiv0454282446reco-category {
font-size:77%;}
#yiv0454282446 #yiv0454282446reco-desc {
font-size:77%;}
#yiv0454282446 .yiv0454282446replbq {
margin:4px;}
#yiv0454282446 #yiv0454282446ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv0454282446 #yiv0454282446ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv0454282446 #yiv0454282446ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv0454282446 #yiv0454282446ygrp-mlmsg select,
#yiv0454282446 input, #yiv0454282446 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv0454282446 #yiv0454282446ygrp-mlmsg pre, #yiv0454282446
code {
font:115% monospace;}
#yiv0454282446 #yiv0454282446ygrp-mlmsg * {
line-height:1.22em;}
#yiv0454282446 #yiv0454282446ygrp-mlmsg #yiv0454282446logo {
padding-bottom:10px;}
#yiv0454282446 #yiv0454282446ygrp-msg p a {
font-family:Verdana;}
#yiv0454282446 #yiv0454282446ygrp-msg
p#yiv0454282446attach-count span {
color:#1E66AE;font-weight:700;}
#yiv0454282446 #yiv0454282446ygrp-reco
#yiv0454282446reco-head {
color:#ff7900;font-weight:700;}
#yiv0454282446 #yiv0454282446ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv0454282446 #yiv0454282446ygrp-sponsor #yiv0454282446ov
li a {
font-size:130%;text-decoration:none;}
#yiv0454282446 #yiv0454282446ygrp-sponsor #yiv0454282446ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv0454282446 #yiv0454282446ygrp-sponsor #yiv0454282446ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv0454282446 #yiv0454282446ygrp-text {
font-family:Georgia;}
#yiv0454282446 #yiv0454282446ygrp-text p {
margin:0 0 1em 0;}
#yiv0454282446 #yiv0454282446ygrp-text tt {
font-size:120%;}
#yiv0454282446 #yiv0454282446ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0454282446
