[belajar-excel] Digest Number 4405

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4405

1a

Re: Cara Gabung Tabel Beda Workbook dan Beda Komputer by "hendrik karnadi" hendrikkarnadi

2

Print slip gaji by "go tjwan ham" go_tjwan_ham

Messages

1a

Re: Cara Gabung Tabel Beda Workbook dan Beda Komputer

Sat Jan 13, 2018 12:07 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sama2.Jangan lupa share hasilnya.....
Salam,HK

Sent from Yahoo Mail on Android

On Fri, Jan 12, 2018 at 21:19, kiki tanjung kieki_e@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Dear Pak Hendrik
Terima kasih atas pencerahannya
Saya coba pahami dlu Pak..
On Friday, January 12, 2018, 3:25:15 PM GMT+7, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Hai Kiki,
Coba Extract .zip File ini ke suatu Folder atau Sub Folder mana saja.Buka File Consolidate (TB R_HK + Kid) krn SQL nya dibantu Mr. Kid.Hapus Tabel Hasil Query.Klik button "Consolidate" dan lihat hasilnya.Setelah memahami cara kerjanya, coba pindahkan beberapa filenya ke beberapa Dir:\SubDir dalam satu komputer dan ganti <Path> dengan nama Dir:\SubDir (sesuai dengan tempat2 dimana file2 tsb berada).
Saya blm pernah mencoba untuk beda komputer dalam satu jaringan --> silakan dicoba dan diinfo hasilnya ke milis.
Kalau sdh berhasil baru dicoba ke file asli yang akan dicombined dengan menyesuaikan script SQL nya (jangan lupa untuk memback up file2nya terlebih dahulu).
Selamat mencoba.
Salam,HK

On Friday, 12 January 2018, 2:17:29 PM GMT+7, kiki tanjung kieki_e@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear Teman Teman
Mohon bantuan dan pencerahan untuk kasus berikut :

