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
