Hai Achmad Adi,
Langkah2nya adalah sbb:1. Format dan penulisan pada Sheet "data" a. Field
SPPB harus dijadikan text dulu dengan menulis formula =TEXT(B4,"????") di kolom
kosong, lalu copy ke bawah. Formula ini dicopy paste value ke kolom
B (mulai B4 dst.).
b. Penulisan tanggal harus konsiten.2. Hapus kolom kosong (kolom I).3.
Blok sel A3 s/d M 161 (sel terakhir).4. Klik Insert Table (My Table has headers
dalam keadaan tercentang). Komputer akan memberi nama tabel secara
otomatis.5. Insert PivotTable dengan nama tabel tsb. Hilangkan SubTotal yang
tidak diperlukan dengan mencabut centang Sub Total pada kolom ybs.6.
Sesuaikan format PivotTablenya.
Selamat mencoba.
Salam,HK
From: "achmad adi [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Thursday, 3 November 2016, 15:37
Subject: [belajar-excel] rekap data di sheet lain
dear master sebelumnya saya ucapkan terimakasihmasalah demi masalah
pekerjaan saya teratasi di BE ini,,dan tidak bosen bosennya membantu saya,,
kali ini saya meminta bantuanuntuk masalah rekap data di sheet lainbaik
menggunakan pivot or macrofile saya lampirkan,,,
#yiv9915648380 -- #yiv9915648380ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9915648380
#yiv9915648380ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9915648380
#yiv9915648380ygrp-mkp #yiv9915648380hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9915648380 #yiv9915648380ygrp-mkp #yiv9915648380ads
{margin-bottom:10px;}#yiv9915648380 #yiv9915648380ygrp-mkp .yiv9915648380ad
{padding:0 0;}#yiv9915648380 #yiv9915648380ygrp-mkp .yiv9915648380ad p
{margin:0;}#yiv9915648380 #yiv9915648380ygrp-mkp .yiv9915648380ad a
{color:#0000ff;text-decoration:none;}#yiv9915648380 #yiv9915648380ygrp-sponsor
#yiv9915648380ygrp-lc {font-family:Arial;}#yiv9915648380
#yiv9915648380ygrp-sponsor #yiv9915648380ygrp-lc #yiv9915648380hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9915648380
#yiv9915648380ygrp-sponsor #yiv9915648380ygrp-lc .yiv9915648380ad
{margin-bottom:10px;padding:0 0;}#yiv9915648380 #yiv9915648380actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9915648380
#yiv9915648380activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9915648380
#yiv9915648380activity span {font-weight:700;}#yiv9915648380
#yiv9915648380activity span:first-child
{text-transform:uppercase;}#yiv9915648380 #yiv9915648380activity span a
{color:#5085b6;text-decoration:none;}#yiv9915648380 #yiv9915648380activity span
span {color:#ff7900;}#yiv9915648380 #yiv9915648380activity span
.yiv9915648380underline {text-decoration:underline;}#yiv9915648380
.yiv9915648380attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9915648380 .yiv9915648380attach div a
{text-decoration:none;}#yiv9915648380 .yiv9915648380attach img
{border:none;padding-right:5px;}#yiv9915648380 .yiv9915648380attach label
{display:block;margin-bottom:5px;}#yiv9915648380 .yiv9915648380attach label a
{text-decoration:none;}#yiv9915648380 blockquote {margin:0 0 0
4px;}#yiv9915648380 .yiv9915648380bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9915648380
.yiv9915648380bold a {text-decoration:none;}#yiv9915648380 dd.yiv9915648380last
p a {font-family:Verdana;font-weight:700;}#yiv9915648380 dd.yiv9915648380last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9915648380
dd.yiv9915648380last p span.yiv9915648380yshortcuts
{margin-right:0;}#yiv9915648380 div.yiv9915648380attach-table div div a
{text-decoration:none;}#yiv9915648380 div.yiv9915648380attach-table
{width:400px;}#yiv9915648380 div.yiv9915648380file-title a, #yiv9915648380
div.yiv9915648380file-title a:active, #yiv9915648380
div.yiv9915648380file-title a:hover, #yiv9915648380 div.yiv9915648380file-title
a:visited {text-decoration:none;}#yiv9915648380 div.yiv9915648380photo-title a,
#yiv9915648380 div.yiv9915648380photo-title a:active, #yiv9915648380
div.yiv9915648380photo-title a:hover, #yiv9915648380
div.yiv9915648380photo-title a:visited {text-decoration:none;}#yiv9915648380
div#yiv9915648380ygrp-mlmsg #yiv9915648380ygrp-msg p a
span.yiv9915648380yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9915648380
.yiv9915648380green {color:#628c2a;}#yiv9915648380 .yiv9915648380MsoNormal
{margin:0 0 0 0;}#yiv9915648380 o {font-size:0;}#yiv9915648380
#yiv9915648380photos div {float:left;width:72px;}#yiv9915648380
#yiv9915648380photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9915648380
#yiv9915648380photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9915648380
#yiv9915648380reco-category {font-size:77%;}#yiv9915648380
#yiv9915648380reco-desc {font-size:77%;}#yiv9915648380 .yiv9915648380replbq
{margin:4px;}#yiv9915648380 #yiv9915648380ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9915648380 #yiv9915648380ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9915648380
#yiv9915648380ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9915648380
#yiv9915648380ygrp-mlmsg select, #yiv9915648380 input, #yiv9915648380 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9915648380
#yiv9915648380ygrp-mlmsg pre, #yiv9915648380 code {font:115%
monospace;}#yiv9915648380 #yiv9915648380ygrp-mlmsg *
{line-height:1.22em;}#yiv9915648380 #yiv9915648380ygrp-mlmsg #yiv9915648380logo
{padding-bottom:10px;}#yiv9915648380 #yiv9915648380ygrp-msg p a
{font-family:Verdana;}#yiv9915648380 #yiv9915648380ygrp-msg
p#yiv9915648380attach-count span {color:#1E66AE;font-weight:700;}#yiv9915648380
#yiv9915648380ygrp-reco #yiv9915648380reco-head
{color:#ff7900;font-weight:700;}#yiv9915648380 #yiv9915648380ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9915648380 #yiv9915648380ygrp-sponsor
#yiv9915648380ov li a {font-size:130%;text-decoration:none;}#yiv9915648380
#yiv9915648380ygrp-sponsor #yiv9915648380ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9915648380
#yiv9915648380ygrp-sponsor #yiv9915648380ov ul {margin:0;padding:0 0 0
8px;}#yiv9915648380 #yiv9915648380ygrp-text
{font-family:Georgia;}#yiv9915648380 #yiv9915648380ygrp-text p {margin:0 0 1em
0;}#yiv9915648380 #yiv9915648380ygrp-text tt {font-size:120%;}#yiv9915648380
#yiv9915648380ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9915648380
