Terimakasih mr.nang agus, akan saya coba pelajari dan membangkan semampu saya..
Mohon kiranya nanti jika ada kendala teman2 disini bisa membantu...👍👍
praztmath
Pada Rab, 31 Jan 2018 pada 14:44, Nangagus nanga...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Wa'alaikumusalam Warahmatullahiwabarakatuh.
Mas Prazt Math..
Pengubahan XML menjadi Excel jadwal anda lebih mudah menggunakan VBA, atau
Pivot....
Pada lampiran saya mencoba menggunakan Formula untuk hari Senin jam ke-2, dan
ke-3, silahkan dikembangkan sesuai kebutuhan. Dengan sedikit cara tersebut
tentunya dapat digunakan sebagai acuan untuk membuat pivot maupun VBA. Selamat
mencoba dan selamat berkreasi.
Wasalamualaikum warahmatullah
NangAgus
On 26/01/2018 15:57, Prazt Math praztm...@gmail.com [belajar-excel] wrote:
Assalamu’alaikum,
Selamat sore para master dan para suhu, dikarenakan masih ceteknya pengalaman
sayatentang excel mohon bantuan pada para master, bagaimana cara supaya
database hasil impor dari xml (pada file lapiran sheet bernama database)
menjadi rapi seperti yang saya inginkan sperti pada sheet hasil pada lampiran
berikut. Boleh menggunakan formula atau menggunakan vba macro maupun keduanya.
Mohon maaf jika ada bahasa yang kurang pas.
Terimakasih sebelumnya
Sent from Mail for Windows 10
#yiv8857916996 #yiv8857916996 -- #yiv8857916996ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8857916996
#yiv8857916996ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8857916996
#yiv8857916996ygrp-mkp #yiv8857916996hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8857916996 #yiv8857916996ygrp-mkp #yiv8857916996ads
{margin-bottom:10px;}#yiv8857916996 #yiv8857916996ygrp-mkp .yiv8857916996ad
{padding:0 0;}#yiv8857916996 #yiv8857916996ygrp-mkp .yiv8857916996ad p
{margin:0;}#yiv8857916996 #yiv8857916996ygrp-mkp .yiv8857916996ad a
{color:#0000ff;text-decoration:none;}#yiv8857916996 #yiv8857916996ygrp-sponsor
#yiv8857916996ygrp-lc {font-family:Arial;}#yiv8857916996
#yiv8857916996ygrp-sponsor #yiv8857916996ygrp-lc #yiv8857916996hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8857916996
#yiv8857916996ygrp-sponsor #yiv8857916996ygrp-lc .yiv8857916996ad
{margin-bottom:10px;padding:0 0;}#yiv8857916996 #yiv8857916996actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8857916996
#yiv8857916996activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8857916996
#yiv8857916996activity span {font-weight:700;}#yiv8857916996
#yiv8857916996activity span:first-child
{text-transform:uppercase;}#yiv8857916996 #yiv8857916996activity span a
{color:#5085b6;text-decoration:none;}#yiv8857916996 #yiv8857916996activity span
span {color:#ff7900;}#yiv8857916996 #yiv8857916996activity span
.yiv8857916996underline {text-decoration:underline;}#yiv8857916996
.yiv8857916996attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8857916996 .yiv8857916996attach div a
{text-decoration:none;}#yiv8857916996 .yiv8857916996attach img
{border:none;padding-right:5px;}#yiv8857916996 .yiv8857916996attach label
{display:block;margin-bottom:5px;}#yiv8857916996 .yiv8857916996attach label a
{text-decoration:none;}#yiv8857916996 blockquote {margin:0 0 0
4px;}#yiv8857916996 .yiv8857916996bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8857916996
.yiv8857916996bold a {text-decoration:none;}#yiv8857916996 dd.yiv8857916996last
p a {font-family:Verdana;font-weight:700;}#yiv8857916996 dd.yiv8857916996last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8857916996
dd.yiv8857916996last p span.yiv8857916996yshortcuts
{margin-right:0;}#yiv8857916996 div.yiv8857916996attach-table div div a
{text-decoration:none;}#yiv8857916996 div.yiv8857916996attach-table
{width:400px;}#yiv8857916996 div.yiv8857916996file-title a, #yiv8857916996
div.yiv8857916996file-title a:active, #yiv8857916996
div.yiv8857916996file-title a:hover, #yiv8857916996 div.yiv8857916996file-title
a:visited {text-decoration:none;}#yiv8857916996 div.yiv8857916996photo-title a,
#yiv8857916996 div.yiv8857916996photo-title a:active, #yiv8857916996
div.yiv8857916996photo-title a:hover, #yiv8857916996
div.yiv8857916996photo-title a:visited {text-decoration:none;}#yiv8857916996
div#yiv8857916996ygrp-mlmsg #yiv8857916996ygrp-msg p a
span.yiv8857916996yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8857916996
.yiv8857916996green {color:#628c2a;}#yiv8857916996 .yiv8857916996MsoNormal
{margin:0 0 0 0;}#yiv8857916996 o {font-size:0;}#yiv8857916996
#yiv8857916996photos div {float:left;width:72px;}#yiv8857916996
#yiv8857916996photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8857916996
#yiv8857916996photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8857916996
#yiv8857916996reco-category {font-size:77%;}#yiv8857916996
#yiv8857916996reco-desc {font-size:77%;}#yiv8857916996 .yiv8857916996replbq
{margin:4px;}#yiv8857916996 #yiv8857916996ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8857916996 #yiv8857916996ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8857916996
#yiv8857916996ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8857916996
#yiv8857916996ygrp-mlmsg select, #yiv8857916996 input, #yiv8857916996 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8857916996
#yiv8857916996ygrp-mlmsg pre, #yiv8857916996 code {font:115%
monospace;}#yiv8857916996 #yiv8857916996ygrp-mlmsg *
{line-height:1.22em;}#yiv8857916996 #yiv8857916996ygrp-mlmsg #yiv8857916996logo
{padding-bottom:10px;}#yiv8857916996 #yiv8857916996ygrp-msg p a
{font-family:Verdana;}#yiv8857916996 #yiv8857916996ygrp-msg
p#yiv8857916996attach-count span {color:#1E66AE;font-weight:700;}#yiv8857916996
#yiv8857916996ygrp-reco #yiv8857916996reco-head
{color:#ff7900;font-weight:700;}#yiv8857916996 #yiv8857916996ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8857916996 #yiv8857916996ygrp-sponsor
#yiv8857916996ov li a {font-size:130%;text-decoration:none;}#yiv8857916996
#yiv8857916996ygrp-sponsor #yiv8857916996ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8857916996
#yiv8857916996ygrp-sponsor #yiv8857916996ov ul {margin:0;padding:0 0 0
8px;}#yiv8857916996 #yiv8857916996ygrp-text
{font-family:Georgia;}#yiv8857916996 #yiv8857916996ygrp-text p {margin:0 0 1em
0;}#yiv8857916996 #yiv8857916996ygrp-text tt {font-size:120%;}#yiv8857916996
#yiv8857916996ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8857916996
