[belajar-excel] Seleksi Range dari sheet berbeda [1 Attachment]

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

[belajar-excel] Seleksi Range dari sheet berbeda [1 Attachment]

Abid Kausar
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 olahan
yang 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

Lthn_Makro_1.xlsx (15K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Bls: [belajar-excel] Seleksi Range dari sheet berbeda

Eira_ariE
Pak muhabka ..
Harus pakai macro yaa .. knp ?Kayaknya sih lebih simple jika pakai pivot table utk reportnya (sheet 2) .. sheet 1 (berupa master data : olahan2 juga, diformat aja jadi Excel table master data ini)
Tks ari
Dikirim dari Yahoo Mail di Android

  Pada Jum, 4 Okt 2019 pada 15:10, Abid Kausar [hidden email] [belajar-excel]<[hidden email]> menulis:    

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  #yiv0937749712 #yiv0937749712 -- #yiv0937749712ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0937749712 #yiv0937749712ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0937749712 #yiv0937749712ygrp-mkp #yiv0937749712hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0937749712 #yiv0937749712ygrp-mkp #yiv0937749712ads {margin-bottom:10px;}#yiv0937749712 #yiv0937749712ygrp-mkp .yiv0937749712ad {padding:0 0;}#yiv0937749712 #yiv0937749712ygrp-mkp .yiv0937749712ad p {margin:0;}#yiv0937749712 #yiv0937749712ygrp-mkp .yiv0937749712ad a {color:#0000ff;text-decoration:none;}#yiv0937749712 #yiv0937749712ygrp-sponsor #yiv0937749712ygrp-lc {font-family:Arial;}#yiv0937749712 #yiv0937749712ygrp-sponsor #yiv0937749712ygrp-lc #yiv0937749712hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0937749712 #yiv0937749712ygrp-sponsor #yiv0937749712ygrp-lc .yiv0937749712ad {margin-bottom:10px;padding:0 0;}#yiv0937749712 #yiv0937749712actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0937749712 #yiv0937749712activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0937749712 #yiv0937749712activity span {font-weight:700;}#yiv0937749712 #yiv0937749712activity span:first-child {text-transform:uppercase;}#yiv0937749712 #yiv0937749712activity span a {color:#5085b6;text-decoration:none;}#yiv0937749712 #yiv0937749712activity span span {color:#ff7900;}#yiv0937749712 #yiv0937749712activity span .yiv0937749712underline {text-decoration:underline;}#yiv0937749712 .yiv0937749712attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0937749712 .yiv0937749712attach div a {text-decoration:none;}#yiv0937749712 .yiv0937749712attach img {border:none;padding-right:5px;}#yiv0937749712 .yiv0937749712attach label {display:block;margin-bottom:5px;}#yiv0937749712 .yiv0937749712attach label a {text-decoration:none;}#yiv0937749712 blockquote {margin:0 0 0 4px;}#yiv0937749712 .yiv0937749712bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0937749712 .yiv0937749712bold a {text-decoration:none;}#yiv0937749712 dd.yiv0937749712last p a {font-family:Verdana;font-weight:700;}#yiv0937749712 dd.yiv0937749712last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0937749712 dd.yiv0937749712last p span.yiv0937749712yshortcuts {margin-right:0;}#yiv0937749712 div.yiv0937749712attach-table div div a {text-decoration:none;}#yiv0937749712 div.yiv0937749712attach-table {width:400px;}#yiv0937749712 div.yiv0937749712file-title a, #yiv0937749712 div.yiv0937749712file-title a:active, #yiv0937749712 div.yiv0937749712file-title a:hover, #yiv0937749712 div.yiv0937749712file-title a:visited {text-decoration:none;}#yiv0937749712 div.yiv0937749712photo-title a, #yiv0937749712 div.yiv0937749712photo-title a:active, #yiv0937749712 div.yiv0937749712photo-title a:hover, #yiv0937749712 div.yiv0937749712photo-title a:visited {text-decoration:none;}#yiv0937749712 div#yiv0937749712ygrp-mlmsg #yiv0937749712ygrp-msg p a span.yiv0937749712yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0937749712 .yiv0937749712green {color:#628c2a;}#yiv0937749712 .yiv0937749712MsoNormal {margin:0 0 0 0;}#yiv0937749712 o {font-size:0;}#yiv0937749712 #yiv0937749712photos div {float:left;width:72px;}#yiv0937749712 #yiv0937749712photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0937749712 #yiv0937749712photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0937749712 #yiv0937749712reco-category {font-size:77%;}#yiv0937749712 #yiv0937749712reco-desc {font-size:77%;}#yiv0937749712 ...yiv0937749712replbq {margin:4px;}#yiv0937749712 #yiv0937749712ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0937749712 #yiv0937749712ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0937749712 #yiv0937749712ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0937749712 #yiv0937749712ygrp-mlmsg select, #yiv0937749712 input, #yiv0937749712 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0937749712 #yiv0937749712ygrp-mlmsg pre, #yiv0937749712 code {font:115% monospace;}#yiv0937749712 #yiv0937749712ygrp-mlmsg * {line-height:1.22em;}#yiv0937749712 #yiv0937749712ygrp-mlmsg #yiv0937749712logo {padding-bottom:10px;}#yiv0937749712 #yiv0937749712ygrp-msg p a {font-family:Verdana;}#yiv0937749712 #yiv0937749712ygrp-msg p#yiv0937749712attach-count span {color:#1E66AE;font-weight:700;}#yiv0937749712 #yiv0937749712ygrp-reco #yiv0937749712reco-head {color:#ff7900;font-weight:700;}#yiv0937749712 #yiv0937749712ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0937749712 #yiv0937749712ygrp-sponsor #yiv0937749712ov li a {font-size:130%;text-decoration:none;}#yiv0937749712 #yiv0937749712ygrp-sponsor #yiv0937749712ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0937749712 #yiv0937749712ygrp-sponsor #yiv0937749712ov ul {margin:0;padding:0 0 0 8px;}#yiv0937749712 #yiv0937749712ygrp-text {font-family:Georgia;}#yiv0937749712 #yiv0937749712ygrp-text p {margin:0 0 1em 0;}#yiv0937749712 #yiv0937749712ygrp-text tt {font-size:120%;}#yiv0937749712 #yiv0937749712ygrp-vital ul li:last-child {border-right:none !important;}#yiv0937749712
Reply | Threaded
Open this post in threaded view
|

Fw: Bls: [belajar-excel] Seleksi Range dari sheet berbeda [1 Attachment]

hendrik karnadi
 Pak Muhabka,Jika hasil yang diinginkan sesuai contoh di Sheet maka benar seperti yang dikatakan Ari...menggunakan Pivot Table adalah cara yang pling sederhana dan cepat.Contoh terlampir.
Salam,HK

   ----- Pesan yang Diteruskan ----- Dari: Eira I Arie [hidden email] [belajar-excel] <[hidden email]>Kepada: "[hidden email]" <[hidden email]>Terkirim: Jumat, 4 Oktober 2019 15.17.52 WIBJudul: Bls: [belajar-excel] Seleksi Range dari sheet berbeda
    
Pak muhabka ..

Harus pakai macro yaa .. knp ?Kayaknya sih lebih simple jika pakai pivot table utk reportnya (sheet 2) .. sheet 1 (berupa master data : olahan2 juga, diformat aja jadi Excel table master data ini)
Tks ari
Dikirim dari Yahoo Mail di Android
 
  Pada Jum, 4 Okt 2019 pada 15:10, Abid Kausar [hidden email] [belajar-excel]<[hidden email]> menulis:      

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    
   

=?UTF-8?b?cmVfTHRobl9NYWtyb18xLnhsc3g=?= (22K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Seleksi Range dari sheet berbeda [1 Attachment]

Sandy-2
In reply to this post by Abid Kausar
Seperti ini ya

Sandy

    On Friday, October 4, 2019, 04:10:14 PM GMT+8, Abid Kausar [hidden email] [belajar-excel] <[hidden email]> 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 (26K) Download Attachment