Jumat, 20 Mei 2016

[belajar-excel] Digest Number 3857

15 Messages

Digest #3857
1a
Re: Userform by "nopan ji"
2b
2c
5
Special Edit Data by "Harry" hariansyahptk

Messages

Fri May 20, 2016 3:08 am (PDT) . Posted by:

"nopan ji"

Maaf, mas regard, sy tdk bisa memakai rumusnya, bs ga mas berikan contoh
berupa filenya, maklum sy biasa nyontek rumus yang di web dan teman2
forum...

Pada tanggal 17 Mei 2016 23.17, "'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

>
>
> Hai Nopan,
>
> misal workbook yang sedang dibuka bernama wbkA.xlsm ingin membuka userform
> yang ada di 'wbkForm Inputan User.xlsm' yang ada di path
> *d:\data\foldernya*
>

> Langkah :
> 1. siapkan sebuah prosedur pemanggil userform di dalam 'wbkForm Inputan
> User.xlsm'
> > misal di sebuah module general ada sebuah prosedur pemanggil
> userform bernama PemanggilForm
> Public sub PemanggilForm()
> userformPilihan.show
> end sub
> > save dan tutup 'wbkForm Inputan User.xlsm'
>
> 2. di workbook wbkA.xlsm ada sebuah prosedur proses misalnya bernama
> *OpsiPilihanUser*
> Public sub *OpsiPilihanUser*()
> 'blablabla semua proses awal yang dikerjakan form ini
> disini
>
> 'proses berikutnya adalah menampilkan userformPilihan yang
> ada di 'wbkForm Inputan User.xlsm' melalui prosedur bernama PemanggilForm
> Application.run "'*d:\data\foldernya*\wbkForm Inputan
> User.xlsm'!PemanggilForm"
> end sub
>
> 3. save dan jalankan prosedur *OpsiPilihanUser*
>
> Selamat mencoba
>
> Regards,
> Kid
>
>
>
>
> 2016-05-17 21:15 GMT+07:00 nopan ji nopanji@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>>
>>
>> Mester excel yg baik, minta bantuan memanggil userform di file lain bs ga
>> ya...
>>
>>
>
>

Fri May 20, 2016 3:19 am (PDT) . Posted by:

"odong nando"

coba masukan formula
=INDEX(Sheet2!$J$6:$K$40;MATCH(G6;Sheet2!$E$6:$E$40;0);MATCH(DATA!H6;Sheet2!$J$5:$K$5;0))
 pada cell E5 sheet data.jika regioanal kompi setempat english maka ganti karakter titik koma ";" menjadi koma ","
br,

odong nando

Dari: "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 19 Mei 2016 12:24
Judul: [belajar-excel] vLookUp atau Index Match ? [1 Attachment]

  Dear BeExceller

mohon bantuannya dear master excel untuk mengisi kolom bensin dengan data terlampir caranya gimana
sebelumnya saya terima kasih atas bantuannya...

Regards,cobain
#yiv7441046690 #yiv7441046690 -- #yiv7441046690ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7441046690 #yiv7441046690ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7441046690 #yiv7441046690ygrp-mkp #yiv7441046690hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7441046690 #yiv7441046690ygrp-mkp #yiv7441046690ads {margin-bottom:10px;}#yiv7441046690 #yiv7441046690ygrp-mkp .yiv7441046690ad {padding:0 0;}#yiv7441046690 #yiv7441046690ygrp-mkp .yiv7441046690ad p {margin:0;}#yiv7441046690 #yiv7441046690ygrp-mkp .yiv7441046690ad a {color:#0000ff;text-decoration:none;}#yiv7441046690 #yiv7441046690ygrp-sponsor #yiv7441046690ygrp-lc {font-family:Arial;}#yiv7441046690 #yiv7441046690ygrp-sponsor #yiv7441046690ygrp-lc #yiv7441046690hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7441046690 #yiv7441046690ygrp-sponsor #yiv7441046690ygrp-lc .yiv7441046690ad {margin-bottom:10px;padding:0 0;}#yiv7441046690 #yiv7441046690actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7441046690 #yiv7441046690activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7441046690 #yiv7441046690activity span {font-weight:700;}#yiv7441046690 #yiv7441046690activity span:first-child {text-transform:uppercase;}#yiv7441046690 #yiv7441046690activity span a {color:#5085b6;text-decoration:none;}#yiv7441046690 #yiv7441046690activity span span {color:#ff7900;}#yiv7441046690 #yiv7441046690activity span .yiv7441046690underline {text-decoration:underline;}#yiv7441046690 .yiv7441046690attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7441046690 .yiv7441046690attach div a {text-decoration:none;}#yiv7441046690 .yiv7441046690attach img {border:none;padding-right:5px;}#yiv7441046690 .yiv7441046690attach label {display:block;margin-bottom:5px;}#yiv7441046690 .yiv7441046690attach label a {text-decoration:none;}#yiv7441046690 blockquote {margin:0 0 0 4px;}#yiv7441046690 .yiv7441046690bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7441046690 .yiv7441046690bold a {text-decoration:none;}#yiv7441046690 dd.yiv7441046690last p a {font-family:Verdana;font-weight:700;}#yiv7441046690 dd.yiv7441046690last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7441046690 dd.yiv7441046690last p span.yiv7441046690yshortcuts {margin-right:0;}#yiv7441046690 div.yiv7441046690attach-table div div a {text-decoration:none;}#yiv7441046690 div.yiv7441046690attach-table {width:400px;}#yiv7441046690 div.yiv7441046690file-title a, #yiv7441046690 div.yiv7441046690file-title a:active, #yiv7441046690 div.yiv7441046690file-title a:hover, #yiv7441046690 div.yiv7441046690file-title a:visited {text-decoration:none;}#yiv7441046690 div.yiv7441046690photo-title a, #yiv7441046690 div.yiv7441046690photo-title a:active, #yiv7441046690 div.yiv7441046690photo-title a:hover, #yiv7441046690 div.yiv7441046690photo-title a:visited {text-decoration:none;}#yiv7441046690 div#yiv7441046690ygrp-mlmsg #yiv7441046690ygrp-msg p a span.yiv7441046690yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7441046690 .yiv7441046690green {color:#628c2a;}#yiv7441046690 .yiv7441046690MsoNormal {margin:0 0 0 0;}#yiv7441046690 o {font-size:0;}#yiv7441046690 #yiv7441046690photos div {float:left;width:72px;}#yiv7441046690 #yiv7441046690photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7441046690 #yiv7441046690photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7441046690 #yiv7441046690reco-category {font-size:77%;}#yiv7441046690 #yiv7441046690reco-desc {font-size:77%;}#yiv7441046690 .yiv7441046690replbq {margin:4px;}#yiv7441046690 #yiv7441046690ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7441046690 #yiv7441046690ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7441046690 #yiv7441046690ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7441046690 #yiv7441046690ygrp-mlmsg select, #yiv7441046690 input, #yiv7441046690 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7441046690 #yiv7441046690ygrp-mlmsg pre, #yiv7441046690 code {font:115% monospace;}#yiv7441046690 #yiv7441046690ygrp-mlmsg * {line-height:1.22em;}#yiv7441046690 #yiv7441046690ygrp-mlmsg #yiv7441046690logo {padding-bottom:10px;}#yiv7441046690 #yiv7441046690ygrp-msg p a {font-family:Verdana;}#yiv7441046690 #yiv7441046690ygrp-msg p#yiv7441046690attach-count span {color:#1E66AE;font-weight:700;}#yiv7441046690 #yiv7441046690ygrp-reco #yiv7441046690reco-head {color:#ff7900;font-weight:700;}#yiv7441046690 #yiv7441046690ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7441046690 #yiv7441046690ygrp-sponsor #yiv7441046690ov li a {font-size:130%;text-decoration:none;}#yiv7441046690 #yiv7441046690ygrp-sponsor #yiv7441046690ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7441046690 #yiv7441046690ygrp-sponsor #yiv7441046690ov ul {margin:0;padding:0 0 0 8px;}#yiv7441046690 #yiv7441046690ygrp-text {font-family:Georgia;}#yiv7441046690 #yiv7441046690ygrp-text p {margin:0 0 1em 0;}#yiv7441046690 #yiv7441046690ygrp-text tt {font-size:120%;}#yiv7441046690 #yiv7441046690ygrp-vital ul li:last-child {border-right:none !important;}#yiv7441046690

