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   
  • [belajar-excel] R... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
    • Re: [belajar... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
      • Bls: [be... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
        • Re: ... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
        • Bls:... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
          • ... lkm jktind lkmjkt...@gmail.com [belajar-excel]
          • ... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
            • ... lkm jktind lkmjkt...@gmail.com [belajar-excel]
          • ... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
            • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
              • ... Zerlinda Seismica seism...@yahoo.com [belajar-excel]
                • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... Zerlinda Seismica seism...@yahoo.com [belajar-excel]

Kirim email ke