Waalaikum Salam WarohmatuLLAHI WabarokaaTUHsambil nunggu solusi Vba
saya menawarkan solusi pakai formula barang kali ada gunanya.
sheet DATANILAI
untuk isian tabel indikator tulis di
A2=INDEX(INPUT!$A$9:$A$14,TRUNC((ROW(A1)-1)/12)+1) copy ke bawah
untuk isian tabel Nama tulis di B2
=INDEX(INPUT!$B$8:$M$8,MOD(ROW(A1)-1,12)+1) copy ke bawah
untuk isian tabel Nama tulis di B2
=INDEX(INPUT!$B$9:$M$14,TRUNC((ROW(A1)-1)/12)+1,MATCH(B2,INPUT!$B$8:$M$8,0))
copy ke bawah
wassalam
Ghozi Alkatiri Pada Senin, 18 Februari 2019 18.24.16 WIB, Cari Kebenaran
cahayailm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Assalamu'alaikum Wr. Wb.
Kepada para Master dan anggota milis. Tolong dibantu vba code. Saya ingin
melakukan transpose table. Table INDIKATOR PENILAIAN di sheet INPUT ingin saya
transpose secara otomatis di sheet DATANILAI dengan menekan tombol
"TRANSPOSE".. Selama ini saya melakukannya secara manual yaitu melalui
fasilitas bawaan excel: PIVOTTABLE AND PIVOTCHART WIZARD. Hasilnya bisa dilihat
di sheet DATANILAI.
Mohon dibuatkan kode VBA-nya. Syukur kalau kotak dialog untuk memilih cell
(disheet tertentu) untuk menempatkan tabel hasil transpose.
Demikian terima kasih.
Wassalamu'alaikum Wr. Wb. #yiv7404916732 #yiv7404916732 --
#yiv7404916732ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv7404916732 #yiv7404916732ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv7404916732 #yiv7404916732ygrp-mkp #yiv7404916732hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7404916732 #yiv7404916732ygrp-mkp #yiv7404916732ads
{margin-bottom:10px;}#yiv7404916732 #yiv7404916732ygrp-mkp .yiv7404916732ad
{padding:0 0;}#yiv7404916732 #yiv7404916732ygrp-mkp .yiv7404916732ad p
{margin:0;}#yiv7404916732 #yiv7404916732ygrp-mkp .yiv7404916732ad a
{color:#0000ff;text-decoration:none;}#yiv7404916732 #yiv7404916732ygrp-sponsor
#yiv7404916732ygrp-lc {font-family:Arial;}#yiv7404916732
#yiv7404916732ygrp-sponsor #yiv7404916732ygrp-lc #yiv7404916732hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7404916732
#yiv7404916732ygrp-sponsor #yiv7404916732ygrp-lc .yiv7404916732ad
{margin-bottom:10px;padding:0 0;}#yiv7404916732 #yiv7404916732actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7404916732
#yiv7404916732activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7404916732
#yiv7404916732activity span {font-weight:700;}#yiv7404916732
#yiv7404916732activity span:first-child
{text-transform:uppercase;}#yiv7404916732 #yiv7404916732activity span a
{color:#5085b6;text-decoration:none;}#yiv7404916732 #yiv7404916732activity span
span {color:#ff7900;}#yiv7404916732 #yiv7404916732activity span
.yiv7404916732underline {text-decoration:underline;}#yiv7404916732
.yiv7404916732attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7404916732 .yiv7404916732attach div a
{text-decoration:none;}#yiv7404916732 .yiv7404916732attach img
{border:none;padding-right:5px;}#yiv7404916732 .yiv7404916732attach label
{display:block;margin-bottom:5px;}#yiv7404916732 .yiv7404916732attach label a
{text-decoration:none;}#yiv7404916732 blockquote {margin:0 0 0
4px;}#yiv7404916732 .yiv7404916732bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7404916732
.yiv7404916732bold a {text-decoration:none;}#yiv7404916732 dd.yiv7404916732last
p a {font-family:Verdana;font-weight:700;}#yiv7404916732 dd.yiv7404916732last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7404916732
dd.yiv7404916732last p span.yiv7404916732yshortcuts
{margin-right:0;}#yiv7404916732 div.yiv7404916732attach-table div div a
{text-decoration:none;}#yiv7404916732 div.yiv7404916732attach-table
{width:400px;}#yiv7404916732 div.yiv7404916732file-title a, #yiv7404916732
div.yiv7404916732file-title a:active, #yiv7404916732
div.yiv7404916732file-title a:hover, #yiv7404916732 div.yiv7404916732file-title
a:visited {text-decoration:none;}#yiv7404916732 div.yiv7404916732photo-title a,
#yiv7404916732 div.yiv7404916732photo-title a:active, #yiv7404916732
div.yiv7404916732photo-title a:hover, #yiv7404916732
div.yiv7404916732photo-title a:visited {text-decoration:none;}#yiv7404916732
div#yiv7404916732ygrp-mlmsg #yiv7404916732ygrp-msg p a
span.yiv7404916732yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7404916732
.yiv7404916732green {color:#628c2a;}#yiv7404916732 .yiv7404916732MsoNormal
{margin:0 0 0 0;}#yiv7404916732 o {font-size:0;}#yiv7404916732
#yiv7404916732photos div {float:left;width:72px;}#yiv7404916732
#yiv7404916732photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7404916732
#yiv7404916732photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7404916732
#yiv7404916732reco-category {font-size:77%;}#yiv7404916732
#yiv7404916732reco-desc {font-size:77%;}#yiv7404916732 .yiv7404916732replbq
{margin:4px;}#yiv7404916732 #yiv7404916732ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7404916732 #yiv7404916732ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7404916732
#yiv7404916732ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7404916732
#yiv7404916732ygrp-mlmsg select, #yiv7404916732 input, #yiv7404916732 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7404916732
#yiv7404916732ygrp-mlmsg pre, #yiv7404916732 code {font:115%
monospace;}#yiv7404916732 #yiv7404916732ygrp-mlmsg *
{line-height:1.22em;}#yiv7404916732 #yiv7404916732ygrp-mlmsg #yiv7404916732logo
{padding-bottom:10px;}#yiv7404916732 #yiv7404916732ygrp-msg p a
{font-family:Verdana;}#yiv7404916732 #yiv7404916732ygrp-msg
p#yiv7404916732attach-count span {color:#1E66AE;font-weight:700;}#yiv7404916732
#yiv7404916732ygrp-reco #yiv7404916732reco-head
{color:#ff7900;font-weight:700;}#yiv7404916732 #yiv7404916732ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7404916732 #yiv7404916732ygrp-sponsor
#yiv7404916732ov li a {font-size:130%;text-decoration:none;}#yiv7404916732
#yiv7404916732ygrp-sponsor #yiv7404916732ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7404916732
#yiv7404916732ygrp-sponsor #yiv7404916732ov ul {margin:0;padding:0 0 0
8px;}#yiv7404916732 #yiv7404916732ygrp-text
{font-family:Georgia;}#yiv7404916732 #yiv7404916732ygrp-text p {margin:0 0 1em
0;}#yiv7404916732 #yiv7404916732ygrp-text tt {font-size:120%;}#yiv7404916732
#yiv7404916732ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7404916732