Fri May 20, 2016 8:23 pm (PDT) . Posted by:

"Cobain Donk" cobaindonk31

terima kasih banyak atas bantuan yg diberikan  sama master master excel 
salam hormat
cobain 

Pada Jumat, 20 Mei 2016 17:19, "odong nando odongnando@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  coba masukan formula
=INDEX(Sheet2!$J$6:$K$40;MATCH(G6;Sheet2!$E$6:$E$40;0);MATCH(DATA!H6;Sheet2!$J$5:$K$5;0))
 pada cell E5 sheet data.jika regioanal kompi setempat english maka ganti karakter titik koma ";" menjadi koma ","
br,

odong nando

Dari: "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 19 Mei 2016 12:24
Judul: [belajar-excel] vLookUp atau Index Match ? [1 Attachment]

  Dear BeExceller

mohon bantuannya dear master excel untuk mengisi kolom bensin dengan data terlampir caranya gimana
sebelumnya saya terima kasih atas bantuannya...

Regards,cobain


#yiv7485967195 #yiv7485967195 -- #yiv7485967195ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7485967195 #yiv7485967195ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7485967195 #yiv7485967195ygrp-mkp #yiv7485967195hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7485967195 #yiv7485967195ygrp-mkp #yiv7485967195ads {margin-bottom:10px;}#yiv7485967195 #yiv7485967195ygrp-mkp .yiv7485967195ad {padding:0 0;}#yiv7485967195 #yiv7485967195ygrp-mkp .yiv7485967195ad p {margin:0;}#yiv7485967195 #yiv7485967195ygrp-mkp .yiv7485967195ad a {color:#0000ff;text-decoration:none;}#yiv7485967195 #yiv7485967195ygrp-sponsor #yiv7485967195ygrp-lc {font-family:Arial;}#yiv7485967195 #yiv7485967195ygrp-sponsor #yiv7485967195ygrp-lc #yiv7485967195hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7485967195 #yiv7485967195ygrp-sponsor #yiv7485967195ygrp-lc .yiv7485967195ad {margin-bottom:10px;padding:0 0;}#yiv7485967195 #yiv7485967195actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7485967195 #yiv7485967195activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7485967195 #yiv7485967195activity span {font-weight:700;}#yiv7485967195 #yiv7485967195activity span:first-child {text-transform:uppercase;}#yiv7485967195 #yiv7485967195activity span a {color:#5085b6;text-decoration:none;}#yiv7485967195 #yiv7485967195activity span span {color:#ff7900;}#yiv7485967195 #yiv7485967195activity span .yiv7485967195underline {text-decoration:underline;}#yiv7485967195 .yiv7485967195attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7485967195 .yiv7485967195attach div a {text-decoration:none;}#yiv7485967195 .yiv7485967195attach img {border:none;padding-right:5px;}#yiv7485967195 .yiv7485967195attach label {display:block;margin-bottom:5px;}#yiv7485967195 .yiv7485967195attach label a {text-decoration:none;}#yiv7485967195 blockquote {margin:0 0 0 4px;}#yiv7485967195 .yiv7485967195bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7485967195 .yiv7485967195bold a {text-decoration:none;}#yiv7485967195 dd.yiv7485967195last p a {font-family:Verdana;font-weight:700;}#yiv7485967195 dd.yiv7485967195last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7485967195 dd.yiv7485967195last p span.yiv7485967195yshortcuts {margin-right:0;}#yiv7485967195 div.yiv7485967195attach-table div div a {text-decoration:none;}#yiv7485967195 div.yiv7485967195attach-table {width:400px;}#yiv7485967195 div.yiv7485967195file-title a, #yiv7485967195 div.yiv7485967195file-title a:active, #yiv7485967195 div.yiv7485967195file-title a:hover, #yiv7485967195 div.yiv7485967195file-title a:visited {text-decoration:none;}#yiv7485967195 div.yiv7485967195photo-title a, #yiv7485967195 div.yiv7485967195photo-title a:active, #yiv7485967195 div.yiv7485967195photo-title a:hover, #yiv7485967195 div.yiv7485967195photo-title a:visited {text-decoration:none;}#yiv7485967195 div#yiv7485967195ygrp-mlmsg #yiv7485967195ygrp-msg p a span.yiv7485967195yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7485967195 .yiv7485967195green {color:#628c2a;}#yiv7485967195 .yiv7485967195MsoNormal {margin:0 0 0 0;}#yiv7485967195 o {font-size:0;}#yiv7485967195 #yiv7485967195photos div {float:left;width:72px;}#yiv7485967195 #yiv7485967195photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7485967195 #yiv7485967195photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7485967195 #yiv7485967195reco-category {font-size:77%;}#yiv7485967195 #yiv7485967195reco-desc {font-size:77%;}#yiv7485967195 .yiv7485967195replbq {margin:4px;}#yiv7485967195 #yiv7485967195ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7485967195 #yiv7485967195ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7485967195 #yiv7485967195ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7485967195 #yiv7485967195ygrp-mlmsg select, #yiv7485967195 input, #yiv7485967195 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7485967195 #yiv7485967195ygrp-mlmsg pre, #yiv7485967195 code {font:115% monospace;}#yiv7485967195 #yiv7485967195ygrp-mlmsg * {line-height:1.22em;}#yiv7485967195 #yiv7485967195ygrp-mlmsg #yiv7485967195logo {padding-bottom:10px;}#yiv7485967195 #yiv7485967195ygrp-msg p a {font-family:Verdana;}#yiv7485967195 #yiv7485967195ygrp-msg p#yiv7485967195attach-count span {color:#1E66AE;font-weight:700;}#yiv7485967195 #yiv7485967195ygrp-reco #yiv7485967195reco-head {color:#ff7900;font-weight:700;}#yiv7485967195 #yiv7485967195ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7485967195 #yiv7485967195ygrp-sponsor #yiv7485967195ov li a {font-size:130%;text-decoration:none;}#yiv7485967195 #yiv7485967195ygrp-sponsor #yiv7485967195ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7485967195 #yiv7485967195ygrp-sponsor #yiv7485967195ov ul {margin:0;padding:0 0 0 8px;}#yiv7485967195 #yiv7485967195ygrp-text {font-family:Georgia;}#yiv7485967195 #yiv7485967195ygrp-text p {margin:0 0 1em 0;}#yiv7485967195 #yiv7485967195ygrp-text tt {font-size:120%;}#yiv7485967195 #yiv7485967195ygrp-vital ul li:last-child {border-right:none !important;}#yiv7485967195

