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
