Jumat, 26 Agustus 2016

[belajar-excel] Digest Number 3948

4 Messages

Digest #3948
1a
Re_Sheet Otomatis berdasarkan kolom by "hendrik karnadi" hendrikkarnadi
1b
Looping Vba berdasarkan list tertentu by "Fajar Fatahillah" fajar.fatahillah
1c
2a
Re: Filter pivot table dengan macro by "Fajar Fatahillah" fajar.fatahillah

Messages

Thu Aug 25, 2016 8:43 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Dear Be Exceler,
Terlampir adalah jawaban atas pertanyaaan seseorang untuk memisahkan data kedalam masing2 Sheet, sesuai kolom U (nama lembaga)
Tanpa sengaja (krn pake notebook tua),- Emailnya terhapus- Isi datanya berubah namun struktur tetap sama.
Semoga bermanfaat.

Salam,HK

Thu Aug 25, 2016 10:59 pm (PDT) . Posted by:

"Fajar Fatahillah" fajar.fatahillah

Dear Para Master Excel,saya ingin membuat aktivitas excel yang rutin dikerjakan dan berdasarkan list terttentu yang berubah ubah,beberapa aktivitas tersebut yaitu open file sesuai list di excel td, copy paste , dan save file as sesuai list juga.
terlampir contoh excelnya
Mohon bantuannya ya
 Best Regards, Fajar Fatahillah

#yiv3507298142 #yiv3507298142 -- #yiv3507298142ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3507298142 #yiv3507298142ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3507298142 #yiv3507298142ygrp-mkp #yiv3507298142hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3507298142 #yiv3507298142ygrp-mkp #yiv3507298142ads {margin-bottom:10px;}#yiv3507298142 #yiv3507298142ygrp-mkp .yiv3507298142ad {padding:0 0;}#yiv3507298142 #yiv3507298142ygrp-mkp .yiv3507298142ad p {margin:0;}#yiv3507298142 #yiv3507298142ygrp-mkp .yiv3507298142ad a {color:#0000ff;text-decoration:none;}#yiv3507298142 #yiv3507298142ygrp-sponsor #yiv3507298142ygrp-lc {font-family:Arial;}#yiv3507298142 #yiv3507298142ygrp-sponsor #yiv3507298142ygrp-lc #yiv3507298142hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3507298142 #yiv3507298142ygrp-sponsor #yiv3507298142ygrp-lc .yiv3507298142ad {margin-bottom:10px;padding:0 0;}#yiv3507298142 #yiv3507298142actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3507298142 #yiv3507298142activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3507298142 #yiv3507298142activity span {font-weight:700;}#yiv3507298142 #yiv3507298142activity span:first-child {text-transform:uppercase;}#yiv3507298142 #yiv3507298142activity span a {color:#5085b6;text-decoration:none;}#yiv3507298142 #yiv3507298142activity span span {color:#ff7900;}#yiv3507298142 #yiv3507298142activity span .yiv3507298142underline {text-decoration:underline;}#yiv3507298142 .yiv3507298142attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3507298142 .yiv3507298142attach div a {text-decoration:none;}#yiv3507298142 .yiv3507298142attach img {border:none;padding-right:5px;}#yiv3507298142 .yiv3507298142attach label {display:block;margin-bottom:5px;}#yiv3507298142 .yiv3507298142attach label a {text-decoration:none;}#yiv3507298142 blockquote {margin:0 0 0 4px;}#yiv3507298142 .yiv3507298142bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3507298142 .yiv3507298142bold a {text-decoration:none;}#yiv3507298142 dd.yiv3507298142last p a {font-family:Verdana;font-weight:700;}#yiv3507298142 dd.yiv3507298142last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3507298142 dd.yiv3507298142last p span.yiv3507298142yshortcuts {margin-right:0;}#yiv3507298142 div.yiv3507298142attach-table div div a {text-decoration:none;}#yiv3507298142 div.yiv3507298142attach-table {width:400px;}#yiv3507298142 div.yiv3507298142file-title a, #yiv3507298142 div.yiv3507298142file-title a:active, #yiv3507298142 div.yiv3507298142file-title a:hover, #yiv3507298142 div.yiv3507298142file-title a:visited {text-decoration:none;}#yiv3507298142 div.yiv3507298142photo-title a, #yiv3507298142 div.yiv3507298142photo-title a:active, #yiv3507298142 div.yiv3507298142photo-title a:hover, #yiv3507298142 div.yiv3507298142photo-title a:visited {text-decoration:none;}#yiv3507298142 div#yiv3507298142ygrp-mlmsg #yiv3507298142ygrp-msg p a span.yiv3507298142yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3507298142 .yiv3507298142green {color:#628c2a;}#yiv3507298142 .yiv3507298142MsoNormal {margin:0 0 0 0;}#yiv3507298142 o {font-size:0;}#yiv3507298142 #yiv3507298142photos div {float:left;width:72px;}#yiv3507298142 #yiv3507298142photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3507298142 #yiv3507298142photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3507298142 #yiv3507298142reco-category {font-size:77%;}#yiv3507298142 #yiv3507298142reco-desc {font-size:77%;}#yiv3507298142 .yiv3507298142replbq {margin:4px;}#yiv3507298142 #yiv3507298142ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3507298142 #yiv3507298142ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3507298142 #yiv3507298142ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3507298142 #yiv3507298142ygrp-mlmsg select, #yiv3507298142 input, #yiv3507298142 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3507298142 #yiv3507298142ygrp-mlmsg pre, #yiv3507298142 code {font:115% monospace;}#yiv3507298142 #yiv3507298142ygrp-mlmsg * {line-height:1.22em;}#yiv3507298142 #yiv3507298142ygrp-mlmsg #yiv3507298142logo {padding-bottom:10px;}#yiv3507298142 #yiv3507298142ygrp-msg p a {font-family:Verdana;}#yiv3507298142 #yiv3507298142ygrp-msg p#yiv3507298142attach-count span {color:#1E66AE;font-weight:700;}#yiv3507298142 #yiv3507298142ygrp-reco #yiv3507298142reco-head {color:#ff7900;font-weight:700;}#yiv3507298142 #yiv3507298142ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3507298142 #yiv3507298142ygrp-sponsor #yiv3507298142ov li a {font-size:130%;text-decoration:none;}#yiv3507298142 #yiv3507298142ygrp-sponsor #yiv3507298142ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3507298142 #yiv3507298142ygrp-sponsor #yiv3507298142ov ul {margin:0;padding:0 0 0 8px;}#yiv3507298142 #yiv3507298142ygrp-text {font-family:Georgia;}#yiv3507298142 #yiv3507298142ygrp-text p {margin:0 0 1em 0;}#yiv3507298142 #yiv3507298142ygrp-text tt {font-size:120%;}#yiv3507298142 #yiv3507298142ygrp-vital ul li:last-child {border-right:none !important;}#yiv3507298142

