Re: [belajar-excel] Copy data berulang dengan Macro [1 Attachment]

Mon, 22 Feb 2016 23:28:51 -0800 

Hai Lukman,

Gunakan VBA dengan Loop method untuk membuatnya.
Coba file ini, semoga sesuai.
Tinggal tekan tombol Hasil, maka nilainya akan keluar.


TerimaKasih.




Pada Sel, 23/2/16, [email protected] [belajar-excel] 
<[email protected]> menulis:

 Judul: Re: [belajar-excel] Copy data berulang dengan Macro [1 Attachment]
 Kepada: [email protected]
 Tanggal: Selasa, 23 Februari, 2016, 9:21 AM
 
 
  
 
 
 
   
 
 
     
       
       
       Dear Mr. Toby,
 
 
 Terimakasih atas responnya,
 jadi saya ingin mengcopy data dalam bentuk
 baris ke-pinggir, menjadi baris ke-bawah. yang mana hal ini
 baris ke pinggirnya tidak beraturan. jadi saya ingin urut
 data semuanya ke-bawah. kira-kira bahasa indonesianya
 seperti ini,
 
  
 1. pilih cell
 C10,  tekan enter atau panah kanan terus sampai ketemu
 baris yang kosong, COPY
 2. Pilih cell N3,
 PASTE special tranpose
 3. pilih cell C11, 
 tekan enter atau panah kanan terus sampai ketemu baris yang
 kosong, COPY
 4. Pilih cell N3, panah BAWAH
 terus sampai ketemu baris yang kosong, PASTE special
 tranpose
 5. Pilih C12,C13 dst sampai data
 habis. Pilih cell N3, panah BAWAH terus sampai ketemu baris
 yang kosong, PASTE special tranpose
 6.
 Begitu berulang-ulang (looping) sampai semua data ter-COPY
 (C157 / atau lebih)
 Contoh file saya
 lampirkan.
 
 
 
 
 Terimakasih,
 
 
 Salam
 
 Lukmanul H               
                    
 
                   
 
  
 
     
      
 
     
     
 
 
 
 #yiv2137145507 #yiv2137145507 --
   #yiv2137145507ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv2137145507 #yiv2137145507ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv2137145507 #yiv2137145507ygrp-mkp #yiv2137145507hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv2137145507 #yiv2137145507ygrp-mkp #yiv2137145507ads {
 margin-bottom:10px;}
 
 #yiv2137145507 #yiv2137145507ygrp-mkp .yiv2137145507ad {
 padding:0 0;}
 
 #yiv2137145507 #yiv2137145507ygrp-mkp .yiv2137145507ad p {
 margin:0;}
 
 #yiv2137145507 #yiv2137145507ygrp-mkp .yiv2137145507ad a {
 color:#0000ff;text-decoration:none;}
 #yiv2137145507 #yiv2137145507ygrp-sponsor
 #yiv2137145507ygrp-lc {
 font-family:Arial;}
 
 #yiv2137145507 #yiv2137145507ygrp-sponsor
 #yiv2137145507ygrp-lc #yiv2137145507hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv2137145507 #yiv2137145507ygrp-sponsor
 #yiv2137145507ygrp-lc .yiv2137145507ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv2137145507 #yiv2137145507actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv2137145507 #yiv2137145507activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv2137145507 #yiv2137145507activity span {
 font-weight:700;}
 
 #yiv2137145507 #yiv2137145507activity span:first-child {
 text-transform:uppercase;}
 
 #yiv2137145507 #yiv2137145507activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv2137145507 #yiv2137145507activity span span {
 color:#ff7900;}
 
 #yiv2137145507 #yiv2137145507activity span
 .yiv2137145507underline {
 text-decoration:underline;}
 
 #yiv2137145507 .yiv2137145507attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv2137145507 .yiv2137145507attach div a {
 text-decoration:none;}
 
 #yiv2137145507 .yiv2137145507attach img {
 border:none;padding-right:5px;}
 
 #yiv2137145507 .yiv2137145507attach label {
 display:block;margin-bottom:5px;}
 
 #yiv2137145507 .yiv2137145507attach label a {
 text-decoration:none;}
 
 #yiv2137145507 blockquote {
 margin:0 0 0 4px;}
 
 #yiv2137145507 .yiv2137145507bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv2137145507 .yiv2137145507bold a {
 text-decoration:none;}
 
 #yiv2137145507 dd.yiv2137145507last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv2137145507 dd.yiv2137145507last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv2137145507 dd.yiv2137145507last p
 span.yiv2137145507yshortcuts {
 margin-right:0;}
 
 #yiv2137145507 div.yiv2137145507attach-table div div a {
 text-decoration:none;}
 
 #yiv2137145507 div.yiv2137145507attach-table {
 width:400px;}
 
 #yiv2137145507 div.yiv2137145507file-title a, #yiv2137145507
 div.yiv2137145507file-title a:active, #yiv2137145507
 div.yiv2137145507file-title a:hover, #yiv2137145507
 div.yiv2137145507file-title a:visited {
 text-decoration:none;}
 
 #yiv2137145507 div.yiv2137145507photo-title a,
 #yiv2137145507 div.yiv2137145507photo-title a:active,
 #yiv2137145507 div.yiv2137145507photo-title a:hover,
 #yiv2137145507 div.yiv2137145507photo-title a:visited {
 text-decoration:none;}
 
 #yiv2137145507 div#yiv2137145507ygrp-mlmsg
 #yiv2137145507ygrp-msg p a span.yiv2137145507yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv2137145507 .yiv2137145507green {
 color:#628c2a;}
 
 #yiv2137145507 .yiv2137145507MsoNormal {
 margin:0 0 0 0;}
 
 #yiv2137145507 o {
 font-size:0;}
 
 #yiv2137145507 #yiv2137145507photos div {
 float:left;width:72px;}
 
 #yiv2137145507 #yiv2137145507photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv2137145507 #yiv2137145507photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv2137145507 #yiv2137145507reco-category {
 font-size:77%;}
 
 #yiv2137145507 #yiv2137145507reco-desc {
 font-size:77%;}
 
 #yiv2137145507 .yiv2137145507replbq {
 margin:4px;}
 
 #yiv2137145507 #yiv2137145507ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv2137145507 #yiv2137145507ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv2137145507 #yiv2137145507ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv2137145507 #yiv2137145507ygrp-mlmsg select,
 #yiv2137145507 input, #yiv2137145507 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv2137145507 #yiv2137145507ygrp-mlmsg pre, #yiv2137145507
 code {
 font:115% monospace;}
 
 #yiv2137145507 #yiv2137145507ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv2137145507 #yiv2137145507ygrp-mlmsg #yiv2137145507logo {
 padding-bottom:10px;}
 
 
 #yiv2137145507 #yiv2137145507ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv2137145507 #yiv2137145507ygrp-msg
 p#yiv2137145507attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv2137145507 #yiv2137145507ygrp-reco
 #yiv2137145507reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv2137145507 #yiv2137145507ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv2137145507 #yiv2137145507ygrp-sponsor #yiv2137145507ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv2137145507 #yiv2137145507ygrp-sponsor #yiv2137145507ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv2137145507 #yiv2137145507ygrp-sponsor #yiv2137145507ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv2137145507 #yiv2137145507ygrp-text {
 font-family:Georgia;}
 
 #yiv2137145507 #yiv2137145507ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv2137145507 #yiv2137145507ygrp-text tt {
 font-size:120%;}
 
 #yiv2137145507 #yiv2137145507ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv2137145507

Attachment: contoh data copy_toby.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Kirim email ke