Maaf masih bingung untuk penggunaan pivot tabel pada kasus saya ini, apa bisa mengambil data dari pivot tabel untuk nama yang saya inginkan ke sheet yang lain?
Pada Senin, 26 Maret 2018 21.37.59 WIB, Arif Wijaya arifw1...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Terima kasih masukannya Mas Kid dan Mas Hendrik.. Sent from Yahoo Mail on Android On Mon, Mar 26, 2018 at 15:29, hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote: Hai Arif,Jika tanggal tidak perlu ditampilkan maka coba blok Range(B1:H...) untuk range PivotTablenya. Salam,HK On Monday, 26 March 2018, 2:54:14 PM GMT+7, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Wa'alaikumussalam wr wb Coba manfaatkan pivot table. Oh iya, Sebaiknya kolom tanggal ditulis lengkap disetiap baris data (tidak ada cells kosong di kolom tanggal) Wassalamu'alaikum wr wb Kid 2018-03-25 17:19 GMT+07:00 Arif Wijaya arifw1...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: Assalamu'alaikumsaya punya data di Sheet 1 sperti terlampir, bagaimana cara mengambil data dr kolom c di sheet 1 ke sheet 3 kolom A dengan tambahan kriteria kolom d di sheet 1 sama seperti data B2 sheet 3. terima kasih atas bantuannya #yiv0322245111 #yiv0322245111 -- #yiv0322245111ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0322245111 #yiv0322245111ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0322245111 #yiv0322245111ygrp-mkp #yiv0322245111hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0322245111 #yiv0322245111ygrp-mkp #yiv0322245111ads {margin-bottom:10px;}#yiv0322245111 #yiv0322245111ygrp-mkp .yiv0322245111ad {padding:0 0;}#yiv0322245111 #yiv0322245111ygrp-mkp .yiv0322245111ad p {margin:0;}#yiv0322245111 #yiv0322245111ygrp-mkp .yiv0322245111ad a {color:#0000ff;text-decoration:none;}#yiv0322245111 #yiv0322245111ygrp-sponsor #yiv0322245111ygrp-lc {font-family:Arial;}#yiv0322245111 #yiv0322245111ygrp-sponsor #yiv0322245111ygrp-lc #yiv0322245111hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0322245111 #yiv0322245111ygrp-sponsor #yiv0322245111ygrp-lc .yiv0322245111ad {margin-bottom:10px;padding:0 0;}#yiv0322245111 #yiv0322245111actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0322245111 #yiv0322245111activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0322245111 #yiv0322245111activity span {font-weight:700;}#yiv0322245111 #yiv0322245111activity span:first-child {text-transform:uppercase;}#yiv0322245111 #yiv0322245111activity span a {color:#5085b6;text-decoration:none;}#yiv0322245111 #yiv0322245111activity span span {color:#ff7900;}#yiv0322245111 #yiv0322245111activity span .yiv0322245111underline {text-decoration:underline;}#yiv0322245111 .yiv0322245111attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0322245111 .yiv0322245111attach div a {text-decoration:none;}#yiv0322245111 .yiv0322245111attach img {border:none;padding-right:5px;}#yiv0322245111 .yiv0322245111attach label {display:block;margin-bottom:5px;}#yiv0322245111 .yiv0322245111attach label a {text-decoration:none;}#yiv0322245111 blockquote {margin:0 0 0 4px;}#yiv0322245111 .yiv0322245111bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0322245111 .yiv0322245111bold a {text-decoration:none;}#yiv0322245111 dd.yiv0322245111last p a {font-family:Verdana;font-weight:700;}#yiv0322245111 dd.yiv0322245111last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0322245111 dd.yiv0322245111last p span.yiv0322245111yshortcuts {margin-right:0;}#yiv0322245111 div.yiv0322245111attach-table div div a {text-decoration:none;}#yiv0322245111 div.yiv0322245111attach-table {width:400px;}#yiv0322245111 div.yiv0322245111file-title a, #yiv0322245111 div.yiv0322245111file-title a:active, #yiv0322245111 div.yiv0322245111file-title a:hover, #yiv0322245111 div.yiv0322245111file-title a:visited {text-decoration:none;}#yiv0322245111 div.yiv0322245111photo-title a, #yiv0322245111 div.yiv0322245111photo-title a:active, #yiv0322245111 div.yiv0322245111photo-title a:hover, #yiv0322245111 div.yiv0322245111photo-title a:visited {text-decoration:none;}#yiv0322245111 div#yiv0322245111ygrp-mlmsg #yiv0322245111ygrp-msg p a span.yiv0322245111yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0322245111 .yiv0322245111green {color:#628c2a;}#yiv0322245111 .yiv0322245111MsoNormal {margin:0 0 0 0;}#yiv0322245111 o {font-size:0;}#yiv0322245111 #yiv0322245111photos div {float:left;width:72px;}#yiv0322245111 #yiv0322245111photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0322245111 #yiv0322245111photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0322245111 #yiv0322245111reco-category {font-size:77%;}#yiv0322245111 #yiv0322245111reco-desc {font-size:77%;}#yiv0322245111 .yiv0322245111replbq {margin:4px;}#yiv0322245111 #yiv0322245111ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0322245111 #yiv0322245111ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0322245111 #yiv0322245111ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0322245111 #yiv0322245111ygrp-mlmsg select, #yiv0322245111 input, #yiv0322245111 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0322245111 #yiv0322245111ygrp-mlmsg pre, #yiv0322245111 code {font:115% monospace;}#yiv0322245111 #yiv0322245111ygrp-mlmsg * {line-height:1.22em;}#yiv0322245111 #yiv0322245111ygrp-mlmsg #yiv0322245111logo {padding-bottom:10px;}#yiv0322245111 #yiv0322245111ygrp-msg p a {font-family:Verdana;}#yiv0322245111 #yiv0322245111ygrp-msg p#yiv0322245111attach-count span {color:#1E66AE;font-weight:700;}#yiv0322245111 #yiv0322245111ygrp-reco #yiv0322245111reco-head {color:#ff7900;font-weight:700;}#yiv0322245111 #yiv0322245111ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0322245111 #yiv0322245111ygrp-sponsor #yiv0322245111ov li a {font-size:130%;text-decoration:none;}#yiv0322245111 #yiv0322245111ygrp-sponsor #yiv0322245111ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0322245111 #yiv0322245111ygrp-sponsor #yiv0322245111ov ul {margin:0;padding:0 0 0 8px;}#yiv0322245111 #yiv0322245111ygrp-text {font-family:Georgia;}#yiv0322245111 #yiv0322245111ygrp-text p {margin:0 0 1em 0;}#yiv0322245111 #yiv0322245111ygrp-text tt {font-size:120%;}#yiv0322245111 #yiv0322245111ygrp-vital ul li:last-child {border-right:none !important;}#yiv0322245111