Fri May 20, 2016 8:23 pm (PDT) . Posted by:

"Cobain Donk" cobaindonk31

terima kasih banyak atas bantuan yg diberikan  sama master master excel 
salam hormat
cobain 

Pada Kamis, 19 Mei 2016 15:10, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  coba pake formula di kolom Bensin :
=IFERROR(IF(H6="SEPEDA MOTOR",INDEX(Sheet2!$J$6:$J$40,MATCH(DATA!G6,Sheet2!$E$6:$E$40,0)),INDEX(Sheet2!$K$6:$K$40,MATCH(DATA!G6,Sheet2!$E$6:$E$40,0))),"")

Jangan lupa tekan Shift+Ctrl+Enter karena array formula

TerimaKasih.

Pada Kamis, 19 Mei 2016 13:33, "Cobain Donk cobaindonk31@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear BeExceller

mohon bantuannya dear master excel untuk mengisi kolom bensin dengan data terlampir caranya gimana
sebelumnya saya terima kasih atas bantuannya...

Regards,cobain


#yiv2549139537 #yiv2549139537 -- #yiv2549139537ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2549139537 #yiv2549139537ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2549139537 #yiv2549139537ygrp-mkp #yiv2549139537hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2549139537 #yiv2549139537ygrp-mkp #yiv2549139537ads {margin-bottom:10px;}#yiv2549139537 #yiv2549139537ygrp-mkp .yiv2549139537ad {padding:0 0;}#yiv2549139537 #yiv2549139537ygrp-mkp .yiv2549139537ad p {margin:0;}#yiv2549139537 #yiv2549139537ygrp-mkp .yiv2549139537ad a {color:#0000ff;text-decoration:none;}#yiv2549139537 #yiv2549139537ygrp-sponsor #yiv2549139537ygrp-lc {font-family:Arial;}#yiv2549139537 #yiv2549139537ygrp-sponsor #yiv2549139537ygrp-lc #yiv2549139537hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2549139537 #yiv2549139537ygrp-sponsor #yiv2549139537ygrp-lc .yiv2549139537ad {margin-bottom:10px;padding:0 0;}#yiv2549139537 #yiv2549139537actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2549139537 #yiv2549139537activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2549139537 #yiv2549139537activity span {font-weight:700;}#yiv2549139537 #yiv2549139537activity span:first-child {text-transform:uppercase;}#yiv2549139537 #yiv2549139537activity span a {color:#5085b6;text-decoration:none;}#yiv2549139537 #yiv2549139537activity span span {color:#ff7900;}#yiv2549139537 #yiv2549139537activity span .yiv2549139537underline {text-decoration:underline;}#yiv2549139537 .yiv2549139537attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2549139537 .yiv2549139537attach div a {text-decoration:none;}#yiv2549139537 .yiv2549139537attach img {border:none;padding-right:5px;}#yiv2549139537 .yiv2549139537attach label {display:block;margin-bottom:5px;}#yiv2549139537 .yiv2549139537attach label a {text-decoration:none;}#yiv2549139537 blockquote {margin:0 0 0 4px;}#yiv2549139537 .yiv2549139537bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2549139537 .yiv2549139537bold a {text-decoration:none;}#yiv2549139537 dd.yiv2549139537last p a {font-family:Verdana;font-weight:700;}#yiv2549139537 dd.yiv2549139537last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2549139537 dd.yiv2549139537last p span.yiv2549139537yshortcuts {margin-right:0;}#yiv2549139537 div.yiv2549139537attach-table div div a {text-decoration:none;}#yiv2549139537 div.yiv2549139537attach-table {width:400px;}#yiv2549139537 div.yiv2549139537file-title a, #yiv2549139537 div.yiv2549139537file-title a:active, #yiv2549139537 div.yiv2549139537file-title a:hover, #yiv2549139537 div.yiv2549139537file-title a:visited {text-decoration:none;}#yiv2549139537 div.yiv2549139537photo-title a, #yiv2549139537 div.yiv2549139537photo-title a:active, #yiv2549139537 div.yiv2549139537photo-title a:hover, #yiv2549139537 div.yiv2549139537photo-title a:visited {text-decoration:none;}#yiv2549139537 div#yiv2549139537ygrp-mlmsg #yiv2549139537ygrp-msg p a span.yiv2549139537yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2549139537 .yiv2549139537green {color:#628c2a;}#yiv2549139537 .yiv2549139537MsoNormal {margin:0 0 0 0;}#yiv2549139537 o {font-size:0;}#yiv2549139537 #yiv2549139537photos div {float:left;width:72px;}#yiv2549139537 #yiv2549139537photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2549139537 #yiv2549139537photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2549139537 #yiv2549139537reco-category {font-size:77%;}#yiv2549139537 #yiv2549139537reco-desc {font-size:77%;}#yiv2549139537 .yiv2549139537replbq {margin:4px;}#yiv2549139537 #yiv2549139537ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2549139537 #yiv2549139537ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2549139537 #yiv2549139537ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2549139537 #yiv2549139537ygrp-mlmsg select, #yiv2549139537 input, #yiv2549139537 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2549139537 #yiv2549139537ygrp-mlmsg pre, #yiv2549139537 code {font:115% monospace;}#yiv2549139537 #yiv2549139537ygrp-mlmsg * {line-height:1.22em;}#yiv2549139537 #yiv2549139537ygrp-mlmsg #yiv2549139537logo {padding-bottom:10px;}#yiv2549139537 #yiv2549139537ygrp-msg p a {font-family:Verdana;}#yiv2549139537 #yiv2549139537ygrp-msg p#yiv2549139537attach-count span {color:#1E66AE;font-weight:700;}#yiv2549139537 #yiv2549139537ygrp-reco #yiv2549139537reco-head {color:#ff7900;font-weight:700;}#yiv2549139537 #yiv2549139537ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2549139537 #yiv2549139537ygrp-sponsor #yiv2549139537ov li a {font-size:130%;text-decoration:none;}#yiv2549139537 #yiv2549139537ygrp-sponsor #yiv2549139537ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2549139537 #yiv2549139537ygrp-sponsor #yiv2549139537ov ul {margin:0;padding:0 0 0 8px;}#yiv2549139537 #yiv2549139537ygrp-text {font-family:Georgia;}#yiv2549139537 #yiv2549139537ygrp-text p {margin:0 0 1em 0;}#yiv2549139537 #yiv2549139537ygrp-text tt {font-size:120%;}#yiv2549139537 #yiv2549139537ygrp-vital ul li:last-child {border-right:none !important;}#yiv2549139537

