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
