[belajar-excel] Digest Number 4529

Milis Belajar Microsoft Excel Group

8 Messages

Digest #4529

1a

Re: Copy Data Antar Sheet Dengan Criteria "KIRIM" by y.roni35

1b

Re: Copy Data Antar Sheet Dengan Criteria "KIRIM" by "hendrik karnadi" hendrikkarnadi

2.1

Re: Absensi [1 Attachment] by "hendrik karnadi" hendrikkarnadi

2.2

Bls: [belajar-excel] Absensi [1 Attachment] by "Denny Oktavianus" denny_y86

2.3

Re: Bls: [belajar-excel] Absensi by "hendrik karnadi" hendrikkarnadi

2.4

Re: Bls: [belajar-excel] Absensi by "denny_y86" denny_y86

3a

Re: Pencarian data di userform dan menampilkan isinya di list boc [1 by "Tio Adi Bayu Adjie"

3b

Re: Pencarian data di userform dan menampilkan isinya di list boc by "hendrik karnadi" hendrikkarnadi

Messages

1a

Re: Copy Data Antar Sheet Dengan Criteria "KIRIM"

Thu Jun 28, 2018 10:51 pm (PDT) . Posted by:

y.roni35

Dear Pak Dede,


Lampiran yg mana?
Kok tidak ada




Regards,
Yusuf

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

1b

Re: Copy Data Antar Sheet Dengan Criteria "KIRIM"

Fri Jun 29, 2018 12:05 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Yusuf,Jawaban yang saya kirim tgl 19 dan 20 Juni sdh dicoba ?
Jwb tgl 19 JuniAda kiriteria di Sheet Terima range N1 dan N2,N1 ditulis Description, N2 ditulis KIRIM
Jwb tgl 20 JuniMacro yang sdh diperbaiki.
Salam,HK

Sent from Yahoo Mail on Android

On Fri, Jun 29, 2018 at 12:51, y.roni35@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Dear Pak Dede,
Lampiran yg mana?Kok tidak ada

Regards,Yusuf
#yiv9843684402 #yiv9843684402 -- #yiv9843684402ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9843684402 #yiv9843684402ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9843684402 #yiv9843684402ygrp-mkp #yiv9843684402hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9843684402 #yiv9843684402ygrp-mkp #yiv9843684402ads {margin-bottom:10px;}#yiv9843684402 #yiv9843684402ygrp-mkp .yiv9843684402ad {padding:0 0;}#yiv9843684402 #yiv9843684402ygrp-mkp .yiv9843684402ad p {margin:0;}#yiv9843684402 #yiv9843684402ygrp-mkp .yiv9843684402ad a {color:#0000ff;text-decoration:none;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ygrp-lc {font-family:Arial;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ygrp-lc #yiv9843684402hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ygrp-lc .yiv9843684402ad {margin-bottom:10px;padding:0 0;}#yiv9843684402 #yiv9843684402actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9843684402 #yiv9843684402activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9843684402 #yiv9843684402activity span {font-weight:700;}#yiv9843684402 #yiv9843684402activity span:first-child {text-transform:uppercase;}#yiv9843684402 #yiv9843684402activity span a {color:#5085b6;text-decoration:none;}#yiv9843684402 #yiv9843684402activity span span {color:#ff7900;}#yiv9843684402 #yiv9843684402activity span .yiv9843684402underline {text-decoration:underline;}#yiv9843684402 .yiv9843684402attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9843684402 .yiv9843684402attach div a {text-decoration:none;}#yiv9843684402 .yiv9843684402attach img {border:none;padding-right:5px;}#yiv9843684402 .yiv9843684402attach label {display:block;margin-bottom:5px;}#yiv9843684402 .yiv9843684402attach label a {text-decoration:none;}#yiv9843684402 blockquote {margin:0 0 0 4px;}#yiv9843684402 .yiv9843684402bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9843684402 .yiv9843684402bold a {text-decoration:none;}#yiv9843684402 dd.yiv9843684402last p a {font-family:Verdana;font-weight:700;}#yiv9843684402 dd.yiv9843684402last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9843684402 dd.yiv9843684402last p span.yiv9843684402yshortcuts {margin-right:0;}#yiv9843684402 div.yiv9843684402attach-table div div a {text-decoration:none;}#yiv9843684402 div.yiv9843684402attach-table {width:400px;}#yiv9843684402 div.yiv9843684402file-title a, #yiv9843684402 div.yiv9843684402file-title a:active, #yiv9843684402 div.yiv9843684402file-title a:hover, #yiv9843684402 div.yiv9843684402file-title a:visited {text-decoration:none;}#yiv9843684402 div.yiv9843684402photo-title a, #yiv9843684402 div.yiv9843684402photo-title a:active, #yiv9843684402 div.yiv9843684402photo-title a:hover, #yiv9843684402 div.yiv9843684402photo-title a:visited {text-decoration:none;}#yiv9843684402 div#yiv9843684402ygrp-mlmsg #yiv9843684402ygrp-msg p a span.yiv9843684402yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9843684402 .yiv9843684402green {color:#628c2a;}#yiv9843684402 .yiv9843684402MsoNormal {margin:0 0 0 0;}#yiv9843684402 o {font-size:0;}#yiv9843684402 #yiv9843684402photos div {float:left;width:72px;}#yiv9843684402 #yiv9843684402photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9843684402 #yiv9843684402photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9843684402 #yiv9843684402reco-category {font-size:77%;}#yiv9843684402 #yiv9843684402reco-desc {font-size:77%;}#yiv9843684402 .yiv9843684402replbq {margin:4px;}#yiv9843684402 #yiv9843684402ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9843684402 #yiv9843684402ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9843684402 #yiv9843684402ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9843684402 #yiv9843684402ygrp-mlmsg select, #yiv9843684402 input, #yiv9843684402 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9843684402 #yiv9843684402ygrp-mlmsg pre, #yiv9843684402 code {font:115% monospace;}#yiv9843684402 #yiv9843684402ygrp-mlmsg * {line-height:1..22em;}#yiv9843684402 #yiv9843684402ygrp-mlmsg #yiv9843684402logo {padding-bottom:10px;}#yiv9843684402 #yiv9843684402ygrp-msg p a {font-family:Verdana;}#yiv9843684402 #yiv9843684402ygrp-msg p#yiv9843684402attach-count span {color:#1E66AE;font-weight:700;}#yiv9843684402 #yiv9843684402ygrp-reco #yiv9843684402reco-head {color:#ff7900;font-weight:700;}#yiv9843684402 #yiv9843684402ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ov li a {font-size:130%;text-decoration:none;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ov ul {margin:0;padding:0 0 0 8px;}#yiv9843684402 #yiv9843684402ygrp-text {font-family:Georgia;}#yiv9843684402 #yiv9843684402ygrp-text p {margin:0 0 1em 0;}#yiv9843684402 #yiv9843684402ygrp-text tt {font-size:120%;}#yiv9843684402 #yiv9843684402ygrp-vital ul li:last-child {border-right:none !important;}#yiv9843684402

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

2.1

Re: Absensi [1 Attachment]

Fri Jun 29, 2018 12:01 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny

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

2.2

Bls: [belajar-excel] Absensi [1 Attachment]

Fri Jun 29, 2018 9:37 am (PDT) . Posted by:

"Denny Oktavianus" denny_y86

dear pak hendrik,

Terima kasih atas bantuan bapak, sudah kita ikuti sesuai arahan dan berhasil.

salam
denny


Pada Jumat, 29 Juni 2018 14:01, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny #yiv2857145364 #yiv2857145364 -- #yiv2857145364ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2857145364 #yiv2857145364ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2857145364 #yiv2857145364ygrp-mkp #yiv2857145364hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2857145364 #yiv2857145364ygrp-mkp #yiv2857145364ads {margin-bottom:10px;}#yiv2857145364 #yiv2857145364ygrp-mkp .yiv2857145364ad {padding:0 0;}#yiv2857145364 #yiv2857145364ygrp-mkp .yiv2857145364ad p {margin:0;}#yiv2857145364 #yiv2857145364ygrp-mkp .yiv2857145364ad a {color:#0000ff;text-decoration:none;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ygrp-lc {font-family:Arial;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ygrp-lc #yiv2857145364hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ygrp-lc .yiv2857145364ad {margin-bottom:10px;padding:0 0;}#yiv2857145364 #yiv2857145364actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2857145364 #yiv2857145364activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2857145364 #yiv2857145364activity span {font-weight:700;}#yiv2857145364 #yiv2857145364activity span:first-child {text-transform:uppercase;}#yiv2857145364 #yiv2857145364activity span a {color:#5085b6;text-decoration:none;}#yiv2857145364 #yiv2857145364activity span span {color:#ff7900;}#yiv2857145364 #yiv2857145364activity span .yiv2857145364underline {text-decoration:underline;}#yiv2857145364 .yiv2857145364attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2857145364 .yiv2857145364attach div a {text-decoration:none;}#yiv2857145364 .yiv2857145364attach img {border:none;padding-right:5px;}#yiv2857145364 .yiv2857145364attach label {display:block;margin-bottom:5px;}#yiv2857145364 .yiv2857145364attach label a {text-decoration:none;}#yiv2857145364 blockquote {margin:0 0 0 4px;}#yiv2857145364 .yiv2857145364bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2857145364 .yiv2857145364bold a {text-decoration:none;}#yiv2857145364 dd.yiv2857145364last p a {font-family:Verdana;font-weight:700;}#yiv2857145364 dd.yiv2857145364last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2857145364 dd.yiv2857145364last p span.yiv2857145364yshortcuts {margin-right:0;}#yiv2857145364 div.yiv2857145364attach-table div div a {text-decoration:none;}#yiv2857145364 div.yiv2857145364attach-table {width:400px;}#yiv2857145364 div.yiv2857145364file-title a, #yiv2857145364 div.yiv2857145364file-title a:active, #yiv2857145364 div.yiv2857145364file-title a:hover, #yiv2857145364 div.yiv2857145364file-title a:visited {text-decoration:none;}#yiv2857145364 div.yiv2857145364photo-title a, #yiv2857145364 div.yiv2857145364photo-title a:active, #yiv2857145364 div.yiv2857145364photo-title a:hover, #yiv2857145364 div.yiv2857145364photo-title a:visited {text-decoration:none;}#yiv2857145364 div#yiv2857145364ygrp-mlmsg #yiv2857145364ygrp-msg p a span.yiv2857145364yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2857145364 .yiv2857145364green {color:#628c2a;}#yiv2857145364 .yiv2857145364MsoNormal {margin:0 0 0 0;}#yiv2857145364 o {font-size:0;}#yiv2857145364 #yiv2857145364photos div {float:left;width:72px;}#yiv2857145364 #yiv2857145364photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2857145364 #yiv2857145364photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2857145364 #yiv2857145364reco-category {font-size:77%;}#yiv2857145364 #yiv2857145364reco-desc {font-size:77%;}#yiv2857145364 .yiv2857145364replbq {margin:4px;}#yiv2857145364 #yiv2857145364ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2857145364 #yiv2857145364ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2857145364 #yiv2857145364ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2857145364 #yiv2857145364ygrp-mlmsg select, #yiv2857145364 input, #yiv2857145364 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2857145364 #yiv2857145364ygrp-mlmsg pre, #yiv2857145364 code {font:115% monospace;}#yiv2857145364 #yiv2857145364ygrp-mlmsg * {line-height:1.22em;}#yiv2857145364 #yiv2857145364ygrp-mlmsg #yiv2857145364logo {padding-bottom:10px;}#yiv2857145364 #yiv2857145364ygrp-msg p a {font-family:Verdana;}#yiv2857145364 #yiv2857145364ygrp-msg p#yiv2857145364attach-count span {color:#1E66AE;font-weight:700;}#yiv2857145364 #yiv2857145364ygrp-reco #yiv2857145364reco-head {color:#ff7900;font-weight:700;}#yiv2857145364 #yiv2857145364ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ov li a {font-size:130%;text-decoration:none;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ov ul {margin:0;padding:0 0 0 8px;}#yiv2857145364 #yiv2857145364ygrp-text {font-family:Georgia;}#yiv2857145364 #yiv2857145364ygrp-text p {margin:0 0 1em 0;}#yiv2857145364 #yiv2857145364ygrp-text tt {font-size:120%;}#yiv2857145364 #yiv2857145364ygrp-vital ul li:last-child {border-right:none !important;}#yiv2857145364

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

2.3

Re: Bls: [belajar-excel] Absensi

Fri Jun 29, 2018 7:25 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Denny,
Terima kasih kembali.Sedikit tambahan, keuntungan dgn menggunakan macro adalah nama dan tanggalnya bisa ditambah asalkan "struktur" datanya tidak berubah,- Data mulai dari A1- Nama mulai dari baris ke 3- Tanggal mulai dari kolom ke 2
Salam,HK

Sent from Yahoo Mail on Android

On Fri, Jun 29, 2018 at 23:39, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

dear pak hendrik,

Terima kasih atas bantuan bapak, sudah kita ikuti sesuai arahan dan berhasil.

salam
denny


Pada Jumat, 29 Juni 2018 14:01, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny

#yiv1846563302 #yiv1846563302 -- #yiv1846563302ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1846563302 #yiv1846563302ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1846563302 #yiv1846563302ygrp-mkp #yiv1846563302hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1846563302 #yiv1846563302ygrp-mkp #yiv1846563302ads {margin-bottom:10px;}#yiv1846563302 #yiv1846563302ygrp-mkp .yiv1846563302ad {padding:0 0;}#yiv1846563302 #yiv1846563302ygrp-mkp .yiv1846563302ad p {margin:0;}#yiv1846563302 #yiv1846563302ygrp-mkp .yiv1846563302ad a {color:#0000ff;text-decoration:none;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ygrp-lc {font-family:Arial;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ygrp-lc #yiv1846563302hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ygrp-lc .yiv1846563302ad {margin-bottom:10px;padding:0 0;}#yiv1846563302 #yiv1846563302actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1846563302 #yiv1846563302activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1846563302 #yiv1846563302activity span {font-weight:700;}#yiv1846563302 #yiv1846563302activity span:first-child {text-transform:uppercase;}#yiv1846563302 #yiv1846563302activity span a {color:#5085b6;text-decoration:none;}#yiv1846563302 #yiv1846563302activity span span {color:#ff7900;}#yiv1846563302 #yiv1846563302activity span .yiv1846563302underline {text-decoration:underline;}#yiv1846563302 .yiv1846563302attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1846563302 .yiv1846563302attach div a {text-decoration:none;}#yiv1846563302 .yiv1846563302attach img {border:none;padding-right:5px;}#yiv1846563302 .yiv1846563302attach label {display:block;margin-bottom:5px;}#yiv1846563302 .yiv1846563302attach label a {text-decoration:none;}#yiv1846563302 blockquote {margin:0 0 0 4px;}#yiv1846563302 .yiv1846563302bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1846563302 .yiv1846563302bold a {text-decoration:none;}#yiv1846563302 dd.yiv1846563302last p a {font-family:Verdana;font-weight:700;}#yiv1846563302 dd.yiv1846563302last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1846563302 dd.yiv1846563302last p span.yiv1846563302yshortcuts {margin-right:0;}#yiv1846563302 div.yiv1846563302attach-table div div a {text-decoration:none;}#yiv1846563302 div.yiv1846563302attach-table {width:400px;}#yiv1846563302 div.yiv1846563302file-title a, #yiv1846563302 div.yiv1846563302file-title a:active, #yiv1846563302 div.yiv1846563302file-title a:hover, #yiv1846563302 div.yiv1846563302file-title a:visited {text-decoration:none;}#yiv1846563302 div.yiv1846563302photo-title a, #yiv1846563302 div.yiv1846563302photo-title a:active, #yiv1846563302 div.yiv1846563302photo-title a:hover, #yiv1846563302 div.yiv1846563302photo-title a:visited {text-decoration:none;}#yiv1846563302 div#yiv1846563302ygrp-mlmsg #yiv1846563302ygrp-msg p a span.yiv1846563302yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1846563302 .yiv1846563302green {color:#628c2a;}#yiv1846563302 .yiv1846563302MsoNormal {margin:0 0 0 0;}#yiv1846563302 o {font-size:0;}#yiv1846563302 #yiv1846563302photos div {float:left;width:72px;}#yiv1846563302 #yiv1846563302photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1846563302 #yiv1846563302photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1846563302 #yiv1846563302reco-category {font-size:77%;}#yiv1846563302 #yiv1846563302reco-desc {font-size:77%;}#yiv1846563302 .yiv1846563302replbq {margin:4px;}#yiv1846563302 #yiv1846563302ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1846563302 #yiv1846563302ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1846563302 #yiv1846563302ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1846563302 #yiv1846563302ygrp-mlmsg select, #yiv1846563302 input, #yiv1846563302 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1846563302 #yiv1846563302ygrp-mlmsg pre, #yiv1846563302 code {font:115% monospace;}#yiv1846563302 #yiv1846563302ygrp-mlmsg * {line-height:1.22em;}#yiv1846563302 #yiv1846563302ygrp-mlmsg #yiv1846563302logo {padding-bottom:10px;}#yiv1846563302 #yiv1846563302ygrp-msg p a {font-family:Verdana;}#yiv1846563302 #yiv1846563302ygrp-msg p#yiv1846563302attach-count span {color:#1E66AE;font-weight:700;}#yiv1846563302 #yiv1846563302ygrp-reco #yiv1846563302reco-head {color:#ff7900;font-weight:700;}#yiv1846563302 #yiv1846563302ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ov li a {font-size:130%;text-decoration:none;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ov ul {margin:0;padding:0 0 0 8px;}#yiv1846563302 #yiv1846563302ygrp-text {font-family:Georgia;}#yiv1846563302 #yiv1846563302ygrp-text p {margin:0 0 1em 0;}#yiv1846563302 #yiv1846563302ygrp-text tt {font-size:120%;}#yiv1846563302 #yiv1846563302ygrp-vital ul li:last-child {border-right:none !important;}#yiv1846563302

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

2.4

Re: Bls: [belajar-excel] Absensi

Fri Jun 29, 2018 8:52 pm (PDT) . Posted by:

"denny_y86" denny_y86

Terima kasih Pak Hendrik atas informasi tambahan. Sukses selalu untuk bapak. 
Sudah kita coba dan berhasil. 
Salam
Denny

Sent from my Samsung Galaxy smartphone.
-------- Original message --------From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> Date: 30/06/2018 09:21 (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Re: Bls: [belajar-excel] Absensi

 

Hai Denny,
Terima kasih kembali.Sedikit tambahan, keuntungan dgn menggunakan macro adalah nama dan tanggalnya bisa ditambah asalkan "struktur" datanya tidak berubah,- Data mulai dari A1- Nama mulai dari baris ke 3- Tanggal mulai dari kolom ke 2
Salam,HK

Sent from Yahoo Mail on Android
On Fri, Jun 29, 2018 at 23:39, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:
 

dear pak hendrik,

Terima kasih atas bantuan bapak, sudah kita ikuti sesuai arahan dan berhasil.

salam
denny


Pada Jumat, 29 Juni 2018 14:01, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 

Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:



 

Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny

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

3a

Re: Pencarian data di userform dan menampilkan isinya di list boc [1

Fri Jun 29, 2018 3:56 am (PDT) . Posted by:

"Tio Adi Bayu Adjie"

Terima kasih Pak Hendrik, semoga Allah membalas kebaikan Pak Hendrik.
Benar seperti contoh file yang memang saya butuhkan. Tapi agak komplek persoalan saya. Tapi saya explore dulu..

Thank you
Best Regards,
Tio

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 28 Juni 2018 16:40
To: Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]
Subject: Re: [belajar-excel] Pencarian data di userform dan menampilkan isinya di list boc [1 Attachment]


Hai Tio,
Krn ga ada contohnya, jawbannya juga mereka-reka (jawaban yg mungkin mirip)..
Dari jawaban si mbah atas pertanyaan di milis ini sebelumnya, terlampir adalah suatu file berisi UserForm (jika diklik) yang ada ComboBox dan ListBoxnya.
Pilih pada ComboBox dan data akan ditampilkan pada ListBox yang berada pada UserForm yang sama.

Salam,
HK


On Thursday, 28 June 2018, 1:41:15 PM GMT+7, Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:




Dear B-Exceller,



Mohon bantuannya. Bagaimana cara mencari data di userform dan menampilkan isinya di list box.



Thank you

Best Regards,

Tio

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

3b

Re: Pencarian data di userform dan menampilkan isinya di list boc

Fri Jun 29, 2018 6:58 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sy sdh standby net meeting
On Friday, 29 June 2018, 5:56:36 PM GMT+7, Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Terima kasih Pak Hendrik, semoga Allah membalas kebaikan Pak Hendrik.

Benar seperti contoh file yang memang saya butuhkan. Tapi agak komplek persoalan saya. Tapi saya explore dulu..

 

Thank you

Best Regards,

Tio

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 28 Juni 2018 16:40
To: Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]
Subject: Re: [belajar-excel] Pencarian data di userform dan menampilkan isinya di list boc [1 Attachment]

 

 

Hai Tio,

Krn ga ada contohnya, jawbannya juga mereka-reka (jawaban yg mungkin mirip)..

Dari jawaban si mbah atas pertanyaan di milis ini sebelumnya, terlampir adalah suatu file berisi UserForm (jika diklik) yang ada ComboBox dan ListBoxnya. 

Pilih pada ComboBox dan data akan ditampilkan pada ListBox yang berada pada UserForm yang sama.

 

Salam,

HK

 

 

On Thursday, 28 June 2018, 1:41:15 PM GMT+7, Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

 

 

Dear B-Exceller,

 

Mohon bantuannya. Bagaimana cara mencari data di userform dan menampilkan isinya di list box.

 

Thank you

Best Regards,

Tio

 

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . 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