#yiv2226490861 #yiv2226490861 -- #yiv2226490861ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2226490861 #yiv2226490861ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2226490861 #yiv2226490861ygrp-mkp #yiv2226490861hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2226490861 #yiv2226490861ygrp-mkp #yiv2226490861ads {margin-bottom:10px;}#yiv2226490861 #yiv2226490861ygrp-mkp .yiv2226490861ad {padding:0 0;}#yiv2226490861 #yiv2226490861ygrp-mkp .yiv2226490861ad p {margin:0;}#yiv2226490861 #yiv2226490861ygrp-mkp .yiv2226490861ad a {color:#0000ff;text-decoration:none;}#yiv2226490861 #yiv2226490861ygrp-sponsor #yiv2226490861ygrp-lc {font-family:Arial;}#yiv2226490861 #yiv2226490861ygrp-sponsor #yiv2226490861ygrp-lc #yiv2226490861hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2226490861 #yiv2226490861ygrp-sponsor #yiv2226490861ygrp-lc .yiv2226490861ad {margin-bottom:10px;padding:0 0;}#yiv2226490861 #yiv2226490861actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2226490861 #yiv2226490861activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2226490861 #yiv2226490861activity span {font-weight:700;}#yiv2226490861 #yiv2226490861activity span:first-child {text-transform:uppercase;}#yiv2226490861 #yiv2226490861activity span a {color:#5085b6;text-decoration:none;}#yiv2226490861 #yiv2226490861activity span span {color:#ff7900;}#yiv2226490861 #yiv2226490861activity span .yiv2226490861underline {text-decoration:underline;}#yiv2226490861 .yiv2226490861attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2226490861 .yiv2226490861attach div a {text-decoration:none;}#yiv2226490861 .yiv2226490861attach img {border:none;padding-right:5px;}#yiv2226490861 .yiv2226490861attach label {display:block;margin-bottom:5px;}#yiv2226490861 .yiv2226490861attach label a {text-decoration:none;}#yiv2226490861 blockquote {margin:0 0 0 4px;}#yiv2226490861 .yiv2226490861bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2226490861 .yiv2226490861bold a {text-decoration:none;}#yiv2226490861 dd.yiv2226490861last p a {font-family:Verdana;font-weight:700;}#yiv2226490861 dd.yiv2226490861last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2226490861 dd.yiv2226490861last p span.yiv2226490861yshortcuts {margin-right:0;}#yiv2226490861 div.yiv2226490861attach-table div div a {text-decoration:none;}#yiv2226490861 div.yiv2226490861attach-table {width:400px;}#yiv2226490861 div.yiv2226490861file-title a, #yiv2226490861 div.yiv2226490861file-title a:active, #yiv2226490861 div.yiv2226490861file-title a:hover, #yiv2226490861 div.yiv2226490861file-title a:visited {text-decoration:none;}#yiv2226490861 div.yiv2226490861photo-title a, #yiv2226490861 div.yiv2226490861photo-title a:active, #yiv2226490861 div.yiv2226490861photo-title a:hover, #yiv2226490861 div.yiv2226490861photo-title a:visited {text-decoration:none;}#yiv2226490861 div#yiv2226490861ygrp-mlmsg #yiv2226490861ygrp-msg p a span.yiv2226490861yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2226490861 .yiv2226490861green {color:#628c2a;}#yiv2226490861 .yiv2226490861MsoNormal {margin:0 0 0 0;}#yiv2226490861 o {font-size:0;}#yiv2226490861 #yiv2226490861photos div {float:left;width:72px;}#yiv2226490861 #yiv2226490861photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2226490861 #yiv2226490861photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2226490861 #yiv2226490861reco-category {font-size:77%;}#yiv2226490861 #yiv2226490861reco-desc {font-size:77%;}#yiv2226490861 .yiv2226490861replbq {margin:4px;}#yiv2226490861 #yiv2226490861ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2226490861 #yiv2226490861ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2226490861 #yiv2226490861ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2226490861 #yiv2226490861ygrp-mlmsg select, #yiv2226490861 input, #yiv2226490861 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2226490861 #yiv2226490861ygrp-mlmsg pre, #yiv2226490861 code {font:115% monospace;}#yiv2226490861 #yiv2226490861ygrp-mlmsg * {line-height:1.22em;}#yiv2226490861 #yiv2226490861ygrp-mlmsg #yiv2226490861logo {padding-bottom:10px;}#yiv2226490861 #yiv2226490861ygrp-msg p a {font-family:Verdana;}#yiv2226490861 #yiv2226490861ygrp-msg p#yiv2226490861attach-count span {color:#1E66AE;font-weight:700;}#yiv2226490861 #yiv2226490861ygrp-reco #yiv2226490861reco-head {color:#ff7900;font-weight:700;}#yiv2226490861 #yiv2226490861ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2226490861 #yiv2226490861ygrp-sponsor #yiv2226490861ov li a {font-size:130%;text-decoration:none;}#yiv2226490861 #yiv2226490861ygrp-sponsor #yiv2226490861ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2226490861 #yiv2226490861ygrp-sponsor #yiv2226490861ov ul {margin:0;padding:0 0 0 8px;}#yiv2226490861 #yiv2226490861ygrp-text {font-family:Georgia;}#yiv2226490861 #yiv2226490861ygrp-text p {margin:0 0 1em 0;}#yiv2226490861 #yiv2226490861ygrp-text tt {font-size:120%;}#yiv2226490861 #yiv2226490861ygrp-vital ul li:last-child {border-right:none !important;}#yiv2226490861

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2

Print slip gaji

Sat Jan 13, 2018 10:39 am (PST) . Posted by:

"go tjwan ham" go_tjwan_ham

Dear Para Master Excel,
Mohon bantuannya untuk membuat menu print slip gaji otomatis.File saya lampirkan.Terimakasih banyak atas bantuannya.
Regards,
Ham

Sent from Yahoo Mail on Android
Sent from Yahoo Mail on Android

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use