Fri May 20, 2016 4:30 am (PDT) . Posted by:

"odong nando"

lampiran berikut tidak sepenuhnya sesuai dengan keinginan, namun keinginan untuk memunculkan urutan yang tidak terdapat dalam data dapat terpenuhi br,

odong nando

Dari: "fcb.ind8@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Jumat, 20 Mei 2016 13:02
Judul: [belajar-excel] mohon bantuannya master mengenai klompok data [1 Attachment]

  siang milis blajar excel dn master. sy msih blm bisa utk tugas sprti ini mmg masih baca2 bljr ttg excel . brharap master mau membantu..
hatur nuhun #yiv6536982907 #yiv6536982907 -- #yiv6536982907ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6536982907 #yiv6536982907ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6536982907 #yiv6536982907ygrp-mkp #yiv6536982907hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6536982907 #yiv6536982907ygrp-mkp #yiv6536982907ads {margin-bottom:10px;}#yiv6536982907 #yiv6536982907ygrp-mkp .yiv6536982907ad {padding:0 0;}#yiv6536982907 #yiv6536982907ygrp-mkp .yiv6536982907ad p {margin:0;}#yiv6536982907 #yiv6536982907ygrp-mkp .yiv6536982907ad a {color:#0000ff;text-decoration:none;}#yiv6536982907 #yiv6536982907ygrp-sponsor #yiv6536982907ygrp-lc {font-family:Arial;}#yiv6536982907 #yiv6536982907ygrp-sponsor #yiv6536982907ygrp-lc #yiv6536982907hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6536982907 #yiv6536982907ygrp-sponsor #yiv6536982907ygrp-lc .yiv6536982907ad {margin-bottom:10px;padding:0 0;}#yiv6536982907 #yiv6536982907actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6536982907 #yiv6536982907activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6536982907 #yiv6536982907activity span {font-weight:700;}#yiv6536982907 #yiv6536982907activity span:first-child {text-transform:uppercase;}#yiv6536982907 #yiv6536982907activity span a {color:#5085b6;text-decoration:none;}#yiv6536982907 #yiv6536982907activity span span {color:#ff7900;}#yiv6536982907 #yiv6536982907activity span .yiv6536982907underline {text-decoration:underline;}#yiv6536982907 .yiv6536982907attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6536982907 .yiv6536982907attach div a {text-decoration:none;}#yiv6536982907 .yiv6536982907attach img {border:none;padding-right:5px;}#yiv6536982907 .yiv6536982907attach label {display:block;margin-bottom:5px;}#yiv6536982907 .yiv6536982907attach label a {text-decoration:none;}#yiv6536982907 blockquote {margin:0 0 0 4px;}#yiv6536982907 .yiv6536982907bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6536982907 .yiv6536982907bold a {text-decoration:none;}#yiv6536982907 dd.yiv6536982907last p a {font-family:Verdana;font-weight:700;}#yiv6536982907 dd.yiv6536982907last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6536982907 dd.yiv6536982907last p span.yiv6536982907yshortcuts {margin-right:0;}#yiv6536982907 div.yiv6536982907attach-table div div a {text-decoration:none;}#yiv6536982907 div.yiv6536982907attach-table {width:400px;}#yiv6536982907 div.yiv6536982907file-title a, #yiv6536982907 div.yiv6536982907file-title a:active, #yiv6536982907 div.yiv6536982907file-title a:hover, #yiv6536982907 div.yiv6536982907file-title a:visited {text-decoration:none;}#yiv6536982907 div.yiv6536982907photo-title a, #yiv6536982907 div.yiv6536982907photo-title a:active, #yiv6536982907 div.yiv6536982907photo-title a:hover, #yiv6536982907 div.yiv6536982907photo-title a:visited {text-decoration:none;}#yiv6536982907 div#yiv6536982907ygrp-mlmsg #yiv6536982907ygrp-msg p a span.yiv6536982907yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6536982907 .yiv6536982907green {color:#628c2a;}#yiv6536982907 .yiv6536982907MsoNormal {margin:0 0 0 0;}#yiv6536982907 o {font-size:0;}#yiv6536982907 #yiv6536982907photos div {float:left;width:72px;}#yiv6536982907 #yiv6536982907photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6536982907 #yiv6536982907photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6536982907 #yiv6536982907reco-category {font-size:77%;}#yiv6536982907 #yiv6536982907reco-desc {font-size:77%;}#yiv6536982907 .yiv6536982907replbq {margin:4px;}#yiv6536982907 #yiv6536982907ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6536982907 #yiv6536982907ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6536982907 #yiv6536982907ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6536982907 #yiv6536982907ygrp-mlmsg select, #yiv6536982907 input, #yiv6536982907 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6536982907 #yiv6536982907ygrp-mlmsg pre, #yiv6536982907 code {font:115% monospace;}#yiv6536982907 #yiv6536982907ygrp-mlmsg * {line-height:1.22em;}#yiv6536982907 #yiv6536982907ygrp-mlmsg #yiv6536982907logo {padding-bottom:10px;}#yiv6536982907 #yiv6536982907ygrp-msg p a {font-family:Verdana;}#yiv6536982907 #yiv6536982907ygrp-msg p#yiv6536982907attach-count span {color:#1E66AE;font-weight:700;}#yiv6536982907 #yiv6536982907ygrp-reco #yiv6536982907reco-head {color:#ff7900;font-weight:700;}#yiv6536982907 #yiv6536982907ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6536982907 #yiv6536982907ygrp-sponsor #yiv6536982907ov li a {font-size:130%;text-decoration:none;}#yiv6536982907 #yiv6536982907ygrp-sponsor #yiv6536982907ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6536982907 #yiv6536982907ygrp-sponsor #yiv6536982907ov ul {margin:0;padding:0 0 0 8px;}#yiv6536982907 #yiv6536982907ygrp-text {font-family:Georgia;}#yiv6536982907 #yiv6536982907ygrp-text p {margin:0 0 1em 0;}#yiv6536982907 #yiv6536982907ygrp-text tt {font-size:120%;}#yiv6536982907 #yiv6536982907ygrp-vital ul li:last-child {border-right:none !important;}#yiv6536982907

Fri May 20, 2016 5:32 am (PDT) . Posted by:

"Ayub Barin"

Salam Hormat dan Salut Mas.Toby

Terima kasih <file.close> sangat sangat membantu dan sesuai harapan,
Terima kasih juga buat master yang lain.

Salam Hormat dan Salut

Fri May 20, 2016 7:03 am (PDT) . Posted by:

"Ayub Barin"

Salam Hormat dan Super Salut Mas.Toby

Mohon maaf sebelumnya, krn minimnya pengetahuan, saya mau tanya.., di VBA
nya bagian mana yg membaca ke cell F8:F19, atas jawan terima kasih
sebelumnya...,

Salam Hormat dan Salut

Fri May 20, 2016 9:48 pm (PDT) . Posted by:

"Toby kenzo" tobykenzo