Fri Aug 26, 2016 1:25 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Fajar,Coba buat/copas Macro (Open File) berikut ini,Option Explicit
Sub BukaFile()
    Dim Path As String    Dim nm_file As Range    Dim nm As Range    Path = Range("G1").Value & "\" 'sel G1 berisi (ditulis) Dir dan Sub Dir tempat dimana file2 berada, mis D:\Coba   Set nm_file = Range("H1", Range("H1").End(xlDown)) 'Sel H1 dst. berisi nama2 file yang akan dibuka
    For Each nm In nm_file        On Error GoTo Pesan        Workbooks.Open Filename:=Path & nm    Next nmPesan:    MsgBox "SELESAI", vbCritical, "P E S A N"End Sub
Salam,HK

From: "Fajar Fatahillah fajar.fatahillah@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 26 August 2016, 11:42
Subject: [belajar-excel] Looping Vba berdasarkan list tertentu [1 Attachment]

  Dear Para Master Excel,saya ingin membuat aktivitas excel yang rutin dikerjakan dan berdasarkan list terttentu yang berubah ubah,beberapa aktivitas tersebut yaitu open file sesuai list di excel td, copy paste , dan save file as sesuai list juga.
terlampir contoh excelnya
Mohon bantuannya ya
 Best Regards, Fajar Fatahillah

