Apakah setiap file yang ingin dicombine masing2 hanya terdiri dari 1 Tabel (Sheet) ?Bisa dibuatkan contoh 2 Dummy file yang ingin dicombine ? Salam,HK
Sent from Yahoo Mail on Android On Tue, Jul 31, 2018 at 20:06, [email protected] [belajar-excel]<[email protected]> wrote: Assalamualaikum Wr.Wb salam untuk semua member di group ini, terutama untuk para kuncen2 atau suhu2 disni hehe, perkenalkan saya ari member baru di group ini :) , saya mau bertanya mengenai penggabungan atau relasi antara beberapa tabel dari file yang berbeda menjadi 1 tabel, apakah pada program excel sudah tersedia fiture seperti itu? jika ada, dibagian mana dan seperti apa cara penggunaannya? apakah ada batasan file yg bisa digabungkan? dan kalo tidk ada, apakah ada alternatif lain , misal menggunakan aplikasi ke dua ? #yiv7956195528 #yiv7956195528 -- #yiv7956195528ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7956195528 #yiv7956195528ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7956195528 #yiv7956195528ygrp-mkp #yiv7956195528hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7956195528 #yiv7956195528ygrp-mkp #yiv7956195528ads {margin-bottom:10px;}#yiv7956195528 #yiv7956195528ygrp-mkp .yiv7956195528ad {padding:0 0;}#yiv7956195528 #yiv7956195528ygrp-mkp .yiv7956195528ad p {margin:0;}#yiv7956195528 #yiv7956195528ygrp-mkp .yiv7956195528ad a {color:#0000ff;text-decoration:none;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ygrp-lc {font-family:Arial;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ygrp-lc #yiv7956195528hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ygrp-lc .yiv7956195528ad {margin-bottom:10px;padding:0 0;}#yiv7956195528 #yiv7956195528actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7956195528 #yiv7956195528activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7956195528 #yiv7956195528activity span {font-weight:700;}#yiv7956195528 #yiv7956195528activity span:first-child {text-transform:uppercase;}#yiv7956195528 #yiv7956195528activity span a {color:#5085b6;text-decoration:none;}#yiv7956195528 #yiv7956195528activity span span {color:#ff7900;}#yiv7956195528 #yiv7956195528activity span .yiv7956195528underline {text-decoration:underline;}#yiv7956195528 .yiv7956195528attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7956195528 .yiv7956195528attach div a {text-decoration:none;}#yiv7956195528 .yiv7956195528attach img {border:none;padding-right:5px;}#yiv7956195528 .yiv7956195528attach label {display:block;margin-bottom:5px;}#yiv7956195528 .yiv7956195528attach label a {text-decoration:none;}#yiv7956195528 blockquote {margin:0 0 0 4px;}#yiv7956195528 .yiv7956195528bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7956195528 .yiv7956195528bold a {text-decoration:none;}#yiv7956195528 dd.yiv7956195528last p a {font-family:Verdana;font-weight:700;}#yiv7956195528 dd.yiv7956195528last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7956195528 dd.yiv7956195528last p span.yiv7956195528yshortcuts {margin-right:0;}#yiv7956195528 div.yiv7956195528attach-table div div a {text-decoration:none;}#yiv7956195528 div.yiv7956195528attach-table {width:400px;}#yiv7956195528 div.yiv7956195528file-title a, #yiv7956195528 div.yiv7956195528file-title a:active, #yiv7956195528 div.yiv7956195528file-title a:hover, #yiv7956195528 div.yiv7956195528file-title a:visited {text-decoration:none;}#yiv7956195528 div.yiv7956195528photo-title a, #yiv7956195528 div.yiv7956195528photo-title a:active, #yiv7956195528 div.yiv7956195528photo-title a:hover, #yiv7956195528 div.yiv7956195528photo-title a:visited {text-decoration:none;}#yiv7956195528 div#yiv7956195528ygrp-mlmsg #yiv7956195528ygrp-msg p a span.yiv7956195528yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7956195528 .yiv7956195528green {color:#628c2a;}#yiv7956195528 .yiv7956195528MsoNormal {margin:0 0 0 0;}#yiv7956195528 o {font-size:0;}#yiv7956195528 #yiv7956195528photos div {float:left;width:72px;}#yiv7956195528 #yiv7956195528photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7956195528 #yiv7956195528photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7956195528 #yiv7956195528reco-category {font-size:77%;}#yiv7956195528 #yiv7956195528reco-desc {font-size:77%;}#yiv7956195528 .yiv7956195528replbq {margin:4px;}#yiv7956195528 #yiv7956195528ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7956195528 #yiv7956195528ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7956195528 #yiv7956195528ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7956195528 #yiv7956195528ygrp-mlmsg select, #yiv7956195528 input, #yiv7956195528 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7956195528 #yiv7956195528ygrp-mlmsg pre, #yiv7956195528 code {font:115% monospace;}#yiv7956195528 #yiv7956195528ygrp-mlmsg * {line-height:1.22em;}#yiv7956195528 #yiv7956195528ygrp-mlmsg #yiv7956195528logo {padding-bottom:10px;}#yiv7956195528 #yiv7956195528ygrp-msg p a {font-family:Verdana;}#yiv7956195528 #yiv7956195528ygrp-msg p#yiv7956195528attach-count span {color:#1E66AE;font-weight:700;}#yiv7956195528 #yiv7956195528ygrp-reco #yiv7956195528reco-head {color:#ff7900;font-weight:700;}#yiv7956195528 #yiv7956195528ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ov li a {font-size:130%;text-decoration:none;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7956195528 #yiv7956195528ygrp-sponsor #yiv7956195528ov ul {margin:0;padding:0 0 0 8px;}#yiv7956195528 #yiv7956195528ygrp-text {font-family:Georgia;}#yiv7956195528 #yiv7956195528ygrp-text p {margin:0 0 1em 0;}#yiv7956195528 #yiv7956195528ygrp-text tt {font-size:120%;}#yiv7956195528 #yiv7956195528ygrp-vital ul li:last-child {border-right:none !important;}#yiv7956195528
