Hai Robby,Bisa diberikan contoh bentuk output yang diinginkan ?Jika
keperluannya hanya untuk mencetak maka wb tsb ga perlu digabung, cukup pake
sistim buka, cetak, tutup dengan syarat wb tesebut dikumpulkan dulu dalam satu
sub folder.
Salam,HK
From: "[email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 27 October 2015, 20:07
Subject: [belajar-excel] Menggabungkan beberapa WB ke new WB (1 sheet) [3
Attachments]
selamat malam kawan,
berikut saya ingin menyanyakan bagaimana cara menggabungkan beberapa WB ke
dalam satu WB (1sheet) tanpa mengubah bentuk dan formasi table yg sudah ada,,,
mengingat bentuk selanjutnya akan kami jadikan bahan agar bisa di cetak
sehingga di perlukan kesamaan bentuk table.
NB lampiran adalah satu file WB. jumlahnya bisa sampai ratusan WB dengan bentuk
yg sama seperti di lampiran. akan kah ada limitnya untuk jumlah Row maks nya.
trims...
best regard
robby habibie
#yiv0236709796 #yiv0236709796 -- #yiv0236709796ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0236709796
#yiv0236709796ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0236709796
#yiv0236709796ygrp-mkp #yiv0236709796hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0236709796 #yiv0236709796ygrp-mkp #yiv0236709796ads
{margin-bottom:10px;}#yiv0236709796 #yiv0236709796ygrp-mkp .yiv0236709796ad
{padding:0 0;}#yiv0236709796 #yiv0236709796ygrp-mkp .yiv0236709796ad p
{margin:0;}#yiv0236709796 #yiv0236709796ygrp-mkp .yiv0236709796ad a
{color:#0000ff;text-decoration:none;}#yiv0236709796 #yiv0236709796ygrp-sponsor
#yiv0236709796ygrp-lc {font-family:Arial;}#yiv0236709796
#yiv0236709796ygrp-sponsor #yiv0236709796ygrp-lc #yiv0236709796hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0236709796
#yiv0236709796ygrp-sponsor #yiv0236709796ygrp-lc .yiv0236709796ad
{margin-bottom:10px;padding:0 0;}#yiv0236709796 #yiv0236709796actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0236709796
#yiv0236709796activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0236709796
#yiv0236709796activity span {font-weight:700;}#yiv0236709796
#yiv0236709796activity span:first-child
{text-transform:uppercase;}#yiv0236709796 #yiv0236709796activity span a
{color:#5085b6;text-decoration:none;}#yiv0236709796 #yiv0236709796activity span
span {color:#ff7900;}#yiv0236709796 #yiv0236709796activity span
.yiv0236709796underline {text-decoration:underline;}#yiv0236709796
.yiv0236709796attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0236709796 .yiv0236709796attach div a
{text-decoration:none;}#yiv0236709796 .yiv0236709796attach img
{border:none;padding-right:5px;}#yiv0236709796 .yiv0236709796attach label
{display:block;margin-bottom:5px;}#yiv0236709796 .yiv0236709796attach label a
{text-decoration:none;}#yiv0236709796 blockquote {margin:0 0 0
4px;}#yiv0236709796 .yiv0236709796bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0236709796
.yiv0236709796bold a {text-decoration:none;}#yiv0236709796 dd.yiv0236709796last
p a {font-family:Verdana;font-weight:700;}#yiv0236709796 dd.yiv0236709796last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0236709796
dd.yiv0236709796last p span.yiv0236709796yshortcuts
{margin-right:0;}#yiv0236709796 div.yiv0236709796attach-table div div a
{text-decoration:none;}#yiv0236709796 div.yiv0236709796attach-table
{width:400px;}#yiv0236709796 div.yiv0236709796file-title a, #yiv0236709796
div.yiv0236709796file-title a:active, #yiv0236709796
div.yiv0236709796file-title a:hover, #yiv0236709796 div.yiv0236709796file-title
a:visited {text-decoration:none;}#yiv0236709796 div.yiv0236709796photo-title a,
#yiv0236709796 div.yiv0236709796photo-title a:active, #yiv0236709796
div.yiv0236709796photo-title a:hover, #yiv0236709796
div.yiv0236709796photo-title a:visited {text-decoration:none;}#yiv0236709796
div#yiv0236709796ygrp-mlmsg #yiv0236709796ygrp-msg p a
span.yiv0236709796yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0236709796
.yiv0236709796green {color:#628c2a;}#yiv0236709796 .yiv0236709796MsoNormal
{margin:0 0 0 0;}#yiv0236709796 o {font-size:0;}#yiv0236709796
#yiv0236709796photos div {float:left;width:72px;}#yiv0236709796
#yiv0236709796photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0236709796
#yiv0236709796photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0236709796
#yiv0236709796reco-category {font-size:77%;}#yiv0236709796
#yiv0236709796reco-desc {font-size:77%;}#yiv0236709796 .yiv0236709796replbq
{margin:4px;}#yiv0236709796 #yiv0236709796ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0236709796 #yiv0236709796ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0236709796
#yiv0236709796ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0236709796
#yiv0236709796ygrp-mlmsg select, #yiv0236709796 input, #yiv0236709796 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0236709796
#yiv0236709796ygrp-mlmsg pre, #yiv0236709796 code {font:115%
monospace;}#yiv0236709796 #yiv0236709796ygrp-mlmsg *
{line-height:1.22em;}#yiv0236709796 #yiv0236709796ygrp-mlmsg #yiv0236709796logo
{padding-bottom:10px;}#yiv0236709796 #yiv0236709796ygrp-msg p a
{font-family:Verdana;}#yiv0236709796 #yiv0236709796ygrp-msg
p#yiv0236709796attach-count span {color:#1E66AE;font-weight:700;}#yiv0236709796
#yiv0236709796ygrp-reco #yiv0236709796reco-head
{color:#ff7900;font-weight:700;}#yiv0236709796 #yiv0236709796ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0236709796 #yiv0236709796ygrp-sponsor
#yiv0236709796ov li a {font-size:130%;text-decoration:none;}#yiv0236709796
#yiv0236709796ygrp-sponsor #yiv0236709796ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0236709796
#yiv0236709796ygrp-sponsor #yiv0236709796ov ul {margin:0;padding:0 0 0
8px;}#yiv0236709796 #yiv0236709796ygrp-text
{font-family:Georgia;}#yiv0236709796 #yiv0236709796ygrp-text p {margin:0 0 1em
0;}#yiv0236709796 #yiv0236709796ygrp-text tt {font-size:120%;}#yiv0236709796
#yiv0236709796ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0236709796
