Seperti ini ya Sandy
On Friday, October 4, 2019, 04:10:14 PM GMT+8, Abid Kausar muha...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Dear Para Suhu, mohon bantuannya Suhu.., saya punya data yang harus dijalankan dengan makro. Data terdiri dari 2 Sheet, Sheet pertama master data, sheet kedua data olahanyang ingin saya tanyakan ke para suhu, bagiamana caranya data di sheet pertama pindah ke sheet dua dengan menggunakan makro. dengan catatan makro yang digunakan bukan record makro... berikut saya lampirkan di attachment contoh datanya mohon maaf jika ada kata2 yang salah dan tidak berkenan... Salam,Muhabka #yiv2583187408 #yiv2583187408 -- #yiv2583187408ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2583187408 #yiv2583187408ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2583187408 #yiv2583187408ygrp-mkp #yiv2583187408hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2583187408 #yiv2583187408ygrp-mkp #yiv2583187408ads {margin-bottom:10px;}#yiv2583187408 #yiv2583187408ygrp-mkp .yiv2583187408ad {padding:0 0;}#yiv2583187408 #yiv2583187408ygrp-mkp .yiv2583187408ad p {margin:0;}#yiv2583187408 #yiv2583187408ygrp-mkp .yiv2583187408ad a {color:#0000ff;text-decoration:none;}#yiv2583187408 #yiv2583187408ygrp-sponsor #yiv2583187408ygrp-lc {font-family:Arial;}#yiv2583187408 #yiv2583187408ygrp-sponsor #yiv2583187408ygrp-lc #yiv2583187408hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2583187408 #yiv2583187408ygrp-sponsor #yiv2583187408ygrp-lc .yiv2583187408ad {margin-bottom:10px;padding:0 0;}#yiv2583187408 #yiv2583187408actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2583187408 #yiv2583187408activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2583187408 #yiv2583187408activity span {font-weight:700;}#yiv2583187408 #yiv2583187408activity span:first-child {text-transform:uppercase;}#yiv2583187408 #yiv2583187408activity span a {color:#5085b6;text-decoration:none;}#yiv2583187408 #yiv2583187408activity span span {color:#ff7900;}#yiv2583187408 #yiv2583187408activity span .yiv2583187408underline {text-decoration:underline;}#yiv2583187408 .yiv2583187408attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2583187408 .yiv2583187408attach div a {text-decoration:none;}#yiv2583187408 .yiv2583187408attach img {border:none;padding-right:5px;}#yiv2583187408 .yiv2583187408attach label {display:block;margin-bottom:5px;}#yiv2583187408 .yiv2583187408attach label a {text-decoration:none;}#yiv2583187408 blockquote {margin:0 0 0 4px;}#yiv2583187408 .yiv2583187408bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2583187408 .yiv2583187408bold a {text-decoration:none;}#yiv2583187408 dd.yiv2583187408last p a {font-family:Verdana;font-weight:700;}#yiv2583187408 dd.yiv2583187408last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2583187408 dd.yiv2583187408last p span.yiv2583187408yshortcuts {margin-right:0;}#yiv2583187408 div.yiv2583187408attach-table div div a {text-decoration:none;}#yiv2583187408 div.yiv2583187408attach-table {width:400px;}#yiv2583187408 div.yiv2583187408file-title a, #yiv2583187408 div.yiv2583187408file-title a:active, #yiv2583187408 div.yiv2583187408file-title a:hover, #yiv2583187408 div.yiv2583187408file-title a:visited {text-decoration:none;}#yiv2583187408 div.yiv2583187408photo-title a, #yiv2583187408 div.yiv2583187408photo-title a:active, #yiv2583187408 div.yiv2583187408photo-title a:hover, #yiv2583187408 div.yiv2583187408photo-title a:visited {text-decoration:none;}#yiv2583187408 div#yiv2583187408ygrp-mlmsg #yiv2583187408ygrp-msg p a span.yiv2583187408yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2583187408 .yiv2583187408green {color:#628c2a;}#yiv2583187408 .yiv2583187408MsoNormal {margin:0 0 0 0;}#yiv2583187408 o {font-size:0;}#yiv2583187408 #yiv2583187408photos div {float:left;width:72px;}#yiv2583187408 #yiv2583187408photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2583187408 #yiv2583187408photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2583187408 #yiv2583187408reco-category {font-size:77%;}#yiv2583187408 #yiv2583187408reco-desc {font-size:77%;}#yiv2583187408 .yiv2583187408replbq {margin:4px;}#yiv2583187408 #yiv2583187408ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2583187408 #yiv2583187408ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2583187408 #yiv2583187408ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2583187408 #yiv2583187408ygrp-mlmsg select, #yiv2583187408 input, #yiv2583187408 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2583187408 #yiv2583187408ygrp-mlmsg pre, #yiv2583187408 code {font:115% monospace;}#yiv2583187408 #yiv2583187408ygrp-mlmsg * {line-height:1.22em;}#yiv2583187408 #yiv2583187408ygrp-mlmsg #yiv2583187408logo {padding-bottom:10px;}#yiv2583187408 #yiv2583187408ygrp-msg p a {font-family:Verdana;}#yiv2583187408 #yiv2583187408ygrp-msg p#yiv2583187408attach-count span {color:#1E66AE;font-weight:700;}#yiv2583187408 #yiv2583187408ygrp-reco #yiv2583187408reco-head {color:#ff7900;font-weight:700;}#yiv2583187408 #yiv2583187408ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2583187408 #yiv2583187408ygrp-sponsor #yiv2583187408ov li a {font-size:130%;text-decoration:none;}#yiv2583187408 #yiv2583187408ygrp-sponsor #yiv2583187408ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2583187408 #yiv2583187408ygrp-sponsor #yiv2583187408ov ul {margin:0;padding:0 0 0 8px;}#yiv2583187408 #yiv2583187408ygrp-text {font-family:Georgia;}#yiv2583187408 #yiv2583187408ygrp-text p {margin:0 0 1em 0;}#yiv2583187408 #yiv2583187408ygrp-text tt {font-size:120%;}#yiv2583187408 #yiv2583187408ygrp-vital ul li:last-child {border-right:none !important;}#yiv2583187408
Lthn_Makro_1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12