Re: [belajar-excel] rekap bon 3 kriteria

Fri, 19 Sep 2014 00:32:04 -0700 


--------------------------------------------
On Mon, 9/15/14, 'Mr. Kid' [email protected] [belajar-excel] 
<[email protected]> wrote:


 Subject: Re: [belajar-excel] rekap bon 3 kriteria [1 Attachment]
 To: "BeExcel" <[email protected]>
 Date: Monday, September 15, 2014, 8:02 PM

 terima kasih mr.kid, pivot table sangat baru bagi saya dan selama ini saya 
nggak berani menyentuhnya, tapi setelah saya liat jawaban mr. saya jadi pingin 
coba lalu saya jalan-jalan ke 
<http://excel-mr-kid.blogspot.com/2013/04/pivot-table-1-kenalan.html>..., uda 
di coba tutorialnya sampai 
http://excel-mr-kid.blogspot.com/2013/09/pivot-table-3-pivot-field.html, eh 
waktu mau buat ulang rekap bon pakai pivot yang mr kit buat saya kebingungan, 
mungkin saya baru tahapan liat contoh yang sudah ada tapi belum bisa terapkan 
ke data lain yang beda kasus. mohon bimbingannya agar langkah membuat laporan 
rekap bon itu menggunakan fasilitas pivot table di jelaskan dari awal.
  









       Wa'alaikumussalam Wr.
 Wb.

 Biar telat yang
 penting urun...

 mbak,
 file terlampir sekedar iseng pake pivot table. sapa tahu
 bisa jadi bahan munculnya ide baru.

 Wassalamu'alaikum Wr. Wb.
 Kid.






 2014-09-12 17:59 GMT+10:00
 fatimah nazmy [email protected]
 [belajar-excel] <[email protected]>:















  









       Assalamu 'alaikum
 Wr.WbSalam kenal semuanya rekan2 milis belajar
 excel. saya pendatang baru ingin bantuan dari para
 rekan2.





 1.
 di kolom nama
 bahan otomatis
 muncul nama-nama bahan yang dimasukkan di sheet master dan
 sesuai bulan
 yang di pilih


 2.
 begitu juga di kolom banyaknya,
 dan total
 diambil dari banyaknya dan total di sheet master dengan nama
 bahan serta bulan
 yang di tentukan.

 file
 terlampir.
  























   







 #yiv9443814538 #yiv9443814538 --
   #yiv9443814538ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}

 #yiv9443814538 #yiv9443814538ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv9443814538 #yiv9443814538ygrp-mkp #yiv9443814538hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

 0;}

 #yiv9443814538 #yiv9443814538ygrp-mkp #yiv9443814538ads {
 margin-bottom:10px;}

 #yiv9443814538 #yiv9443814538ygrp-mkp .yiv9443814538ad {
 padding:0 0;}

 #yiv9443814538 #yiv9443814538ygrp-mkp .yiv9443814538ad p {

 margin:0;}

 #yiv9443814538 #yiv9443814538ygrp-mkp .yiv9443814538ad a {
 color:#0000ff;text-decoration:none;}
 #yiv9443814538 #yiv9443814538ygrp-sponsor
 #yiv9443814538ygrp-lc {
 font-family:Arial;}

 #yiv9443814538 #yiv9443814538ygrp-sponsor
 #yiv9443814538ygrp-lc #yiv9443814538hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv9443814538 #yiv9443814538ygrp-sponsor
 #yiv9443814538ygrp-lc .yiv9443814538ad {
 margin-bottom:10px;padding:0 0;}

 #yiv9443814538 #yiv9443814538actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

 #yiv9443814538 #yiv9443814538activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

 #yiv9443814538 #yiv9443814538activity span {
 font-weight:700;}

 #yiv9443814538 #yiv9443814538activity span:first-child {
 text-transform:uppercase;}

 #yiv9443814538 #yiv9443814538activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv9443814538 #yiv9443814538activity span span {
 color:#ff7900;}

 #yiv9443814538 #yiv9443814538activity span
 .yiv9443814538underline {
 text-decoration:underline;}

 #yiv9443814538 .yiv9443814538attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}

 #yiv9443814538 .yiv9443814538attach div a {
 text-decoration:none;}

 #yiv9443814538 .yiv9443814538attach img {
 border:none;padding-right:5px;}

 #yiv9443814538 .yiv9443814538attach label {
 display:block;margin-bottom:5px;}

 #yiv9443814538 .yiv9443814538attach label a {
 text-decoration:none;}

 #yiv9443814538 blockquote {
 margin:0 0 0 4px;}

 #yiv9443814538 .yiv9443814538bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv9443814538 .yiv9443814538bold a {
 text-decoration:none;}

 #yiv9443814538 dd.yiv9443814538last p a {
 font-family:Verdana;font-weight:700;}

 #yiv9443814538 dd.yiv9443814538last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}

 #yiv9443814538 dd.yiv9443814538last p
 span.yiv9443814538yshortcuts {
 margin-right:0;}

 #yiv9443814538 div.yiv9443814538attach-table div div a {
 text-decoration:none;}

 #yiv9443814538 div.yiv9443814538attach-table {
 width:400px;}

 #yiv9443814538 div.yiv9443814538file-title a, #yiv9443814538

 div.yiv9443814538file-title a:active, #yiv9443814538
 div.yiv9443814538file-title a:hover, #yiv9443814538
 div.yiv9443814538file-title a:visited {
 text-decoration:none;}

 #yiv9443814538 div.yiv9443814538photo-title a,
 #yiv9443814538 div.yiv9443814538photo-title a:active,
 #yiv9443814538 div.yiv9443814538photo-title a:hover,
 #yiv9443814538 div.yiv9443814538photo-title a:visited {
 text-decoration:none;}

 #yiv9443814538 div#yiv9443814538ygrp-mlmsg
 #yiv9443814538ygrp-msg p a span.yiv9443814538yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv9443814538 .yiv9443814538green {
 color:#628c2a;}

 #yiv9443814538 .yiv9443814538MsoNormal {

 margin:0 0 0 0;}

 #yiv9443814538 o {
 font-size:0;}

 #yiv9443814538 #yiv9443814538photos div {
 float:left;width:72px;}

 #yiv9443814538 #yiv9443814538photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}

 #yiv9443814538 #yiv9443814538photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

 #yiv9443814538 #yiv9443814538reco-category {
 font-size:77%;}

 #yiv9443814538 #yiv9443814538reco-desc {
 font-size:77%;}

 #yiv9443814538 .yiv9443814538replbq {
 margin:4px;}

 #yiv9443814538 #yiv9443814538ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}

 #yiv9443814538 #yiv9443814538ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}

 #yiv9443814538 #yiv9443814538ygrp-mlmsg table {
 font-size:inherit;font:100%;}

 #yiv9443814538 #yiv9443814538ygrp-mlmsg select,
 #yiv9443814538 input, #yiv9443814538 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}

 #yiv9443814538 #yiv9443814538ygrp-mlmsg pre, #yiv9443814538
 code {
 font:115% monospace;}

 #yiv9443814538 #yiv9443814538ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv9443814538 #yiv9443814538ygrp-mlmsg #yiv9443814538logo {
 padding-bottom:10px;}


 #yiv9443814538 #yiv9443814538ygrp-msg p a {
 font-family:Verdana;}

 #yiv9443814538 #yiv9443814538ygrp-msg
 p#yiv9443814538attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv9443814538 #yiv9443814538ygrp-reco
 #yiv9443814538reco-head {
 color:#ff7900;font-weight:700;}

 #yiv9443814538 #yiv9443814538ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv9443814538 #yiv9443814538ygrp-sponsor #yiv9443814538ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv9443814538 #yiv9443814538ygrp-sponsor #yiv9443814538ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv9443814538 #yiv9443814538ygrp-sponsor #yiv9443814538ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv9443814538 #yiv9443814538ygrp-text {
 font-family:Georgia;}

 #yiv9443814538 #yiv9443814538ygrp-text p {
 margin:0 0 1em 0;}

 #yiv9443814538 #yiv9443814538ygrp-text tt {
 font-size:120%;}

 #yiv9443814538 #yiv9443814538ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv9443814538

Kirim email ke