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