#yiv1320986275 #yiv1320986275 -- #yiv1320986275ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1320986275 #yiv1320986275ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1320986275 #yiv1320986275ygrp-mkp #yiv1320986275hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1320986275 #yiv1320986275ygrp-mkp #yiv1320986275ads {margin-bottom:10px;}#yiv1320986275 #yiv1320986275ygrp-mkp .yiv1320986275ad {padding:0 0;}#yiv1320986275 #yiv1320986275ygrp-mkp .yiv1320986275ad p {margin:0;}#yiv1320986275 #yiv1320986275ygrp-mkp .yiv1320986275ad a {color:#0000ff;text-decoration:none;}#yiv1320986275 #yiv1320986275ygrp-sponsor #yiv1320986275ygrp-lc {font-family:Arial;}#yiv1320986275 #yiv1320986275ygrp-sponsor #yiv1320986275ygrp-lc #yiv1320986275hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1320986275 #yiv1320986275ygrp-sponsor #yiv1320986275ygrp-lc .yiv1320986275ad {margin-bottom:10px;padding:0 0;}#yiv1320986275 #yiv1320986275actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1320986275 #yiv1320986275activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1320986275 #yiv1320986275activity span {font-weight:700;}#yiv1320986275 #yiv1320986275activity span:first-child {text-transform:uppercase;}#yiv1320986275 #yiv1320986275activity span a {color:#5085b6;text-decoration:none;}#yiv1320986275 #yiv1320986275activity span span {color:#ff7900;}#yiv1320986275 #yiv1320986275activity span .yiv1320986275underline {text-decoration:underline;}#yiv1320986275 .yiv1320986275attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1320986275 .yiv1320986275attach div a {text-decoration:none;}#yiv1320986275 .yiv1320986275attach img {border:none;padding-right:5px;}#yiv1320986275 .yiv1320986275attach label {display:block;margin-bottom:5px;}#yiv1320986275 .yiv1320986275attach label a {text-decoration:none;}#yiv1320986275 blockquote {margin:0 0 0 4px;}#yiv1320986275 .yiv1320986275bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1320986275 .yiv1320986275bold a {text-decoration:none;}#yiv1320986275 dd.yiv1320986275last p a {font-family:Verdana;font-weight:700;}#yiv1320986275 dd.yiv1320986275last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1320986275 dd.yiv1320986275last p span.yiv1320986275yshortcuts {margin-right:0;}#yiv1320986275 div.yiv1320986275attach-table div div a {text-decoration:none;}#yiv1320986275 div.yiv1320986275attach-table {width:400px;}#yiv1320986275 div.yiv1320986275file-title a, #yiv1320986275 div.yiv1320986275file-title a:active, #yiv1320986275 div.yiv1320986275file-title a:hover, #yiv1320986275 div.yiv1320986275file-title a:visited {text-decoration:none;}#yiv1320986275 div.yiv1320986275photo-title a, #yiv1320986275 div.yiv1320986275photo-title a:active, #yiv1320986275 div.yiv1320986275photo-title a:hover, #yiv1320986275 div.yiv1320986275photo-title a:visited {text-decoration:none;}#yiv1320986275 div#yiv1320986275ygrp-mlmsg #yiv1320986275ygrp-msg p a span.yiv1320986275yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1320986275 .yiv1320986275green {color:#628c2a;}#yiv1320986275 .yiv1320986275MsoNormal {margin:0 0 0 0;}#yiv1320986275 o {font-size:0;}#yiv1320986275 #yiv1320986275photos div {float:left;width:72px;}#yiv1320986275 #yiv1320986275photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1320986275 #yiv1320986275photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1320986275 #yiv1320986275reco-category {font-size:77%;}#yiv1320986275 #yiv1320986275reco-desc {font-size:77%;}#yiv1320986275 .yiv1320986275replbq {margin:4px;}#yiv1320986275 #yiv1320986275ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1320986275 #yiv1320986275ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1320986275 #yiv1320986275ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1320986275 #yiv1320986275ygrp-mlmsg select, #yiv1320986275 input, #yiv1320986275 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1320986275 #yiv1320986275ygrp-mlmsg pre, #yiv1320986275 code {font:115% monospace;}#yiv1320986275 #yiv1320986275ygrp-mlmsg * {line-height:1.22em;}#yiv1320986275 #yiv1320986275ygrp-mlmsg #yiv1320986275logo {padding-bottom:10px;}#yiv1320986275 #yiv1320986275ygrp-msg p a {font-family:Verdana;}#yiv1320986275 #yiv1320986275ygrp-msg p#yiv1320986275attach-count span {color:#1E66AE;font-weight:700;}#yiv1320986275 #yiv1320986275ygrp-reco #yiv1320986275reco-head {color:#ff7900;font-weight:700;}#yiv1320986275 #yiv1320986275ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1320986275 #yiv1320986275ygrp-sponsor #yiv1320986275ov li a {font-size:130%;text-decoration:none;}#yiv1320986275 #yiv1320986275ygrp-sponsor #yiv1320986275ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1320986275 #yiv1320986275ygrp-sponsor #yiv1320986275ov ul {margin:0;padding:0 0 0 8px;}#yiv1320986275 #yiv1320986275ygrp-text {font-family:Georgia;}#yiv1320986275 #yiv1320986275ygrp-text p {margin:0 0 1em 0;}#yiv1320986275 #yiv1320986275ygrp-text tt {font-size:120%;}#yiv1320986275 #yiv1320986275ygrp-vital ul li:last-child {border-right:none !important;}#yiv1320986275

Thu Aug 25, 2016 10:52 pm (PDT) . Posted by:

"Fajar Fatahillah" fajar.fatahillah

Maaf baru jawab, iya Mr. kid , Listnya di sheet lain 

Sent from Yahoo Mail on Android

On Sun, Aug 7, 2016 at 12:17 PM, hendrikkarnadi hendrikkarnadi@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Hai Fajar,Dulu Mr. Kid pernah buat Macronya.Maksudnya listnya di luar pivot?
Salam,HK

Sent from Samsung Mobile.

-------- Original message --------From: "Fajar Fatahillah fajar.fatahillah@yahoo.com [belajar-excel]" Date:08/05/2016 11:59 PM (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Filter pivot table dengan macro
 
Dear master excel,
Ada yang punya macro utk filter pivottable berdasarkan list tertentu.List tersebut diexclude dari pivot yg akan direfresh..
Terima kasih atas bantuannya

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar