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