Hai Ayub,
Untuk Cell F8:F19 di protect cell, anda bisa tahu formulanya jika sudah di unprotect.Passwordnya:123
TerimaKasih.


Pada Jumat, 20 Mei 2016 21:03, "Ayub Barin ayubbarin@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Salam Hormat dan Super Salut Mas.TobyMohon maaf sebelumnya, krn minimnya pengetahuan, saya mau tanya.., di VBA nya bagian mana yg membaca ke cell F8:F19, atas jawan terima kasih sebelumnya...,Salam Hormat dan Salut #yiv8430286124 #yiv8430286124 -- #yiv8430286124ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8430286124 #yiv8430286124ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8430286124 #yiv8430286124ygrp-mkp #yiv8430286124hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8430286124 #yiv8430286124ygrp-mkp #yiv8430286124ads {margin-bottom:10px;}#yiv8430286124 #yiv8430286124ygrp-mkp .yiv8430286124ad {padding:0 0;}#yiv8430286124 #yiv8430286124ygrp-mkp .yiv8430286124ad p {margin:0;}#yiv8430286124 #yiv8430286124ygrp-mkp .yiv8430286124ad a {color:#0000ff;text-decoration:none;}#yiv8430286124 #yiv8430286124ygrp-sponsor #yiv8430286124ygrp-lc {font-family:Arial;}#yiv8430286124 #yiv8430286124ygrp-sponsor #yiv8430286124ygrp-lc #yiv8430286124hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8430286124 #yiv8430286124ygrp-sponsor #yiv8430286124ygrp-lc .yiv8430286124ad {margin-bottom:10px;padding:0 0;}#yiv8430286124 #yiv8430286124actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8430286124 #yiv8430286124activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8430286124 #yiv8430286124activity span {font-weight:700;}#yiv8430286124 #yiv8430286124activity span:first-child {text-transform:uppercase;}#yiv8430286124 #yiv8430286124activity span a {color:#5085b6;text-decoration:none;}#yiv8430286124 #yiv8430286124activity span span {color:#ff7900;}#yiv8430286124 #yiv8430286124activity span .yiv8430286124underline {text-decoration:underline;}#yiv8430286124 .yiv8430286124attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8430286124 .yiv8430286124attach div a {text-decoration:none;}#yiv8430286124 .yiv8430286124attach img {border:none;padding-right:5px;}#yiv8430286124 .yiv8430286124attach label {display:block;margin-bottom:5px;}#yiv8430286124 .yiv8430286124attach label a {text-decoration:none;}#yiv8430286124 blockquote {margin:0 0 0 4px;}#yiv8430286124 .yiv8430286124bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8430286124 .yiv8430286124bold a {text-decoration:none;}#yiv8430286124 dd.yiv8430286124last p a {font-family:Verdana;font-weight:700;}#yiv8430286124 dd.yiv8430286124last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8430286124 dd.yiv8430286124last p span.yiv8430286124yshortcuts {margin-right:0;}#yiv8430286124 div.yiv8430286124attach-table div div a {text-decoration:none;}#yiv8430286124 div.yiv8430286124attach-table {width:400px;}#yiv8430286124 div.yiv8430286124file-title a, #yiv8430286124 div.yiv8430286124file-title a:active, #yiv8430286124 div.yiv8430286124file-title a:hover, #yiv8430286124 div.yiv8430286124file-title a:visited {text-decoration:none;}#yiv8430286124 div.yiv8430286124photo-title a, #yiv8430286124 div.yiv8430286124photo-title a:active, #yiv8430286124 div.yiv8430286124photo-title a:hover, #yiv8430286124 div.yiv8430286124photo-title a:visited {text-decoration:none;}#yiv8430286124 div#yiv8430286124ygrp-mlmsg #yiv8430286124ygrp-msg p a span.yiv8430286124yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8430286124 .yiv8430286124green {color:#628c2a;}#yiv8430286124 .yiv8430286124MsoNormal {margin:0 0 0 0;}#yiv8430286124 o {font-size:0;}#yiv8430286124 #yiv8430286124photos div {float:left;width:72px;}#yiv8430286124 #yiv8430286124photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8430286124 #yiv8430286124photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8430286124 #yiv8430286124reco-category {font-size:77%;}#yiv8430286124 #yiv8430286124reco-desc {font-size:77%;}#yiv8430286124 .yiv8430286124replbq {margin:4px;}#yiv8430286124 #yiv8430286124ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8430286124 #yiv8430286124ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8430286124 #yiv8430286124ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8430286124 #yiv8430286124ygrp-mlmsg select, #yiv8430286124 input, #yiv8430286124 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8430286124 #yiv8430286124ygrp-mlmsg pre, #yiv8430286124 code {font:115% monospace;}#yiv8430286124 #yiv8430286124ygrp-mlmsg * {line-height:1.22em;}#yiv8430286124 #yiv8430286124ygrp-mlmsg #yiv8430286124logo {padding-bottom:10px;}#yiv8430286124 #yiv8430286124ygrp-msg p a {font-family:Verdana;}#yiv8430286124 #yiv8430286124ygrp-msg p#yiv8430286124attach-count span {color:#1E66AE;font-weight:700;}#yiv8430286124 #yiv8430286124ygrp-reco #yiv8430286124reco-head {color:#ff7900;font-weight:700;}#yiv8430286124 #yiv8430286124ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8430286124 #yiv8430286124ygrp-sponsor #yiv8430286124ov li a {font-size:130%;text-decoration:none;}#yiv8430286124 #yiv8430286124ygrp-sponsor #yiv8430286124ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8430286124 #yiv8430286124ygrp-sponsor #yiv8430286124ov ul {margin:0;padding:0 0 0 8px;}#yiv8430286124 #yiv8430286124ygrp-text {font-family:Georgia;}#yiv8430286124 #yiv8430286124ygrp-text p {margin:0 0 1em 0;}#yiv8430286124 #yiv8430286124ygrp-text tt {font-size:120%;}#yiv8430286124 #yiv8430286124ygrp-vital ul li:last-child {border-right:none !important;}#yiv8430286124

Fri May 20, 2016 5:32 am (PDT) . Posted by:

"Harry" hariansyahptk

Dear Be-Exceller,
Sahabat Excel, sekalian mohon informasi mengenai studi kasus terlampir.Yang menjadi point penting bagi saya adalah proses editnya.Mohon berkenan informasinya ya.Besar harapan rekan-rekan Be-Exceller dapat membantu.
Terima kasih banyak sebelumnya.
Regards & Wasalam,

Harry

Fri May 20, 2016 5:33 am (PDT) . Posted by:

"farud oke"

Terimakasih semuanya krena sdah mau membantu..tpi skrg msih blm bsa
mencobanya krena lgi kluar kota,mgkin bru senin.tpi sya ucapkan trimakasih
untuk semuanya..
Pada tanggal 20 Mei 2016 2.44 PM, "Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

