15 Messages

Digest #4426

Rekap Mingguan Bulanan dan Kumulatif dengan Macro by "Zerlinda Seismica" seismica

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro by "hendrik karnadi" hendrikkarnadi

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac by "Zerlinda Seismica" seismica

Re: Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan by "hendrik karnadi" hendrikkarnadi

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac by "Zerlinda Seismica" seismica

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro by "lkm jktind" lkmjkt

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac by "Zerlinda Seismica" seismica

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro by "lkm jktind" lkmjkt

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro by "Mr. Kid" nmkid.family@ymail.com

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac by "Zerlinda Seismica" seismica

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro by "Mr. Kid" nmkid.family@ymail.com

excel versi 2010. by "lkm jktind" lkmjkt

Re: excel versi 2010. by "hendrik karnadi" hendrikkarnadi

Re: excel versi 2010. by "lkm jktind" lkmjkt

Re: Show/Hide Field List pada Pivot by "Stephen Saputro"

Messages

1a

Rekap Mingguan Bulanan dan Kumulatif dengan Macro

Wed Feb 7, 2018 1:46 am (PST) . Posted by:

"Zerlinda Seismica" seismica

Assalamualaikum wrwb

Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.

Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.

demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin

Wassalam

Seismica

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1b

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro

Wed Feb 7, 2018 6:15 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Seismica,Koq ga ada lampirannya ?
Salam,HK

Sent from Yahoo Mail on Android

On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:

Assalamualaikum wrwb
Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.
demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
Wassalam
Seismica
#yiv1941605227 #yiv1941605227 -- #yiv1941605227ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1941605227 #yiv1941605227ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1941605227 #yiv1941605227ygrp-mkp #yiv1941605227hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1941605227 #yiv1941605227ygrp-mkp #yiv1941605227ads {margin-bottom:10px;}#yiv1941605227 #yiv1941605227ygrp-mkp .yiv1941605227ad {padding:0 0;}#yiv1941605227 #yiv1941605227ygrp-mkp .yiv1941605227ad p {margin:0;}#yiv1941605227 #yiv1941605227ygrp-mkp .yiv1941605227ad a {color:#0000ff;text-decoration:none;}#yiv1941605227 #yiv1941605227ygrp-sponsor #yiv1941605227ygrp-lc {font-family:Arial;}#yiv1941605227 #yiv1941605227ygrp-sponsor #yiv1941605227ygrp-lc #yiv1941605227hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1941605227 #yiv1941605227ygrp-sponsor #yiv1941605227ygrp-lc .yiv1941605227ad {margin-bottom:10px;padding:0 0;}#yiv1941605227 #yiv1941605227actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1941605227 #yiv1941605227activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1941605227 #yiv1941605227activity span {font-weight:700;}#yiv1941605227 #yiv1941605227activity span:first-child {text-transform:uppercase;}#yiv1941605227 #yiv1941605227activity span a {color:#5085b6;text-decoration:none;}#yiv1941605227 #yiv1941605227activity span span {color:#ff7900;}#yiv1941605227 #yiv1941605227activity span .yiv1941605227underline {text-decoration:underline;}#yiv1941605227 .yiv1941605227attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1941605227 .yiv1941605227attach div a {text-decoration:none;}#yiv1941605227 .yiv1941605227attach img {border:none;padding-right:5px;}#yiv1941605227 .yiv1941605227attach label {display:block;margin-bottom:5px;}#yiv1941605227 .yiv1941605227attach label a {text-decoration:none;}#yiv1941605227 blockquote {margin:0 0 0 4px;}#yiv1941605227 .yiv1941605227bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1941605227 .yiv1941605227bold a {text-decoration:none;}#yiv1941605227 dd.yiv1941605227last p a {font-family:Verdana;font-weight:700;}#yiv1941605227 dd.yiv1941605227last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1941605227 dd.yiv1941605227last p span.yiv1941605227yshortcuts {margin-right:0;}#yiv1941605227 div.yiv1941605227attach-table div div a {text-decoration:none;}#yiv1941605227 div.yiv1941605227attach-table {width:400px;}#yiv1941605227 div.yiv1941605227file-title a, #yiv1941605227 div.yiv1941605227file-title a:active, #yiv1941605227 div.yiv1941605227file-title a:hover, #yiv1941605227 div.yiv1941605227file-title a:visited {text-decoration:none;}#yiv1941605227 div.yiv1941605227photo-title a, #yiv1941605227 div.yiv1941605227photo-title a:active, #yiv1941605227 div.yiv1941605227photo-title a:hover, #yiv1941605227 div.yiv1941605227photo-title a:visited {text-decoration:none;}#yiv1941605227 div#yiv1941605227ygrp-mlmsg #yiv1941605227ygrp-msg p a span.yiv1941605227yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1941605227 .yiv1941605227green {color:#628c2a;}#yiv1941605227 .yiv1941605227MsoNormal {margin:0 0 0 0;}#yiv1941605227 o {font-size:0;}#yiv1941605227 #yiv1941605227photos div {float:left;width:72px;}#yiv1941605227 #yiv1941605227photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1941605227 #yiv1941605227photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1941605227 #yiv1941605227reco-category {font-size:77%;}#yiv1941605227 #yiv1941605227reco-desc {font-size:77%;}#yiv1941605227 .yiv1941605227replbq {margin:4px;}#yiv1941605227 #yiv1941605227ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1941605227 #yiv1941605227ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1941605227 #yiv1941605227ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1941605227 #yiv1941605227ygrp-mlmsg select, #yiv1941605227 input, #yiv1941605227 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1941605227 #yiv1941605227ygrp-mlmsg pre, #yiv1941605227 code {font:115% monospace;}#yiv1941605227 #yiv1941605227ygrp-mlmsg * {line-height:1..22em;}#yiv1941605227 #yiv1941605227ygrp-mlmsg #yiv1941605227logo {padding-bottom:10px;}#yiv1941605227 #yiv1941605227ygrp-msg p a {font-family:Verdana;}#yiv1941605227 #yiv1941605227ygrp-msg p#yiv1941605227attach-count span {color:#1E66AE;font-weight:700;}#yiv1941605227 #yiv1941605227ygrp-reco #yiv1941605227reco-head {color:#ff7900;font-weight:700;}#yiv1941605227 #yiv1941605227ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1941605227 #yiv1941605227ygrp-sponsor #yiv1941605227ov li a {font-size:130%;text-decoration:none;}#yiv1941605227 #yiv1941605227ygrp-sponsor #yiv1941605227ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1941605227 #yiv1941605227ygrp-sponsor #yiv1941605227ov ul {margin:0;padding:0 0 0 8px;}#yiv1941605227 #yiv1941605227ygrp-text {font-family:Georgia;}#yiv1941605227 #yiv1941605227ygrp-text p {margin:0 0 1em 0;}#yiv1941605227 #yiv1941605227ygrp-text tt {font-size:120%;}#yiv1941605227 #yiv1941605227ygrp-vital ul li:last-child {border-right:none !important;}#yiv1941605227

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1c

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac

Wed Feb 7, 2018 2:15 pm (PST) . Posted by:

"Zerlinda Seismica" seismica

Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..

------
File lampiran dilepas dari email karena melebihi 250KB.
Sila disesuaikan lebih dulu ukuran filenya.

Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" menulis:

Hai Seismica, Koq ga ada lampirannya ?

Salam,
HK

Sent from Yahoo Mail on Android https://overview.mail.yahoo.com/mobile/?.src=Android

On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com [belajar-excel]
wrote:

Assalamualaikum wrwb

Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.

Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.

demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin

Wassalam

Seismica

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1d

Re: Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan

Wed Feb 7, 2018 7:42 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Seismica,Walaupun filenya belum bisa tampil krn melebihi kuota....Dalam membuat Rekap yang inputnya berbentuk database bisa menggunakan PivotTable asalkan ada kolom (kolom bantu) periode secara mingguan dan bulanan.Kalau mau dibuat Ytd bisa menggunakan fitur Calculated Item yang ada dalam PivotTable.
Salam,HK

Sent from Yahoo Mail on Android

On Thu, Feb 8, 2018 at 5:15, Zerlinda Seismica seismica@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:

Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..

------
File lampiran dilepas dari email karena melebihi 250KB.
Sila disesuaikan lebih dulu ukuran filenya.

Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" menulis:

Hai Seismica,Koq ga ada lampirannya ?
Salam,HK

Sent from Yahoo Mail on Android

On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com [belajar-excel] wrote: Assalamualaikum wrwb
Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.
demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
Wassalam
Seismica

#yiv8227610546 #yiv8227610546 -- #yiv8227610546ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8227610546 #yiv8227610546ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8227610546 #yiv8227610546ygrp-mkp #yiv8227610546hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8227610546 #yiv8227610546ygrp-mkp #yiv8227610546ads {margin-bottom:10px;}#yiv8227610546 #yiv8227610546ygrp-mkp .yiv8227610546ad {padding:0 0;}#yiv8227610546 #yiv8227610546ygrp-mkp .yiv8227610546ad p {margin:0;}#yiv8227610546 #yiv8227610546ygrp-mkp .yiv8227610546ad a {color:#0000ff;text-decoration:none;}#yiv8227610546 #yiv8227610546ygrp-sponsor #yiv8227610546ygrp-lc {font-family:Arial;}#yiv8227610546 #yiv8227610546ygrp-sponsor #yiv8227610546ygrp-lc #yiv8227610546hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8227610546 #yiv8227610546ygrp-sponsor #yiv8227610546ygrp-lc .yiv8227610546ad {margin-bottom:10px;padding:0 0;}#yiv8227610546 #yiv8227610546actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8227610546 #yiv8227610546activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8227610546 #yiv8227610546activity span {font-weight:700;}#yiv8227610546 #yiv8227610546activity span:first-child {text-transform:uppercase;}#yiv8227610546 #yiv8227610546activity span a {color:#5085b6;text-decoration:none;}#yiv8227610546 #yiv8227610546activity span span {color:#ff7900;}#yiv8227610546 #yiv8227610546activity span .yiv8227610546underline {text-decoration:underline;}#yiv8227610546 .yiv8227610546attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8227610546 .yiv8227610546attach div a {text-decoration:none;}#yiv8227610546 .yiv8227610546attach img {border:none;padding-right:5px;}#yiv8227610546 .yiv8227610546attach label {display:block;margin-bottom:5px;}#yiv8227610546 .yiv8227610546attach label a {text-decoration:none;}#yiv8227610546 blockquote {margin:0 0 0 4px;}#yiv8227610546 .yiv8227610546bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8227610546 .yiv8227610546bold a {text-decoration:none;}#yiv8227610546 dd.yiv8227610546last p a {font-family:Verdana;font-weight:700;}#yiv8227610546 dd.yiv8227610546last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8227610546 dd.yiv8227610546last p span.yiv8227610546yshortcuts {margin-right:0;}#yiv8227610546 div.yiv8227610546attach-table div div a {text-decoration:none;}#yiv8227610546 div.yiv8227610546attach-table {width:400px;}#yiv8227610546 div.yiv8227610546file-title a, #yiv8227610546 div.yiv8227610546file-title a:active, #yiv8227610546 div.yiv8227610546file-title a:hover, #yiv8227610546 div.yiv8227610546file-title a:visited {text-decoration:none;}#yiv8227610546 div.yiv8227610546photo-title a, #yiv8227610546 div.yiv8227610546photo-title a:active, #yiv8227610546 div.yiv8227610546photo-title a:hover, #yiv8227610546 div.yiv8227610546photo-title a:visited {text-decoration:none;}#yiv8227610546 div#yiv8227610546ygrp-mlmsg #yiv8227610546ygrp-msg p a span.yiv8227610546yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8227610546 .yiv8227610546green {color:#628c2a;}#yiv8227610546 .yiv8227610546MsoNormal {margin:0 0 0 0;}#yiv8227610546 o {font-size:0;}#yiv8227610546 #yiv8227610546photos div {float:left;width:72px;}#yiv8227610546 #yiv8227610546photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8227610546 #yiv8227610546photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8227610546 #yiv8227610546reco-category {font-size:77%;}#yiv8227610546 #yiv8227610546reco-desc {font-size:77%;}#yiv8227610546 .yiv8227610546replbq {margin:4px;}#yiv8227610546 #yiv8227610546ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8227610546 #yiv8227610546ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8227610546 #yiv8227610546ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8227610546 #yiv8227610546ygrp-mlmsg select, #yiv8227610546 input, #yiv8227610546 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8227610546 #yiv8227610546ygrp-mlmsg pre, #yiv8227610546 code {font:115% monospace;}#yiv8227610546 #yiv8227610546ygrp-mlmsg * {line-height:1.22em;}#yiv8227610546 #yiv8227610546ygrp-mlmsg #yiv8227610546logo {padding-bottom:10px;}#yiv8227610546 #yiv8227610546ygrp-msg p a {font-family:Verdana;}#yiv8227610546 #yiv8227610546ygrp-msg p#yiv8227610546attach-count span {color:#1E66AE;font-weight:700;}#yiv8227610546 #yiv8227610546ygrp-reco #yiv8227610546reco-head {color:#ff7900;font-weight:700;}#yiv8227610546 #yiv8227610546ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8227610546 #yiv8227610546ygrp-sponsor #yiv8227610546ov li a {font-size:130%;text-decoration:none;}#yiv8227610546 #yiv8227610546ygrp-sponsor #yiv8227610546ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8227610546 #yiv8227610546ygrp-sponsor #yiv8227610546ov ul {margin:0;padding:0 0 0 8px;}#yiv8227610546 #yiv8227610546ygrp-text {font-family:Georgia;}#yiv8227610546 #yiv8227610546ygrp-text p {margin:0 0 1em 0;}#yiv8227610546 #yiv8227610546ygrp-text tt {font-size:120%;}#yiv8227610546 #yiv8227610546ygrp-vital ul li:last-child {border-right:none !important;}#yiv8227610546

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1e

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac

Thu Feb 8, 2018 3:32 am (PST) . Posted by:

"Zerlinda Seismica" seismica

Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini padahal aslinya datanya agak banyak dan banyak sheet...kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan pak HK...
Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake macro heheh.berharap jika yg saya maksud bisa diselesaikan dengan macro bisa mengurangi memory...secara garis besar tujuan saya sudah closed dengan pivot, akantapi belum input aja datanya sudah lumayan gede gara gara pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum dipake..

demikian Pak HK..mohon dibantu lagi ya..
SalamSeismica

Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

#yiv5080222344 #yiv5080222344 -- #yiv5080222344 .yiv5080222344ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5080222344 div.yiv5080222344ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5080222344 div.yiv5080222344photo-title a, #yiv5080222344 div.yiv5080222344photo-title a:active, #yiv5080222344 div.yiv5080222344photo-title a:hover, #yiv5080222344 div.yiv5080222344photo-title a:visited {text-decoration:none;}#yiv5080222344 div.yiv5080222344attach-table div.yiv5080222344attach-row {clear:both;}#yiv5080222344 div.yiv5080222344attach-table div.yiv5080222344attach-row div {float:left;}#yiv5080222344 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5080222344 div.yiv5080222344ygrp-file {width:30px;}#yiv5080222344 div.yiv5080222344attach-table div.yiv5080222344attach-row div div a {text-decoration:none;}#yiv5080222344 div.yiv5080222344attach-table div.yiv5080222344attach-row div div span {font-weight:normal;}#yiv5080222344 div.yiv5080222344ygrp-file-title {font-weight:bold;}#yiv5080222344 #yiv5080222344 #yiv5080222344 #yiv5080222344 --#yiv5080222344ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5080222344 #yiv5080222344ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5080222344 #yiv5080222344ygrp-mkp #yiv5080222344hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5080222344 #yiv5080222344ygrp-mkp #yiv5080222344ads {margin-bottom:10px;}#yiv5080222344 #yiv5080222344ygrp-mkp .yiv5080222344ad {padding:0 0;}#yiv5080222344 #yiv5080222344ygrp-mkp .yiv5080222344ad p {margin:0;}#yiv5080222344 #yiv5080222344ygrp-mkp .yiv5080222344ad a {color:#0000ff;text-decoration:none;}#yiv5080222344

Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..

------
File lampiran dilepas dari email karena melebihi 250KB.
Sila disesuaikan lebih dulu ukuran filenya.

Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" menulis:

#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 -- #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a:active, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a:hover, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a:visited {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-row {clear:both;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-row div {float:left;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-file {width:30px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-row div div a {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-row div div span {font-weight:normal;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-file-title {font-weight:bold;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 --#yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5080222344ygrps-yiv-1181582178yiv9642594938hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5080222344ygrps-yiv-1181582178yiv9642594938ads {margin-bottom:10px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad {padding:0 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad p {margin:0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad a {color:#0000ff;text-decoration:none;}

Hai Seismica,Koq ga ada lampirannya ?
Salam,HK

Sent from Yahoo Mail on Android

On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com [belajar-excel] wrote: Assalamualaikum wrwb
Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.
demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
Wassalam
Seismica
#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 -- #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5080222344ygrps-yiv-1181582178yiv9642594938hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5080222344ygrps-yiv-1181582178yiv9642594938ads {margin-bottom:10px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad {padding:0 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad p {margin:0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad a {color:#0000ff;text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-lc {font-family:Arial;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-lc #yiv5080222344ygrps-yiv-1181582178yiv9642594938hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-lc .yiv5080222344ygrps-yiv-1181582178yiv9642594938ad {margin-bottom:10px;padding:0 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938activity span {font-weight:700;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938activity span:first-child {text-transform:uppercase;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938activity span a {color:#5085b6;text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938activity span span {color:#ff7900;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938activity span .yiv5080222344ygrps-yiv-1181582178yiv9642594938underline {text-decoration:underline;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938attach div a {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938attach img {border:none;padding-right:5px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938attach label {display:block;margin-bottom:5px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938attach label a {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 blockquote {margin:0 0 0 4px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938bold a {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 dd.yiv5080222344ygrps-yiv-1181582178yiv9642594938last p a {font-family:Verdana;font-weight:700;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 dd.yiv5080222344ygrps-yiv-1181582178yiv9642594938last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 dd.yiv5080222344ygrps-yiv-1181582178yiv9642594938last p span.yiv5080222344ygrps-yiv-1181582178yiv9642594938yshortcuts {margin-right:0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-table div div a {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-table {width:400px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938file-title a, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938file-title a:active, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938file-title a:hover, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938file-title a:visited {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a:active, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a:hover, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div.yiv5080222344ygrps-yiv-1181582178yiv9642594938photo-title a:visited {text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 div#yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-msg p a span.yiv5080222344ygrps-yiv-1181582178yiv9642594938yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938green {color:#628c2a;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938MsoNormal {margin:0 0 0 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 o {font-size:0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938photos div {float:left;width:72px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938reco-category {font-size:77%;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938reco-desc {font-size:77%;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 .yiv5080222344ygrps-yiv-1181582178yiv9642594938replbq {margin:4px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg select, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 input, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg pre, #yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 code {font:115% monospace;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg * {line-height:1.22em;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg #yiv5080222344ygrps-yiv-1181582178yiv9642594938logo {padding-bottom:10px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-msg p a {font-family:Verdana;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-msg p#yiv5080222344ygrps-yiv-1181582178yiv9642594938attach-count span {color:#1E66AE;font-weight:700;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-reco #yiv5080222344ygrps-yiv-1181582178yiv9642594938reco-head {color:#ff7900;font-weight:700;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5080222344ygrps-yiv-1181582178yiv9642594938ov li a {font-size:130%;text-decoration:none;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5080222344ygrps-yiv-1181582178yiv9642594938ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5080222344ygrps-yiv-1181582178yiv9642594938ov ul {margin:0;padding:0 0 0 8px;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-text {font-family:Georgia;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-text p {margin:0 0 1em 0;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-text tt {font-size:120%;}#yiv5080222344 #yiv5080222344ygrps-yiv-1181582178 #yiv5080222344ygrps-yiv-1181582178yiv9642594938 #yiv5080222344ygrps-yiv-1181582178yiv9642594938ygrp-vital ul li:last-child {border-right:none !important;}

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1f

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro

Thu Feb 8, 2018 4:45 am (PST) . Posted by:

"lkm jktind" lkmjkt

Tanya Bu : apakah yg hendak di isi kolom B saja kah ?

Salam

Lukamn

On Thu, Feb 8, 2018 at 6:29 PM, Zerlinda Seismica seismica@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan
> sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini
> padahal aslinya datanya agak banyak dan banyak sheet...
> kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan
> pak HK...
>
> Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena
> ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake
> macro heheh.
> berharap jika yg saya maksud bisa diselesaikan dengan macro bisa
> mengurangi memory...secara garis besar tujuan saya sudah closed dengan
> pivot, akantapi belum input aja datanya sudah lumayan gede gara gara
> pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum
> dipake..
>
> demikian Pak HK..mohon dibantu lagi ya..
>
> Salam
> Seismica
>
>
>
> Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo..com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..
>
>
> ------
> File lampiran dilepas dari email karena melebihi 250KB.
> Sila disesuaikan lebih dulu ukuran filenya.
>
>
> Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi
> hendrikkarnadi@yahoo.com [belajar-excel]" menulis:
>
>
>
>
> Hai Seismica,
> Koq ga ada lampirannya ?
>
> Salam,
> HK
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com
> [belajar-excel]
> wrote:
>
> Assalamualaikum wrwb
>
> Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya
> seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum
> disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
> Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan
> dan Kumulatif seperti terlampir.
>
> demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
>
> Wassalam
>
> Seismica
>
>
>
>
>
>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1g

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac

Thu Feb 8, 2018 5:07 am (PST) . Posted by:

"Zerlinda Seismica" seismica

Yang nanti dinput kolom A , B dan C (sebenranya kolom A B dan C link ke cell lain) tapi tidak apa apa bisa dianggap input manual saja

Pada Kamis, 8 Februari 2018 20:32, "Zerlinda Seismica seismica@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

#yiv5277778132 #yiv5277778132 -- #yiv5277778132 .yiv5277778132ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5277778132 div.yiv5277778132ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5277778132 div.yiv5277778132photo-title a, #yiv5277778132 div.yiv5277778132photo-title a:active, #yiv5277778132 div.yiv5277778132photo-title a:hover, #yiv5277778132 div.yiv5277778132photo-title a:visited {text-decoration:none;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row {clear:both;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row div {float:left;}#yiv5277778132 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5277778132 div.yiv5277778132ygrp-file {width:30px;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row div div a {text-decoration:none;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row div div span {font-weight:normal;}#yiv5277778132 div.yiv5277778132ygrp-file-title {font-weight:bold;}#yiv5277778132 #yiv5277778132

Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini padahal aslinya datanya agak banyak dan banyak sheet...kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan pak HK...
Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake macro heheh.berharap jika yg saya maksud bisa diselesaikan dengan macro bisa mengurangi memory...secara garis besar tujuan saya sudah closed dengan pivot, akantapi belum input aja datanya sudah lumayan gede gara gara pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum dipake..

demikian Pak HK..mohon dibantu lagi ya..
SalamSeismica

Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo..com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

#yiv5277778132 -- .yiv5277778132ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5277778132 div.yiv5277778132ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5277778132 div.yiv5277778132photo-title a, #yiv5277778132 div.yiv5277778132photo-title a:active, #yiv5277778132 div.yiv5277778132photo-title a:hover, #yiv5277778132 div.yiv5277778132photo-title a:visited {text-decoration:none;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row {clear:both;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row div {float:left;}#yiv5277778132 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5277778132 div.yiv5277778132ygrp-file {width:30px;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row div div a {text-decoration:none;}#yiv5277778132 div.yiv5277778132attach-table div.yiv5277778132attach-row div div span {font-weight:normal;}#yiv5277778132 div.yiv5277778132ygrp-file-title {font-weight:bold;}#yiv5277778132 #yiv5277778132 --#yiv5277778132ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5277778132 #yiv5277778132ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5277778132 #yiv5277778132ygrp-mkp #yiv5277778132hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5277778132 #yiv5277778132ygrp-mkp #yiv5277778132ads {margin-bottom:10px;}#yiv5277778132 #yiv5277778132ygrp-mkp .yiv5277778132ad {padding:0 0;}#yiv5277778132 #yiv5277778132ygrp-mkp .yiv5277778132ad p {margin:0;}#yiv5277778132 #yiv5277778132ygrp-mkp .yiv5277778132ad a {color:#0000ff;text-decoration:none;}#yiv5277778132

Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..

------
File lampiran dilepas dari email karena melebihi 250KB.
Sila disesuaikan lebih dulu ukuran filenya.

Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" menulis:

#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 -- #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a:active, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a:hover, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a:visited {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-row {clear:both;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-row div {float:left;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-file {width:30px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-table div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-row div div a {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-table div..yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-row div div span {font-weight:normal;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-file-title {font-weight:bold;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 --#yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5277778132ygrps-yiv-1181582178yiv9642594938hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5277778132ygrps-yiv-1181582178yiv9642594938ads {margin-bottom:10px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5277778132ygrps-yiv-1181582178yiv9642594938ad {padding:0 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5277778132ygrps-yiv-1181582178yiv9642594938ad p {margin:0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5277778132ygrps-yiv-1181582178yiv9642594938ad a {color:#0000ff;text-decoration:none;}

Hai Seismica,Koq ga ada lampirannya ?
Salam,HK

Sent from Yahoo Mail on Android

On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com [belajar-excel] wrote: Assalamualaikum wrwb
Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.
demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
Wassalam
Seismica
#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 -- #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5277778132ygrps-yiv-1181582178yiv9642594938hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp #yiv5277778132ygrps-yiv-1181582178yiv9642594938ads {margin-bottom:10px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5277778132ygrps-yiv-1181582178yiv9642594938ad {padding:0 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5277778132ygrps-yiv-1181582178yiv9642594938ad p {margin:0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mkp .yiv5277778132ygrps-yiv-1181582178yiv9642594938ad a {color:#0000ff;text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-lc {font-family:Arial;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-lc #yiv5277778132ygrps-yiv-1181582178yiv9642594938hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-lc ..yiv5277778132ygrps-yiv-1181582178yiv9642594938ad {margin-bottom:10px;padding:0 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938activity span {font-weight:700;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938activity span:first-child {text-transform:uppercase;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938activity span a {color:#5085b6;text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938activity span span {color:#ff7900;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938activity span .yiv5277778132ygrps-yiv-1181582178yiv9642594938underline {text-decoration:underline;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938attach div a {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 ..yiv5277778132ygrps-yiv-1181582178yiv9642594938attach img {border:none;padding-right:5px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938attach label {display:block;margin-bottom:5px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938attach label a {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 blockquote {margin:0 0 0 4px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938bold a {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 dd.yiv5277778132ygrps-yiv-1181582178yiv9642594938last p a {font-family:Verdana;font-weight:700;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 dd.yiv5277778132ygrps-yiv-1181582178yiv9642594938last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 dd.yiv5277778132ygrps-yiv-1181582178yiv9642594938last p span.yiv5277778132ygrps-yiv-1181582178yiv9642594938yshortcuts {margin-right:0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-table div div a {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-table {width:400px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938file-title a, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938file-title a:active, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938file-title a:hover, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938file-title a:visited {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a:active, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a:hover, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div.yiv5277778132ygrps-yiv-1181582178yiv9642594938photo-title a:visited {text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 div#yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-msg p a span.yiv5277778132ygrps-yiv-1181582178yiv9642594938yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938green {color:#628c2a;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938MsoNormal {margin:0 0 0 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 o {font-size:0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938photos div {float:left;width:72px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938reco-category {font-size:77%;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938reco-desc {font-size:77%;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 .yiv5277778132ygrps-yiv-1181582178yiv9642594938replbq {margin:4px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg select, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 input, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg pre, #yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 code {font:115% monospace;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg * {line-height:1.22em;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-mlmsg #yiv5277778132ygrps-yiv-1181582178yiv9642594938logo {padding-bottom:10px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-msg p a {font-family:Verdana;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-msg p#yiv5277778132ygrps-yiv-1181582178yiv9642594938attach-count span {color:#1E66AE;font-weight:700;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-reco #yiv5277778132ygrps-yiv-1181582178yiv9642594938reco-head {color:#ff7900;font-weight:700;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5277778132ygrps-yiv-1181582178yiv9642594938ov li a {font-size:130%;text-decoration:none;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5277778132ygrps-yiv-1181582178yiv9642594938ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-sponsor #yiv5277778132ygrps-yiv-1181582178yiv9642594938ov ul {margin:0;padding:0 0 0 8px;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-text {font-family:Georgia;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-text p {margin:0 0 1em 0;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-text tt {font-size:120%;}#yiv5277778132 #yiv5277778132ygrps-yiv-1181582178 #yiv5277778132ygrps-yiv-1181582178yiv9642594938 #yiv5277778132ygrps-yiv-1181582178yiv9642594938ygrp-vital ul li:last-child {border-right:none !important;}

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1h

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro

Thu Feb 8, 2018 5:21 am (PST) . Posted by:

"lkm jktind" lkmjkt

kalau gitu , bagaimana kirim formulanya di email.

Misal
B5 = formula nya apa ?
C5 = formula nya apa ?
D5 = formulanya apa ?
E5 =
F6 =

mungkin bisa di kira kira .

Untuk di buatkan macronya.

Salam

Lukman

On Thu, Feb 8, 2018 at 8:02 PM, Zerlinda Seismica seismica@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Yang nanti dinput kolom A , B dan C (sebenranya kolom A B dan C link ke
> cell lain) tapi tidak apa apa bisa dianggap input manual saja
>
>
> Pada Kamis, 8 Februari 2018 20:32, "Zerlinda Seismica seismica@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan
> sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini
> padahal aslinya datanya agak banyak dan banyak sheet...
> kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan
> pak HK...
>
> Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena
> ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake
> macro heheh.
> berharap jika yg saya maksud bisa diselesaikan dengan macro bisa
> mengurangi memory...secara garis besar tujuan saya sudah closed dengan
> pivot, akantapi belum input aja datanya sudah lumayan gede gara gara
> pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum
> dipake..
>
> demikian Pak HK..mohon dibantu lagi ya..
>
> Salam
> Seismica
>
>
>
> Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo...com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..
>
>
> ------
> File lampiran dilepas dari email karena melebihi 250KB.
> Sila disesuaikan lebih dulu ukuran filenya.
>
>
> Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi
> hendrikkarnadi@yahoo.com [belajar-excel]" menulis:
>
>
>
>
> Hai Seismica,
> Koq ga ada lampirannya ?
>
> Salam,
> HK
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com
> [belajar-excel]
> wrote:
>
> Assalamualaikum wrwb
>
> Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya
> seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum
> disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
> Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan
> dan Kumulatif seperti terlampir.
>
> demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
>
> Wassalam
>
> Seismica
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1i

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro

Thu Feb 8, 2018 6:50 am (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Seis,

Bagian mana yang sulit diakomodir tersebut ya ?

Regards,
Kid

On Thu, Feb 8, 2018 at 6:29 PM, Zerlinda Seismica seismica@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan
> sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini
> padahal aslinya datanya agak banyak dan banyak sheet...
> kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan
> pak HK...
>
> Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena
> ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake
> macro heheh.
> berharap jika yg saya maksud bisa diselesaikan dengan macro bisa
> mengurangi memory...secara garis besar tujuan saya sudah closed dengan
> pivot, akantapi belum input aja datanya sudah lumayan gede gara gara
> pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum
> dipake..
>
> demikian Pak HK..mohon dibantu lagi ya..
>
> Salam
> Seismica
>
>
>
> Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo..com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..
>
>
> ------
> File lampiran dilepas dari email karena melebihi 250KB.
> Sila disesuaikan lebih dulu ukuran filenya.
>
>
> Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi
> hendrikkarnadi@yahoo.com [belajar-excel]" menulis:
>
>
>
>
> Hai Seismica,
> Koq ga ada lampirannya ?
>
> Salam,
> HK
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com
> [belajar-excel]
> wrote:
>
> Assalamualaikum wrwb
>
> Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya
> seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum
> disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
> Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan
> dan Kumulatif seperti terlampir.
>
> demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
>
> Wassalam
>
> Seismica
>
>
>
>
>
>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1j

Bls: [belajar-excel] Rekap Mingguan Bulanan dan Kumulatif dengan Mac

Thu Feb 8, 2018 5:07 pm (PST) . Posted by:

"Zerlinda Seismica" seismica

Berikut terlampir yang dimaksud mas....alhamduliliah kalo kolom A B C bisa dimacro kan heheh...suwun ya...

Pada Kamis, 8 Februari 2018 23:50, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

#yiv5181467318 #yiv5181467318 -- #yiv5181467318 .yiv5181467318ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5181467318 div.yiv5181467318ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv5181467318 div.yiv5181467318photo-title a, #yiv5181467318 div.yiv5181467318photo-title a:active, #yiv5181467318 div.yiv5181467318photo-title a:hover, #yiv5181467318 div.yiv5181467318photo-title a:visited {text-decoration:none;}#yiv5181467318 div.yiv5181467318attach-table div.yiv5181467318attach-row {clear:both;}#yiv5181467318 div.yiv5181467318attach-table div.yiv5181467318attach-row div {float:left;}#yiv5181467318 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5181467318 div.yiv5181467318ygrp-file {width:30px;}#yiv5181467318 div.yiv5181467318attach-table div.yiv5181467318attach-row div div a {text-decoration:none;}#yiv5181467318 div.yiv5181467318attach-table div.yiv5181467318attach-row div div span {font-weight:normal;}#yiv5181467318 div.yiv5181467318ygrp-file-title {font-weight:bold;}#yiv5181467318 #yiv5181467318 #yiv5181467318 #yiv5181467318 --#yiv5181467318ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5181467318 #yiv5181467318ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5181467318 #yiv5181467318ygrp-mkp #yiv5181467318hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5181467318 #yiv5181467318ygrp-mkp #yiv5181467318ads {margin-bottom:10px;}#yiv5181467318 #yiv5181467318ygrp-mkp .yiv5181467318ad {padding:0 0;}#yiv5181467318 #yiv5181467318ygrp-mkp .yiv5181467318ad p {margin:0;}#yiv5181467318 #yiv5181467318ygrp-mkp .yiv5181467318ad a {color:#0000ff;text-decoration:none;}#yiv5181467318

Hai Seis,

Bagian mana yang sulit diakomodir tersebut ya ?

Regards,
Kid

On Thu, Feb 8, 2018 at 6:29 PM, Zerlinda Seismica seismica@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini padahal aslinya datanya agak banyak dan banyak sheet...kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan pak HK...
Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake macro heheh.berharap jika yg saya maksud bisa diselesaikan dengan macro bisa mengurangi memory...secara garis besar tujuan saya sudah closed dengan pivot, akantapi belum input aja datanya sudah lumayan gede gara gara pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum dipake..

demikian Pak HK..mohon dibantu lagi ya..
SalamSeismica

Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo...com [belajar-excel]" <belajar-excel@yahoogroups.com > menulis:

Hehe....mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..

------
File lampiran dilepas dari email karena melebihi 250KB.
Sila disesuaikan lebih dulu ukuran filenya.

Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" menulis:

Hai Seismica,Koq ga ada lampirannya ?
Salam,HK

Sent from Yahoo Mail on Android

On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com [belajar-excel] wrote: Assalamualaikum wrwb
Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan dan Kumulatif seperti terlampir.
demikian bapak ibu semoga tetap dalam semangat dan sehat..aamiin
Wassalam
Seismica

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

1k

Re: Rekap Mingguan Bulanan dan Kumulatif dengan Macro

Thu Feb 8, 2018 5:33 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Masalahnya supaya tidak perlu menyediakan baris formula yang banyak ya..
Jadi setiap kali input data, maka terbuat sendiri formulanya ? Begitu bukan
?
Coba Excel Table Object. Tidak perlu VBA untuk hal seperti ini.

Tentang ukuran file yang besar : (urutan penyebab)
1. gambar (image) yang tidak di-compress
2. link ke external workbook, terutama sebagai Named Range (lihat di daftar
nama range, yaitu ribbon Formulas -> grup menu Defined Range -> Name
Manager)
3. pivot table yang menyimpan data sumbernya di dalam pivot cache
4. banyak sekali custom styles (lihat daftar styles di ribbon Home -> grup
menu Styles -> styles list [di kanan menu Format as table])
5. banyak sekali shapes lainnya (form controls, shapes selain picture,
activex controls)
6. ada cells tak terpakai jauh di bawah atau kanan sheet diluar area data
7. banyak cells berformula tapi belum ada datanya
8. userforms beserta script VBA
9. banyak cells berisi conditional formatting
10. banyak cells berisi data terpakai

Beberapa hal tersebut di atas, juga dapat memperlambat gerak cells maupun
proses kalkulasi.

Bukankah file lampiran yang berisi pivot table yang lalu berisi lebih
banyak data dibanding file lampiran Anda ? Tapi ukuran filenya tidak lebih
dari 250KB dan formulanya tidak berat. Lengkap dengan outputnya juga.

Terlampir contoh Excel Table Object.

Regards,
Kid

2018-02-09 7:54 GMT+07:00 Zerlinda Seismica seismica@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Berikut terlampir yang dimaksud mas....alhamduliliah kalo kolom A B C bisa
> dimacro kan heheh...suwun ya...
>
>
> Pada Kamis, 8 Februari 2018 23:50, "'Mr. Kid' mr.nmkid@gmail.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Hai Seis,
>
> Bagian mana yang sulit diakomodir tersebut ya ?
>
> Regards,
> Kid
>
>
>
> On Thu, Feb 8, 2018 at 6:29 PM, Zerlinda Seismica seismica@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
> Pantesan pak HK filenya 500 Kb...hehe jadi sesuai dengan maksud dan tujuan
> sy mohon bantuan ini..ini baru satu sheet contoh yg sy krim via milis ini
> padahal aslinya datanya agak banyak dan banyak sheet...
> kembali saya kirimkan lampirannya pak HK...mohon dibantu ya bapak ibu dan
> pak HK...
>
> Untuk pivot sudah sy terapkan sesuai petujuk Mr Kid..akan tetapi karena
> ada bagian yang sulit diakomodir dengan pivot dengan sangat berat saya pake
> macro heheh.
> berharap jika yg saya maksud bisa diselesaikan dengan macro bisa
> mengurangi memory...secara garis besar tujuan saya sudah closed dengan
> pivot, akantapi belum input aja datanya sudah lumayan gede gara gara
> pengaruh formula yg sudah saya siapkan lebih awal meskipun itu belum
> dipake..
>
> demikian Pak HK..mohon dibantu lagi ya..
>
> Salam
> Seismica
>
>
>
> Pada Kamis, 8 Februari 2018 7:15, "Zerlinda Seismica seismica@yahoo..com
> [belajar-excel]" <belajar-excel@yahoogroups.com > menulis:
>
>
>
>
> Hehe...mohon maaf kelupaan tertinggal kayakny pak HK..saya lampirkan..
>
>
> ------
> File lampiran dilepas dari email karena melebihi 250KB.
> Sila disesuaikan lebih dulu ukuran filenya.
>
>
> Pada Rabu, 7 Februari 2018 23:15, "hendrik karnadi
> hendrikkarnadi@yahoo.com [belajar-excel]" menulis:
>
>
>
>
> Hai Seismica,
> Koq ga ada lampirannya ?
>
> Salam,
> HK
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Wed, Feb 7, 2018 at 16:46, Zerlinda Seismica seismica@yahoo.com
> [belajar-excel]
> wrote:
>
> Assalamualaikum wrwb
>
> Seperti bisa muncul dengan pertanyaan..saya mempunyai data yang isinya
> seperti terlampir. Sudah saya kerjakan dengan formula akan tetapi belum
> disi apa2 sdh besar karena saya sdh menyediakan formula untuk 2 tahun.
> Kiranya bapak ibu bisa membantu dengan macro untuk Rekap Mingguan Bulanan
> dan Kumulatif seperti terlampir.
>
> demikian bapak ibu semoga tetap dalam semangat dan sehat...aamiin
>
> Wassalam
>
> Seismica
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

2a

excel versi 2010.

Wed Feb 7, 2018 5:22 pm (PST) . Posted by:

"lkm jktind" lkmjkt

Saya memakai excel 2010 64 Bit.

Ternyata jumlah row nya 1.002.006 baris. masih bisa ber fungsi.

entah berapa maksimum jumlah row ?

Salam

Lukman

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Re: excel versi 2010.

Wed Feb 7, 2018 7:31 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Lukman,Jumlah row 1048576, tapi kalau file yang dibuka Excel 97-2003(.xls) jumlah baris 65536.
Salam,HK

Sent from Yahoo Mail on Android

On Thu, Feb 8, 2018 at 8:22, lkm jktind lkmjktind@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:

Saya memakai excel 2010 64 Bit.

Ternyata jumlah row nya 1.002.006 baris. masih bisa ber fungsi.

entah berapa maksimum jumlah row ?

Salam

Lukman
#yiv5210122279 #yiv5210122279 -- #yiv5210122279ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5210122279 #yiv5210122279ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5210122279 #yiv5210122279ygrp-mkp #yiv5210122279hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5210122279 #yiv5210122279ygrp-mkp #yiv5210122279ads {margin-bottom:10px;}#yiv5210122279 #yiv5210122279ygrp-mkp .yiv5210122279ad {padding:0 0;}#yiv5210122279 #yiv5210122279ygrp-mkp .yiv5210122279ad p {margin:0;}#yiv5210122279 #yiv5210122279ygrp-mkp .yiv5210122279ad a {color:#0000ff;text-decoration:none;}#yiv5210122279 #yiv5210122279ygrp-sponsor #yiv5210122279ygrp-lc {font-family:Arial;}#yiv5210122279 #yiv5210122279ygrp-sponsor #yiv5210122279ygrp-lc #yiv5210122279hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5210122279 #yiv5210122279ygrp-sponsor #yiv5210122279ygrp-lc .yiv5210122279ad {margin-bottom:10px;padding:0 0;}#yiv5210122279 #yiv5210122279actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5210122279 #yiv5210122279activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5210122279 #yiv5210122279activity span {font-weight:700;}#yiv5210122279 #yiv5210122279activity span:first-child {text-transform:uppercase;}#yiv5210122279 #yiv5210122279activity span a {color:#5085b6;text-decoration:none;}#yiv5210122279 #yiv5210122279activity span span {color:#ff7900;}#yiv5210122279 #yiv5210122279activity span .yiv5210122279underline {text-decoration:underline;}#yiv5210122279 .yiv5210122279attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5210122279 .yiv5210122279attach div a {text-decoration:none;}#yiv5210122279 .yiv5210122279attach img {border:none;padding-right:5px;}#yiv5210122279 .yiv5210122279attach label {display:block;margin-bottom:5px;}#yiv5210122279 .yiv5210122279attach label a {text-decoration:none;}#yiv5210122279 blockquote {margin:0 0 0 4px;}#yiv5210122279 .yiv5210122279bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5210122279 .yiv5210122279bold a {text-decoration:none;}#yiv5210122279 dd.yiv5210122279last p a {font-family:Verdana;font-weight:700;}#yiv5210122279 dd.yiv5210122279last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5210122279 dd.yiv5210122279last p span.yiv5210122279yshortcuts {margin-right:0;}#yiv5210122279 div.yiv5210122279attach-table div div a {text-decoration:none;}#yiv5210122279 div.yiv5210122279attach-table {width:400px;}#yiv5210122279 div.yiv5210122279file-title a, #yiv5210122279 div.yiv5210122279file-title a:active, #yiv5210122279 div.yiv5210122279file-title a:hover, #yiv5210122279 div.yiv5210122279file-title a:visited {text-decoration:none;}#yiv5210122279 div.yiv5210122279photo-title a, #yiv5210122279 div.yiv5210122279photo-title a:active, #yiv5210122279 div.yiv5210122279photo-title a:hover, #yiv5210122279 div.yiv5210122279photo-title a:visited {text-decoration:none;}#yiv5210122279 div#yiv5210122279ygrp-mlmsg #yiv5210122279ygrp-msg p a span.yiv5210122279yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5210122279 .yiv5210122279green {color:#628c2a;}#yiv5210122279 .yiv5210122279MsoNormal {margin:0 0 0 0;}#yiv5210122279 o {font-size:0;}#yiv5210122279 #yiv5210122279photos div {float:left;width:72px;}#yiv5210122279 #yiv5210122279photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5210122279 #yiv5210122279photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5210122279 #yiv5210122279reco-category {font-size:77%;}#yiv5210122279 #yiv5210122279reco-desc {font-size:77%;}#yiv5210122279 .yiv5210122279replbq {margin:4px;}#yiv5210122279 #yiv5210122279ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5210122279 #yiv5210122279ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5210122279 #yiv5210122279ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5210122279 #yiv5210122279ygrp-mlmsg select, #yiv5210122279 input, #yiv5210122279 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5210122279 #yiv5210122279ygrp-mlmsg pre, #yiv5210122279 code {font:115% monospace;}#yiv5210122279 #yiv5210122279ygrp-mlmsg * {line-height:1..22em;}#yiv5210122279 #yiv5210122279ygrp-mlmsg #yiv5210122279logo {padding-bottom:10px;}#yiv5210122279 #yiv5210122279ygrp-msg p a {font-family:Verdana;}#yiv5210122279 #yiv5210122279ygrp-msg p#yiv5210122279attach-count span {color:#1E66AE;font-weight:700;}#yiv5210122279 #yiv5210122279ygrp-reco #yiv5210122279reco-head {color:#ff7900;font-weight:700;}#yiv5210122279 #yiv5210122279ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5210122279 #yiv5210122279ygrp-sponsor #yiv5210122279ov li a {font-size:130%;text-decoration:none;}#yiv5210122279 #yiv5210122279ygrp-sponsor #yiv5210122279ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5210122279 #yiv5210122279ygrp-sponsor #yiv5210122279ov ul {margin:0;padding:0 0 0 8px;}#yiv5210122279 #yiv5210122279ygrp-text {font-family:Georgia;}#yiv5210122279 #yiv5210122279ygrp-text p {margin:0 0 1em 0;}#yiv5210122279 #yiv5210122279ygrp-text tt {font-size:120%;}#yiv5210122279 #yiv5210122279ygrp-vital ul li:last-child {border-right:none !important;}#yiv5210122279

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

Re: excel versi 2010.

Wed Feb 7, 2018 9:42 pm (PST) . Posted by:

"lkm jktind" lkmjkt

oh iya . berarti nga lama lagi sudah nga muat.

(mudah mudahan bisa lebih)

trims .

salam

Lukman

On Thu, Feb 8, 2018 at 10:31 AM, hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Hai Lukman,
> Jumlah row 1048576, tapi kalau file yang dibuka Excel 97-2003(.xls) jumlah
> baris 65536.
>
> Salam,
> HK
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
> On Thu, Feb 8, 2018 at 8:22, lkm jktind lkmjktind@gmail.com
> [belajar-excel]
> <belajar-excel@yahoogroups.com> wrote:
>
>
> Saya memakai excel 2010 64 Bit.
>
> Ternyata jumlah row nya 1.002.006 baris. masih bisa ber fungsi.
>
> entah berapa maksimum jumlah row ?
>
>
> Salam
>
> Lukman
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3a

Re: Show/Hide Field List pada Pivot

Wed Feb 7, 2018 10:51 pm (PST) . Posted by:

"Stephen Saputro"

Terima kasih banyak Pak Kid untuk bantuannya. Ternyata setelah di pikir2,
effortnya jauh lebih besar kalau harus di buat seperti scenario saya yang
pertama, padahal ada jalan yang lebih sederhana hehehe

2018-02-06 19:38 GMT+07:00 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Hai Saputro,
>
> Tentang :
> 1. Bisakah untuk show/hide field list pada pivot di buat veryhiden ?
> supaya reportnya tidak bisa di utak atik oleh user lain
> > Sekadar menonaktifkan ribbon untuk show/hide field list :
> Cara 1 : pakai custom ui tanpa VBA
> Cara 2 : pakai VBA (tapi tidak berguna jika user mengatur security
> macro menjadi disable)
> Cara 3 : pakai custom ui dan VBA (tapi tidak berguna jika user mengatur
> security macro menjadi disable)
> *** Context menu untuk show/hide field list bisa sekalian diatur
> *** Ingat, sekadar untuk mempersulit saja, BUKAN mencegah.
> *** Untuk mengubah layout pivot table bisa dengan Expand (menambah
> field) lalu setelah itu di drag n move
>
> > Mencegah user mengubah layout :
> 1. sediakan tombol refresh -> isi dengan script untuk refresh dengan
> urutan proses : unprotect sheet -> refresh pivot -> protect sheet
> 2. protect sheet
> *** Jika user men-disable security macro, maka user tidak bisa refresh.
>
> 2. Pada tabel pivot, biasanya kalau di double klik di salah satu
> amountnya, maka excel langsung mengarahkan ke source dari angka tsb. Apakah
> ini bisa di non aktivkan ? saya sudah coba dengan protect cell, hanya saja
> ketika melakukan refresh, macronya tidak dapat berjalan.
> > Pivot table options -> tab Data -> hilangkan centang dari Enable Show
> Detail
> *** tapi user bisa mencentang sendiri
> > Pakai VBA : event before double click -> set Cancel menjadi bernilai
> false
> *** tapi tidak berguna jika user mengatur security macro menjadi
> disable
>
> imho,
> Bagaimana jika kembali ke konsep dasar :
> 1. Ada sebuah report template berisi seluruh layout pivot table yang resmi
> (sah sebagai report)
> 2. user lain hanya diberi hak copy, bukan hak write ke file report template
> 3. user boleh meng-copy report template ke komputernya sendiri dan
> mengubah sesuka hatinya, tetapi itu tidak resmi (tidak sah)
> 4. semua report resmi adalah yang dihasilkan report template (bukan buatan
> user dengan file copy-an milik user)
>
> Kebiasaan pengguna Excel :
> ada 1 file buatan si A di komputer X, maka si B, C, D bisa buka file
> buatan si A dikomputer X.
> akhirnya si A berpusing ria memikirkan caranya memproteksi si file
> buatannya agar tidak diubah si B,C,D. (buang-buang energi).
>
> Padahal, simpel saja...
> Hai B, C, D, Anda sekalian tidak bisa membukanya, apalagi mengubahnya.
> Jika Anda sekalian ingin mengubahnya, maka saya berikan hak copy. Anda
> boleh meng-copy file tersebut. Lalu Anda ubah sesukanya di komputer Anda
> sendiri.
> Tapi ingat ya... syarat dan ketentuan berlaku.... rilis resmi tetap dari
> saya.
>
> hehehe...
>
> Regards,
> Kid
>
>
>
> 2018-02-06 11:33 GMT+07:00 Stephen Saputro stephensaputro@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>>
>>
>> Selamat siang rekan2 semuanya,
>>
>> Mohon kiranya dapat di bantu masalah saya :
>>
>> 1.. Bisakah untuk show/hide field list pada pivot di buat veryhiden ?
>> supaya reportnya tidak bisa di utak atik oleh user lain
>>
>> 2.. Pada tabel pivot, biasanya kalau di double klik di salah satu
>> amountnya, maka excel langsung mengarahkan ke source dari angka tsb. Apakah
>> ini bisa di non aktivkan ? saya sudah coba dengan protect cell, hanya saja
>> ketika melakukan refresh, macronya tidak dapat berjalan.
>>
>>
>> Terima kasih
>>
>>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

============================================================
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
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

Kamis, 08 Februari 2018

15 Messages

Messages

1a

Wed Feb 7, 2018 1:46 am (PST) . Posted by:

1b

Wed Feb 7, 2018 6:15 am (PST) . Posted by:

1c

Wed Feb 7, 2018 2:15 pm (PST) . Posted by:

1d

Wed Feb 7, 2018 7:42 pm (PST) . Posted by:

1e

Thu Feb 8, 2018 3:32 am (PST) . Posted by:

1f

Thu Feb 8, 2018 4:45 am (PST) . Posted by:

1g

Thu Feb 8, 2018 5:07 am (PST) . Posted by:

1h

Thu Feb 8, 2018 5:21 am (PST) . Posted by:

1i

Thu Feb 8, 2018 6:50 am (PST) . Posted by:

1j

Thu Feb 8, 2018 5:07 pm (PST) . Posted by:

1k

Thu Feb 8, 2018 5:33 pm (PST) . Posted by:

2a

Wed Feb 7, 2018 5:22 pm (PST) . Posted by:

2b

Wed Feb 7, 2018 7:31 pm (PST) . Posted by:

2c

Wed Feb 7, 2018 9:42 pm (PST) . Posted by:

3a

Wed Feb 7, 2018 10:51 pm (PST) . Posted by:

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me