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 seism...@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 hendrikkarn...@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 seism...@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