>
>
> Hai Farud,
>
> Coba contoh ini, ini menggunakan VBA, jadi jangan lupa activekan Macro
> Enabelednya.
> 1. Pada Sheet1 membuat table sesuai dengan angka yang di masukan pada
> kolom E2
> 2. Pada Sheet2 membuat table dengan menuliskan Nama Pembina.
> Untuk Sheet2 di batasi jumlah Nama Pembinanya.
>
> Semoga bisa membantu.
>
>
> TerimaKasih.
>
>
> Pada Jumat, 20 Mei 2016 10:40, "farud oke farud.oke@gmail.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
> penulisan formula vba-nya seperti apa mas soalnya saya awam & baru
> belajar masalah excel dan seluk beluknya.
> terimakasih sebelumnya
>
> Pada 20 Mei 2016 08.17, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] <
> belajar-excel@yahoogroups.com> menulis:
>
>
> Hai..
> Untuk membuat table seperti itu, anda harus menggunakan VBA dgn Event
> Worksheet_Change sebagai trigger untuk membuat berapa banyak cell yg di
> butuhkan untuk membuatnya, kemudian gunakan method "do while","Borders" dan
> "Cells / Range" untuk mewarnai cell atau range, gunakan method
> "Interior.color atau interior.colorindex"
> TerimaKasih.
> Sent from Yahoo Mail on Android
>
> ------------------------------
> * From: * farud oke farud.oke@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>;
> * To: * <belajar-excel@yahoogroups.com>;
> * Subject: * [belajar-excel] Membuat Baris otomatis sesuai dengan yang
> diisikan [1 Attachment]
> * Sent: * Thu, May 19, 2016 8:41:35 AM
>
>
> Assalamualaikum...
> Saya mendapatkan file (terlampir) dan ada 2 hal yg ingin saya tanyakan
> mohon bantuannya para master excel sekalian
> 1. Pada sheet "honor" di sell F2,N2,T2 dan Z2 apabila diisi dengan angka
> maka otomatis kebawah akan membuat tabel sesuai dengan banyaknya angka yang
> ditulis di sell tadi.Pertanyaanya : Bagaimana caranya sehingga sheet
> seperti itu bisa dibuat?
> 2. Pada sheet "daftar ptk" disell B4 kebawah apabila diisi akan membuat
> tabel kebawah secara otomatis juga.
> Pertanyaanya sama mas,bagaimana caranya membuat sheet yang seperti itu?
> Mohon penjelasannya mas karena saya lagi baru belajar jadi masih banyak
> yg tidak tau.
> Sebelumnya saya ucapkan terimakasih..
>
>
>
>
>
>

Fri May 20, 2016 6:39 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

File terlampir.

Regards,
Kid

2016-05-20 13:02 GMT+07:00 fcb.ind8@ymail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> siang milis blajar excel dn master. sy msih blm bisa utk tugas sprti ini
> mmg masih baca2 bljr ttg excel . brharap master mau membantu..
>
>
> hatur nuhun
>
>
>

Fri May 20, 2016 9:16 pm (PDT) . Posted by:

fcb.ind8@ymail.com

Hatur nuhun master odong dn mr kid untuk jalannya bisa memudahkn sy untuk bljar apa2 sja yg kurang.. 2 jmpol ..

Fri May 20, 2016 7:37 am (PDT) . Posted by:

"Harry" hariansyahptk

Dear Be-Exceller,
Lebih jauh mengenai topik ini, untuk proses Input Alhamdulillah sudah bisa.Permasalahannya adalah untuk proses Edit dan Hapus yang masih belum ketemu caranya.Mohon pencerahannya ya.
Terima kasih & Wassalam,

Harry

Pada Jumat, 30 November 2012 14:40, Mr. Kid <mr.nmkid@gmail.com> menulis:


  Pak Harry,

Coba file terlampir.

Syarat :
1. Ada library Microsoft ActiveX Data Object yang telah ter-install dan terdaftar dalam komputer setempat.
    >> Download dari Microsoft dan install

2. Tabel yang dikoneksi harus berkaidah database
    >> Cari pada posting-posting lama di milis tentang kaidah database

3. Menguasai bahasa SQL, terutama varian bahasa SQL yang digunakan oleh data provider.
    >> Cari di internet tentang SQL MS Access

4. Memahami cara penggunaan object dalam library di nomor 1
    >> Cari di internet tentang ADO (bukan ADODC, tapi cukup ADO atau ADODB)

5. Memahami karakteristik data provider yang digunakan.
    >> Cari di internet tentang Microsoft Jet 4.0 yang digunakan dalam file terlampir atau provider yang Anda gunakan sesuai keadaan nyata dilapangan.

Wassalam,
Kid.

2012/11/29 Harry <hariansyahptk@yahoo.com>

  Dear BeExceller,
Lebih jauh mengenai proses penginputan data oleh banyak PC secara bersamaan, selama ini saya menggunakan proses buka tutup file data sebagaimana rumus berikut:
Private Sub UserForm_Initialize()
    'deklarasi variabel workbook
    Dim wbkA As Workbook, wbkAKTIF As Workbook
  
    'init workbooknya
    Set wbkA = ThisWorkbook
   
    '--- WBK READ ONLY ??? ---' >> START
    Dim lTry As Long, lJeda As Long
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
CobaBuka:
    For lTry = 1 To 20
        Set wbkAKTIF = Workbooks.Open(wbkA.Path & "\DATA.xls")
        If wbkAKTIF.ReadOnly Then
            wbkAKTIF.Close False
            If lTry = 20 Then
                If MsgBox("Sudah dicoba membuka " & lTry & _
                        " kali, dan masih digunakan oleh instansi Excel yang lain" & vbCrLf & _
                        "Coba lagi ?", vbExclamation + vbYesNo, "Akses ke DATABASE PROGRAM") = vbYes Then
                    GoTo CobaBuka
                Else
                    Application.ScreenUpdating = False
                    Exit Sub
                End If
            End If
        Else
            wbkA.Activate
            Exit For
        End If
        For lJeda = 1 To 100000000
        Next lJeda
    Next lTry
    Application.ScreenUpdating = True
    '--- WBK READ ONLY ??? ---' >> END
       
End Sub
Tetapi seiring banyaknya data yang harus diinput, membuat sistem buka-tutup file data tersebut menjadi tidak efisien karena user harus bergantian melakukan proses buka-tutup file.
Sebagaimana yang pernah diinformasikan oleh Mr. Kid yaitu dengan menggunakan ADO (ActiveX Data Objects) seya mengalami kesulitan untuk merealisasikan hal tersebut.Pernah saya mencoba untuk memanipulasi rumus yang pernah dibahas pada milis dengan subject : Add data from xl to Access, tetapi tidak berhasil.
Besar harapan kiranya teman-teman BeExceller dapat memberikan informasi (berbagi ilmu) mengenai bagaimana caranya melakukan proses input ke file data dengan tidak adanya proses buka-tutup file data sehingga banyak PC bisa melakukan proses input secara bersamaan waktu.
Terima kasih atas berkanan informasi dari teman-teman BeExceller.
Wassalam,

Harry

N/B:* Terlampir 2 file (Master.xls & Data.xls) sebagai referensi* File-file tersebut diatas masih tersimpan pada 1 folder yang sama.* Yang diinginkan adalah file Master.xls disimpan pada folder D: sedangkan file Data.xls disimpan pada folder C:.
* File Data.xls masih membutuhkan proses buka tutup* Yang diinginkan adalah file Data.xls tetap dalam keadaan terbuka tanpa proses buka tutup

