Bls: [belajar-excel] menggabungkan banyak sheet

2015-01-18 Terurut Topik odong nando odongna...@yahoo.com [belajar-excel]
saya sering melakukan konvert pdf ke excel, bisa langsung jadi satu sheet excel 
kok, bahkan dari beberapa file pdf, jadi 1 sheet, bukan beberapa sheet apa lagi 
beberapa workbook...
bisa liat filenya, klo filenya lebih dari 250kb bisa japri... thx, 


odong nando
 

 Pada Minggu, 18 Januari 2015 11:35, roy sumarna rohendi_2...@yahoo.co.id 
[belajar-excel] belajar-excel@yahoogroups.com menulis:
   

     

Pakar excel yth. 
Dah lama saya tidak gabung. Pertama selamat taun baru walau terlambat. Moga 
taun 2015 menjadi taun kesuksesan. Terutama pengasuh group. 
Saya ada masalah, saat mengconver data dari pdf ke excel dimana halaman dlm pdf 
menjadi worksheet yg jumlahnya sekitar 156, bagaimana menggabung worksheet 
tersebut menjadi satu. 
Terima kasih
 Rohaendi 
  #yiv3090988726 #yiv3090988726 -- #yiv3090988726ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3090988726 
#yiv3090988726ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3090988726 
#yiv3090988726ygrp-mkp #yiv3090988726hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3090988726 #yiv3090988726ygrp-mkp #yiv3090988726ads 
{margin-bottom:10px;}#yiv3090988726 #yiv3090988726ygrp-mkp .yiv3090988726ad 
{padding:0 0;}#yiv3090988726 #yiv3090988726ygrp-mkp .yiv3090988726ad p 
{margin:0;}#yiv3090988726 #yiv3090988726ygrp-mkp .yiv3090988726ad a 
{color:#ff;text-decoration:none;}#yiv3090988726 #yiv3090988726ygrp-sponsor 
#yiv3090988726ygrp-lc {font-family:Arial;}#yiv3090988726 
#yiv3090988726ygrp-sponsor #yiv3090988726ygrp-lc #yiv3090988726hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3090988726 
#yiv3090988726ygrp-sponsor #yiv3090988726ygrp-lc .yiv3090988726ad 
{margin-bottom:10px;padding:0 0;}#yiv3090988726 #yiv3090988726actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3090988726 
#yiv3090988726activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3090988726
 #yiv3090988726activity span {font-weight:700;}#yiv3090988726 
#yiv3090988726activity span:first-child 
{text-transform:uppercase;}#yiv3090988726 #yiv3090988726activity span a 
{color:#5085b6;text-decoration:none;}#yiv3090988726 #yiv3090988726activity span 
span {color:#ff7900;}#yiv3090988726 #yiv3090988726activity span 
.yiv3090988726underline {text-decoration:underline;}#yiv3090988726 
.yiv3090988726attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3090988726 .yiv3090988726attach div a 
{text-decoration:none;}#yiv3090988726 .yiv3090988726attach img 
{border:none;padding-right:5px;}#yiv3090988726 .yiv3090988726attach label 
{display:block;margin-bottom:5px;}#yiv3090988726 .yiv3090988726attach label a 
{text-decoration:none;}#yiv3090988726 blockquote {margin:0 0 0 
4px;}#yiv3090988726 .yiv3090988726bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3090988726 
.yiv3090988726bold a {text-decoration:none;}#yiv3090988726 dd.yiv3090988726last 
p a {font-family:Verdana;font-weight:700;}#yiv3090988726 dd.yiv3090988726last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3090988726 
dd.yiv3090988726last p span.yiv3090988726yshortcuts 
{margin-right:0;}#yiv3090988726 div.yiv3090988726attach-table div div a 
{text-decoration:none;}#yiv3090988726 div.yiv3090988726attach-table 
{width:400px;}#yiv3090988726 div.yiv3090988726file-title a, #yiv3090988726 
div.yiv3090988726file-title a:active, #yiv3090988726 
div.yiv3090988726file-title a:hover, #yiv3090988726 div.yiv3090988726file-title 
a:visited {text-decoration:none;}#yiv3090988726 div.yiv3090988726photo-title a, 
#yiv3090988726 div.yiv3090988726photo-title a:active, #yiv3090988726 
div.yiv3090988726photo-title a:hover, #yiv3090988726 
div.yiv3090988726photo-title a:visited {text-decoration:none;}#yiv3090988726 
div#yiv3090988726ygrp-mlmsg #yiv3090988726ygrp-msg p a 
span.yiv3090988726yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3090988726 
.yiv3090988726green {color:#628c2a;}#yiv3090988726 .yiv3090988726MsoNormal 
{margin:0 0 0 0;}#yiv3090988726 o {font-size:0;}#yiv3090988726 
#yiv3090988726photos div {float:left;width:72px;}#yiv3090988726 
#yiv3090988726photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3090988726 
#yiv3090988726photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3090988726
 #yiv3090988726reco-category {font-size:77%;}#yiv3090988726 
#yiv3090988726reco-desc {font-size:77%;}#yiv3090988726 .yiv3090988726replbq 
{margin:4px;}#yiv3090988726 #yiv3090988726ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3090988726 #yiv3090988726ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3090988726 
#yiv3090988726ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3090988726 
#yiv3090988726ygrp-mlmsg select, #yiv3090988726 input, #yiv3090988726 

[belajar-excel] menggabungkan banyak sheet

2015-01-17 Terurut Topik roy sumarna rohendi_2...@yahoo.co.id [belajar-excel]


Pakar excel yth.
Dah lama saya tidak gabung. Pertama selamat taun baru walau terlambat. Moga 
taun 2015 menjadi taun kesuksesan. Terutama pengasuh group.
Saya ada masalah, saat mengconver data dari pdf ke excel dimana halaman dlm pdf 
menjadi worksheet yg jumlahnya sekitar 156, bagaimana menggabung worksheet 
tersebut menjadi satu.
Terima kasih
 Rohaendi