<!--#yiv7949801542 #yiv7949801542ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7949801542 #yiv7949801542ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7949801542 #yiv7949801542ygrp-mkp #yiv7949801542hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7949801542 #yiv7949801542ygrp-mkp #yiv7949801542ads {margin-bottom:10px;}#yiv7949801542 #yiv7949801542ygrp-mkp .yiv7949801542ad {padding:0 0;}#yiv7949801542 #yiv7949801542ygrp-mkp .yiv7949801542ad p {margin:0;}#yiv7949801542 #yiv7949801542ygrp-mkp .yiv7949801542ad a {color:#0000ff;text-decoration:none;}#yiv7949801542 #yiv7949801542ygrp-sponsor #yiv7949801542ygrp-lc {font-family:Arial;}#yiv7949801542 #yiv7949801542ygrp-sponsor #yiv7949801542ygrp-lc #yiv7949801542hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7949801542 #yiv7949801542ygrp-sponsor #yiv7949801542ygrp-lc .yiv7949801542ad {margin-bottom:10px;padding:0 0;}#yiv7949801542 #yiv7949801542actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7949801542 #yiv7949801542activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7949801542 #yiv7949801542activity span {font-weight:700;}#yiv7949801542 #yiv7949801542activity span:first-child {text-transform:uppercase;}#yiv7949801542 #yiv7949801542activity span a {color:#5085b6;text-decoration:none;}#yiv7949801542 #yiv7949801542activity span span {color:#ff7900;}#yiv7949801542 #yiv7949801542activity span .yiv7949801542underline {text-decoration:underline;}#yiv7949801542 .yiv7949801542attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7949801542 .yiv7949801542attach div a {text-decoration:none;}#yiv7949801542 .yiv7949801542attach img {border:none;padding-right:5px;}#yiv7949801542 .yiv7949801542attach label {display:block;margin-bottom:5px;}#yiv7949801542 .yiv7949801542attach label a {text-decoration:none;}#yiv7949801542 blockquote {margin:0 0 0 4px;}#yiv7949801542 .yiv7949801542bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7949801542 .yiv7949801542bold a {text-decoration:none;}#yiv7949801542 dd.yiv7949801542last p a {font-family:Verdana;font-weight:700;}#yiv7949801542 dd.yiv7949801542last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7949801542 dd.yiv7949801542last p span.yiv7949801542yshortcuts {margin-right:0;}#yiv7949801542 div.yiv7949801542attach-table div div a {text-decoration:none;}#yiv7949801542 div.yiv7949801542attach-table {width:400px;}#yiv7949801542 div.yiv7949801542file-title a, #yiv7949801542 div.yiv7949801542file-title a:active, #yiv7949801542 div.yiv7949801542file-title a:hover, #yiv7949801542 div.yiv7949801542file-title a:visited {text-decoration:none;}#yiv7949801542 div.yiv7949801542photo-title a, #yiv7949801542 div.yiv7949801542photo-title a:active, #yiv7949801542 div.yiv7949801542photo-title a:hover, #yiv7949801542 div.yiv7949801542photo-title a:visited {text-decoration:none;}#yiv7949801542 div#yiv7949801542ygrp-mlmsg #yiv7949801542ygrp-msg p a span.yiv7949801542yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7949801542 .yiv7949801542green {color:#628c2a;}#yiv7949801542 .yiv7949801542MsoNormal {margin:0 0 0 0;}#yiv7949801542 o {font-size:0;}#yiv7949801542 #yiv7949801542photos div {float:left;width:72px;}#yiv7949801542 #yiv7949801542photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7949801542 #yiv7949801542photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7949801542 #yiv7949801542reco-category {font-size:77%;}#yiv7949801542 #yiv7949801542reco-desc {font-size:77%;}#yiv7949801542 .yiv7949801542replbq {margin:4px;}#yiv7949801542 #yiv7949801542ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7949801542 #yiv7949801542ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7949801542 #yiv7949801542ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7949801542 #yiv7949801542ygrp-mlmsg select, #yiv7949801542 input, #yiv7949801542 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7949801542 #yiv7949801542ygrp-mlmsg pre, #yiv7949801542 code {font:115% monospace;}#yiv7949801542 #yiv7949801542ygrp-mlmsg * {line-height:1.22em;}#yiv7949801542 #yiv7949801542ygrp-mlmsg #yiv7949801542logo {padding-bottom:10px;}#yiv7949801542 #yiv7949801542ygrp-msg p a {font-family:Verdana;}#yiv7949801542 #yiv7949801542ygrp-msg p#yiv7949801542attach-count span {color:#1E66AE;font-weight:700;}#yiv7949801542 #yiv7949801542ygrp-reco #yiv7949801542reco-head {color:#ff7900;font-weight:700;}#yiv7949801542 #yiv7949801542ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7949801542 #yiv7949801542ygrp-sponsor #yiv7949801542ov li a {font-size:130%;text-decoration:none;}#yiv7949801542 #yiv7949801542ygrp-sponsor #yiv7949801542ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7949801542 #yiv7949801542ygrp-sponsor #yiv7949801542ov ul {margin:0;padding:0 0 0 8px;}#yiv7949801542 #yiv7949801542ygrp-text {font-family:Georgia;}#yiv7949801542 #yiv7949801542ygrp-text p {margin:0 0 1em 0;}#yiv7949801542 #yiv7949801542ygrp-text tt {font-size:120%;}#yiv7949801542 #yiv7949801542ygrp-vital ul li:last-child {border-right:none !important;}-->

Fri May 20, 2016 9:39 am (PDT) . Posted by:

"odong nando"

lihat att mudah2an membantu, jgn liat panjangnya...mungkin rekan2 milis punya yg bisa pedeknya br,

odong nando

Dari: "Syamsudin Rasyid syamsudin06@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Jumat, 20 Mei 2016 5:21
Judul: [belajar-excel] Penggunaan fungsi Conacatenate bersyarat [1 Attachment]

 
para master belajar excel yth.Saya seorang guru di Samarinda, saya mendapat tugas untuk membantu teman-teman guru untuk membuat model rapot Kurikulum 2013, bagaimana caranya agar deskripsi yang ada di kolom ad tampilannya seperti yang ada di kolom ae.Mohon bantuannya, kira-kira fungsi apa yang digunakan?file terlampirterimakasih sebelumnya--
==================================================================

- Guru Matematika dan TIK
- Untuk mendapatkan informasi tentang pembelajaran yang menggunakan ICT berbasis web silhakan kunjungi http://www.syamsudin06.org 

==================================================================
Kelemahan adalah Kekuatan yang belum di ketahui Pemanfaatannya
==================================================================
#yiv4576050666 #yiv4576050666 -- #yiv4576050666ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4576050666 #yiv4576050666ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4576050666 #yiv4576050666ygrp-mkp #yiv4576050666hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4576050666 #yiv4576050666ygrp-mkp #yiv4576050666ads {margin-bottom:10px;}#yiv4576050666 #yiv4576050666ygrp-mkp .yiv4576050666ad {padding:0 0;}#yiv4576050666 #yiv4576050666ygrp-mkp .yiv4576050666ad p {margin:0;}#yiv4576050666 #yiv4576050666ygrp-mkp .yiv4576050666ad a {color:#0000ff;text-decoration:none;}#yiv4576050666 #yiv4576050666ygrp-sponsor #yiv4576050666ygrp-lc {font-family:Arial;}#yiv4576050666 #yiv4576050666ygrp-sponsor #yiv4576050666ygrp-lc #yiv4576050666hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4576050666 #yiv4576050666ygrp-sponsor #yiv4576050666ygrp-lc .yiv4576050666ad {margin-bottom:10px;padding:0 0;}#yiv4576050666 #yiv4576050666actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4576050666 #yiv4576050666activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4576050666 #yiv4576050666activity span {font-weight:700;}#yiv4576050666 #yiv4576050666activity span:first-child {text-transform:uppercase;}#yiv4576050666 #yiv4576050666activity span a {color:#5085b6;text-decoration:none;}#yiv4576050666 #yiv4576050666activity span span {color:#ff7900;}#yiv4576050666 #yiv4576050666activity span .yiv4576050666underline {text-decoration:underline;}#yiv4576050666 .yiv4576050666attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4576050666 .yiv4576050666attach div a {text-decoration:none;}#yiv4576050666 .yiv4576050666attach img {border:none;padding-right:5px;}#yiv4576050666 .yiv4576050666attach label {display:block;margin-bottom:5px;}#yiv4576050666 .yiv4576050666attach label a {text-decoration:none;}#yiv4576050666 blockquote {margin:0 0 0 4px;}#yiv4576050666 .yiv4576050666bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4576050666 .yiv4576050666bold a {text-decoration:none;}#yiv4576050666 dd.yiv4576050666last p a {font-family:Verdana;font-weight:700;}#yiv4576050666 dd.yiv4576050666last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4576050666 dd.yiv4576050666last p span.yiv4576050666yshortcuts {margin-right:0;}#yiv4576050666 div.yiv4576050666attach-table div div a {text-decoration:none;}#yiv4576050666 div.yiv4576050666attach-table {width:400px;}#yiv4576050666 div.yiv4576050666file-title a, #yiv4576050666 div.yiv4576050666file-title a:active, #yiv4576050666 div.yiv4576050666file-title a:hover, #yiv4576050666 div.yiv4576050666file-title a:visited {text-decoration:none;}#yiv4576050666 div.yiv4576050666photo-title a, #yiv4576050666 div.yiv4576050666photo-title a:active, #yiv4576050666 div.yiv4576050666photo-title a:hover, #yiv4576050666 div.yiv4576050666photo-title a:visited {text-decoration:none;}#yiv4576050666 div#yiv4576050666ygrp-mlmsg #yiv4576050666ygrp-msg p a span.yiv4576050666yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4576050666 .yiv4576050666green {color:#628c2a;}#yiv4576050666 .yiv4576050666MsoNormal {margin:0 0 0 0;}#yiv4576050666 o {font-size:0;}#yiv4576050666 #yiv4576050666photos div {float:left;width:72px;}#yiv4576050666 #yiv4576050666photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4576050666 #yiv4576050666photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4576050666 #yiv4576050666reco-category {font-size:77%;}#yiv4576050666 #yiv4576050666reco-desc {font-size:77%;}#yiv4576050666 .yiv4576050666replbq {margin:4px;}#yiv4576050666 #yiv4576050666ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4576050666 #yiv4576050666ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4576050666 #yiv4576050666ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4576050666 #yiv4576050666ygrp-mlmsg select, #yiv4576050666 input, #yiv4576050666 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4576050666 #yiv4576050666ygrp-mlmsg pre, #yiv4576050666 code {font:115% monospace;}#yiv4576050666 #yiv4576050666ygrp-mlmsg * {line-height:1.22em;}#yiv4576050666 #yiv4576050666ygrp-mlmsg #yiv4576050666logo {padding-bottom:10px;}#yiv4576050666 #yiv4576050666ygrp-msg p a {font-family:Verdana;}#yiv4576050666 #yiv4576050666ygrp-msg p#yiv4576050666attach-count span {color:#1E66AE;font-weight:700;}#yiv4576050666 #yiv4576050666ygrp-reco #yiv4576050666reco-head {color:#ff7900;font-weight:700;}#yiv4576050666 #yiv4576050666ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4576050666 #yiv4576050666ygrp-sponsor #yiv4576050666ov li a {font-size:130%;text-decoration:none;}#yiv4576050666 #yiv4576050666ygrp-sponsor #yiv4576050666ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4576050666 #yiv4576050666ygrp-sponsor #yiv4576050666ov ul {margin:0;padding:0 0 0 8px;}#yiv4576050666 #yiv4576050666ygrp-text {font-family:Georgia;}#yiv4576050666 #yiv4576050666ygrp-text p {margin:0 0 1em 0;}#yiv4576050666 #yiv4576050666ygrp-text tt {font-size:120%;}#yiv4576050666 #yiv4576050666ygrp-vital ul li:last-child {border-right:none !important;}#yiv4576050666

Fri May 20, 2016 3:16 pm (PDT) . Posted by:

"Syamsudin Rasyid" syamsudin_06

terimakasih atas bantuannya, ini sanga bermanfaat buat saya

On Fri, May 20, 2016 at 6:53 PM, odong nando odongnando@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> lihat att mudah2an membantu, jgn liat panjangnya...
> mungkin rekan2 milis punya yg bisa pedeknya
>
> br,
>
> odong nando
>
>
> ------------------------------
> *Dari:* "Syamsudin Rasyid syamsudin06@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *Kepada:* belajar-excel@yahoogroups.com
> *Dikirim:* Jumat, 20 Mei 2016 5:21
> *Judul:* [belajar-excel] Penggunaan fungsi Conacatenate bersyarat [1
> Attachment]
>
>
>
> para master belajar excel yth.
> Saya seorang guru di Samarinda, saya mendapat tugas untuk membantu
> teman-teman guru untuk membuat model rapot Kurikulum 2013, bagaimana
> caranya agar deskripsi yang ada di kolom ad tampilannya seperti yang ada di
> kolom ae.
> Mohon bantuannya, kira-kira fungsi apa yang digunakan?
> file terlampir
> terimakasih sebelumnya
> --
> ==================================================================
>
> - Guru Matematika dan TIK
> - Untuk mendapatkan informasi tentang pembelajaran yang menggunakan
> ICT berbasis web silhakan kunjungi http://www.syamsudin06.org
>
> ==================================================================
> Kelemahan adalah Kekuatan yang belum di ketahui Pemanfaatannya
> ==================================================================
>
>
>
>

--
==================================================================

- Guru Matematika dan TIK
- Untuk mendapatkan informasi tentang pembelajaran yang menggunakan ICT
berbasis web silhakan kunjungi http://www.syamsudin06.org

==================================================================
Kelemahan adalah Kekuatan yang belum di ketahui Pemanfaatannya
==================================================================
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar