Kamis, 14 Januari 2016

[belajar-excel] Digest Number 3718

12 Messages

Digest #3718
1a
Bls: [belajar-excel] cari data [1 Attachment] by "anas hasbullah" hasbullah_anas
1b
Bls: [belajar-excel] cari data [1 Attachment] by "anas hasbullah" hasbullah_anas
1c
Re: cari data [1 Attachment] by "zainul_ulum[at]yahoo[dot]com" zainul_ulum
1d
Bls: [belajar-excel] cari data [1 Attachment] by "anas hasbullah" hasbullah_anas
1e
Bls: [belajar-excel] cari data [1 Attachment] by "anas hasbullah" hasbullah_anas
2b
Re: mohon bantuan memisahkan data ke sheet baru [1 Attachment] by "zainul_ulum[at]yahoo[dot]com" zainul_ulum
3a
Re: cari data [1 Attachment] by "Toby kenzo" tobykenzo
3b
Re: cari data by "imam cahyo yuwono"
3c
Bls: [belajar-excel] cari data by "anas hasbullah" hasbullah_anas
3d
Re: cari data by "hendrik karnadi" hendrikkarnadi

Messages

Wed Jan 13, 2016 7:17 am (PST) . Posted by:

"anas hasbullah" hasbullah_anas

maaf ini data excelnya,
terimakasih

Pada Rabu, 13 Januari 2016 15:23, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih
#yiv8448293763 #yiv8448293763 -- #yiv8448293763ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8448293763 #yiv8448293763ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8448293763 #yiv8448293763ygrp-mkp #yiv8448293763hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8448293763 #yiv8448293763ygrp-mkp #yiv8448293763ads {margin-bottom:10px;}#yiv8448293763 #yiv8448293763ygrp-mkp .yiv8448293763ad {padding:0 0;}#yiv8448293763 #yiv8448293763ygrp-mkp .yiv8448293763ad p {margin:0;}#yiv8448293763 #yiv8448293763ygrp-mkp .yiv8448293763ad a {color:#0000ff;text-decoration:none;}#yiv8448293763 #yiv8448293763ygrp-sponsor #yiv8448293763ygrp-lc {font-family:Arial;}#yiv8448293763 #yiv8448293763ygrp-sponsor #yiv8448293763ygrp-lc #yiv8448293763hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8448293763 #yiv8448293763ygrp-sponsor #yiv8448293763ygrp-lc .yiv8448293763ad {margin-bottom:10px;padding:0 0;}#yiv8448293763 #yiv8448293763actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8448293763 #yiv8448293763activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8448293763 #yiv8448293763activity span {font-weight:700;}#yiv8448293763 #yiv8448293763activity span:first-child {text-transform:uppercase;}#yiv8448293763 #yiv8448293763activity span a {color:#5085b6;text-decoration:none;}#yiv8448293763 #yiv8448293763activity span span {color:#ff7900;}#yiv8448293763 #yiv8448293763activity span .yiv8448293763underline {text-decoration:underline;}#yiv8448293763 .yiv8448293763attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8448293763 .yiv8448293763attach div a {text-decoration:none;}#yiv8448293763 .yiv8448293763attach img {border:none;padding-right:5px;}#yiv8448293763 .yiv8448293763attach label {display:block;margin-bottom:5px;}#yiv8448293763 .yiv8448293763attach label a {text-decoration:none;}#yiv8448293763 blockquote {margin:0 0 0 4px;}#yiv8448293763 .yiv8448293763bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8448293763 .yiv8448293763bold a {text-decoration:none;}#yiv8448293763 dd.yiv8448293763last p a {font-family:Verdana;font-weight:700;}#yiv8448293763 dd.yiv8448293763last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8448293763 dd.yiv8448293763last p span.yiv8448293763yshortcuts {margin-right:0;}#yiv8448293763 div.yiv8448293763attach-table div div a {text-decoration:none;}#yiv8448293763 div.yiv8448293763attach-table {width:400px;}#yiv8448293763 div.yiv8448293763file-title a, #yiv8448293763 div.yiv8448293763file-title a:active, #yiv8448293763 div.yiv8448293763file-title a:hover, #yiv8448293763 div.yiv8448293763file-title a:visited {text-decoration:none;}#yiv8448293763 div.yiv8448293763photo-title a, #yiv8448293763 div.yiv8448293763photo-title a:active, #yiv8448293763 div.yiv8448293763photo-title a:hover, #yiv8448293763 div.yiv8448293763photo-title a:visited {text-decoration:none;}#yiv8448293763 div#yiv8448293763ygrp-mlmsg #yiv8448293763ygrp-msg p a span.yiv8448293763yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8448293763 .yiv8448293763green {color:#628c2a;}#yiv8448293763 .yiv8448293763MsoNormal {margin:0 0 0 0;}#yiv8448293763 o {font-size:0;}#yiv8448293763 #yiv8448293763photos div {float:left;width:72px;}#yiv8448293763 #yiv8448293763photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8448293763 #yiv8448293763photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8448293763 #yiv8448293763reco-category {font-size:77%;}#yiv8448293763 #yiv8448293763reco-desc {font-size:77%;}#yiv8448293763 .yiv8448293763replbq {margin:4px;}#yiv8448293763 #yiv8448293763ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8448293763 #yiv8448293763ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8448293763 #yiv8448293763ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8448293763 #yiv8448293763ygrp-mlmsg select, #yiv8448293763 input, #yiv8448293763 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8448293763 #yiv8448293763ygrp-mlmsg pre, #yiv8448293763 code {font:115% monospace;}#yiv8448293763 #yiv8448293763ygrp-mlmsg * {line-height:1.22em;}#yiv8448293763 #yiv8448293763ygrp-mlmsg #yiv8448293763logo {padding-bottom:10px;}#yiv8448293763 #yiv8448293763ygrp-msg p a {font-family:Verdana;}#yiv8448293763 #yiv8448293763ygrp-msg p#yiv8448293763attach-count span {color:#1E66AE;font-weight:700;}#yiv8448293763 #yiv8448293763ygrp-reco #yiv8448293763reco-head {color:#ff7900;font-weight:700;}#yiv8448293763 #yiv8448293763ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8448293763 #yiv8448293763ygrp-sponsor #yiv8448293763ov li a {font-size:130%;text-decoration:none;}#yiv8448293763 #yiv8448293763ygrp-sponsor #yiv8448293763ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8448293763 #yiv8448293763ygrp-sponsor #yiv8448293763ov ul {margin:0;padding:0 0 0 8px;}#yiv8448293763 #yiv8448293763ygrp-text {font-family:Georgia;}#yiv8448293763 #yiv8448293763ygrp-text p {margin:0 0 1em 0;}#yiv8448293763 #yiv8448293763ygrp-text tt {font-size:120%;}#yiv8448293763 #yiv8448293763ygrp-vital ul li:last-child {border-right:none !important;}#yiv8448293763

Wed Jan 13, 2016 7:17 am (PST) . Posted by:

"anas hasbullah" hasbullah_anas

dear master excel
saya minta bantuan mengenai rumus yg valueberikut kami lampirkan filnya

Pada Rabu, 13 Januari 2016 15:23, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih
#yiv5381942941 #yiv5381942941 -- #yiv5381942941ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5381942941 #yiv5381942941ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5381942941 #yiv5381942941ygrp-mkp #yiv5381942941hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5381942941 #yiv5381942941ygrp-mkp #yiv5381942941ads {margin-bottom:10px;}#yiv5381942941 #yiv5381942941ygrp-mkp .yiv5381942941ad {padding:0 0;}#yiv5381942941 #yiv5381942941ygrp-mkp .yiv5381942941ad p {margin:0;}#yiv5381942941 #yiv5381942941ygrp-mkp .yiv5381942941ad a {color:#0000ff;text-decoration:none;}#yiv5381942941 #yiv5381942941ygrp-sponsor #yiv5381942941ygrp-lc {font-family:Arial;}#yiv5381942941 #yiv5381942941ygrp-sponsor #yiv5381942941ygrp-lc #yiv5381942941hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5381942941 #yiv5381942941ygrp-sponsor #yiv5381942941ygrp-lc .yiv5381942941ad {margin-bottom:10px;padding:0 0;}#yiv5381942941 #yiv5381942941actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5381942941 #yiv5381942941activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5381942941 #yiv5381942941activity span {font-weight:700;}#yiv5381942941 #yiv5381942941activity span:first-child {text-transform:uppercase;}#yiv5381942941 #yiv5381942941activity span a {color:#5085b6;text-decoration:none;}#yiv5381942941 #yiv5381942941activity span span {color:#ff7900;}#yiv5381942941 #yiv5381942941activity span .yiv5381942941underline {text-decoration:underline;}#yiv5381942941 .yiv5381942941attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5381942941 .yiv5381942941attach div a {text-decoration:none;}#yiv5381942941 .yiv5381942941attach img {border:none;padding-right:5px;}#yiv5381942941 .yiv5381942941attach label {display:block;margin-bottom:5px;}#yiv5381942941 .yiv5381942941attach label a {text-decoration:none;}#yiv5381942941 blockquote {margin:0 0 0 4px;}#yiv5381942941 .yiv5381942941bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5381942941 .yiv5381942941bold a {text-decoration:none;}#yiv5381942941 dd.yiv5381942941last p a {font-family:Verdana;font-weight:700;}#yiv5381942941 dd.yiv5381942941last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5381942941 dd.yiv5381942941last p span.yiv5381942941yshortcuts {margin-right:0;}#yiv5381942941 div.yiv5381942941attach-table div div a {text-decoration:none;}#yiv5381942941 div.yiv5381942941attach-table {width:400px;}#yiv5381942941 div.yiv5381942941file-title a, #yiv5381942941 div.yiv5381942941file-title a:active, #yiv5381942941 div.yiv5381942941file-title a:hover, #yiv5381942941 div.yiv5381942941file-title a:visited {text-decoration:none;}#yiv5381942941 div.yiv5381942941photo-title a, #yiv5381942941 div.yiv5381942941photo-title a:active, #yiv5381942941 div.yiv5381942941photo-title a:hover, #yiv5381942941 div.yiv5381942941photo-title a:visited {text-decoration:none;}#yiv5381942941 div#yiv5381942941ygrp-mlmsg #yiv5381942941ygrp-msg p a span.yiv5381942941yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5381942941 .yiv5381942941green {color:#628c2a;}#yiv5381942941 .yiv5381942941MsoNormal {margin:0 0 0 0;}#yiv5381942941 o {font-size:0;}#yiv5381942941 #yiv5381942941photos div {float:left;width:72px;}#yiv5381942941 #yiv5381942941photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5381942941 #yiv5381942941photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5381942941 #yiv5381942941reco-category {font-size:77%;}#yiv5381942941 #yiv5381942941reco-desc {font-size:77%;}#yiv5381942941 .yiv5381942941replbq {margin:4px;}#yiv5381942941 #yiv5381942941ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5381942941 #yiv5381942941ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5381942941 #yiv5381942941ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5381942941 #yiv5381942941ygrp-mlmsg select, #yiv5381942941 input, #yiv5381942941 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5381942941 #yiv5381942941ygrp-mlmsg pre, #yiv5381942941 code {font:115% monospace;}#yiv5381942941 #yiv5381942941ygrp-mlmsg * {line-height:1.22em;}#yiv5381942941 #yiv5381942941ygrp-mlmsg #yiv5381942941logo {padding-bottom:10px;}#yiv5381942941 #yiv5381942941ygrp-msg p a {font-family:Verdana;}#yiv5381942941 #yiv5381942941ygrp-msg p#yiv5381942941attach-count span {color:#1E66AE;font-weight:700;}#yiv5381942941 #yiv5381942941ygrp-reco #yiv5381942941reco-head {color:#ff7900;font-weight:700;}#yiv5381942941 #yiv5381942941ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5381942941 #yiv5381942941ygrp-sponsor #yiv5381942941ov li a {font-size:130%;text-decoration:none;}#yiv5381942941 #yiv5381942941ygrp-sponsor #yiv5381942941ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5381942941 #yiv5381942941ygrp-sponsor #yiv5381942941ov ul {margin:0;padding:0 0 0 8px;}#yiv5381942941 #yiv5381942941ygrp-text {font-family:Georgia;}#yiv5381942941 #yiv5381942941ygrp-text p {margin:0 0 1em 0;}#yiv5381942941 #yiv5381942941ygrp-text tt {font-size:120%;}#yiv5381942941 #yiv5381942941ygrp-vital ul li:last-child {border-right:none !important;}#yiv5381942941

Wed Jan 13, 2016 4:26 pm (PST) . Posted by:

"zainul_ulum[at]yahoo[dot]com" zainul_ulum

Mas Imam,

maaf saya rubah rumusnya, tetapi semoga hasilnya sesuai yang diharapkan.

detail, silakan lihat file terlampir.

terimakasih

+zainul

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, January 13, 2016 7:00 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] cari data [1 Attachment]

dear master excel

saya minta bantuan mengenai rumus yg value

berikut kami lampirkan filnya

Pada Rabu, 13 Januari 2016 15:23, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih

Wed Jan 13, 2016 7:13 pm (PST) . Posted by:

"anas hasbullah" hasbullah_anas

maaf mas zainul, maksudnya gimana caranya agar kata terakhir dari yg 3 suku kata & 4 suku kata dalam satu kolom, jadi kalo yg di kolom kata ketiga jika namanya 3 kata gimana agar bisa digunakan rumusnya
terimakasihannas


Pada Kamis, 14 Januari 2016 7:26, "'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Mas Imam,maaf saya rubah rumusnya, tetapi semoga hasilnya sesuai yang diharapkan.detail, silakan lihat file terlampir.  terimakasih+zainul  From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, January 13, 2016 7:00 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] cari data [1 Attachment]    dear master excel  saya minta bantuan mengenai rumus yg valueberikut kami lampirkan filnya  Pada Rabu, 13 Januari 2016 15:23, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:    dear para expert  mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan    terima kasih   #yiv1228834807 #yiv1228834807 -- #yiv1228834807ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1228834807 #yiv1228834807ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1228834807 #yiv1228834807ygrp-mkp #yiv1228834807hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1228834807 #yiv1228834807ygrp-mkp #yiv1228834807ads {margin-bottom:10px;}#yiv1228834807 #yiv1228834807ygrp-mkp .yiv1228834807ad {padding:0 0;}#yiv1228834807 #yiv1228834807ygrp-mkp .yiv1228834807ad p {margin:0;}#yiv1228834807 #yiv1228834807ygrp-mkp .yiv1228834807ad a {color:#0000ff;text-decoration:none;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ygrp-lc {font-family:Arial;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ygrp-lc #yiv1228834807hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ygrp-lc .yiv1228834807ad {margin-bottom:10px;padding:0 0;}#yiv1228834807 #yiv1228834807actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1228834807 #yiv1228834807activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1228834807 #yiv1228834807activity span {font-weight:700;}#yiv1228834807 #yiv1228834807activity span:first-child {text-transform:uppercase;}#yiv1228834807 #yiv1228834807activity span a {color:#5085b6;text-decoration:none;}#yiv1228834807 #yiv1228834807activity span span {color:#ff7900;}#yiv1228834807 #yiv1228834807activity span .yiv1228834807underline {text-decoration:underline;}#yiv1228834807 .yiv1228834807attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1228834807 .yiv1228834807attach div a {text-decoration:none;}#yiv1228834807 .yiv1228834807attach img {border:none;padding-right:5px;}#yiv1228834807 .yiv1228834807attach label {display:block;margin-bottom:5px;}#yiv1228834807 .yiv1228834807attach label a {text-decoration:none;}#yiv1228834807 blockquote {margin:0 0 0 4px;}#yiv1228834807 .yiv1228834807bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1228834807 .yiv1228834807bold a {text-decoration:none;}#yiv1228834807 dd.yiv1228834807last p a {font-family:Verdana;font-weight:700;}#yiv1228834807 dd.yiv1228834807last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1228834807 dd.yiv1228834807last p span.yiv1228834807yshortcuts {margin-right:0;}#yiv1228834807 div.yiv1228834807attach-table div div a {text-decoration:none;}#yiv1228834807 div.yiv1228834807attach-table {width:400px;}#yiv1228834807 div.yiv1228834807file-title a, #yiv1228834807 div.yiv1228834807file-title a:active, #yiv1228834807 div.yiv1228834807file-title a:hover, #yiv1228834807 div.yiv1228834807file-title a:visited {text-decoration:none;}#yiv1228834807 div.yiv1228834807photo-title a, #yiv1228834807 div.yiv1228834807photo-title a:active, #yiv1228834807 div.yiv1228834807photo-title a:hover, #yiv1228834807 div.yiv1228834807photo-title a:visited {text-decoration:none;}#yiv1228834807 div#yiv1228834807ygrp-mlmsg #yiv1228834807ygrp-msg p a span.yiv1228834807yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1228834807 .yiv1228834807green {color:#628c2a;}#yiv1228834807 .yiv1228834807MsoNormal {margin:0 0 0 0;}#yiv1228834807 o {font-size:0;}#yiv1228834807 #yiv1228834807photos div {float:left;width:72px;}#yiv1228834807 #yiv1228834807photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1228834807 #yiv1228834807photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1228834807 #yiv1228834807reco-category {font-size:77%;}#yiv1228834807 #yiv1228834807reco-desc {font-size:77%;}#yiv1228834807 .yiv1228834807replbq {margin:4px;}#yiv1228834807 #yiv1228834807ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1228834807 #yiv1228834807ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1228834807 #yiv1228834807ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1228834807 #yiv1228834807ygrp-mlmsg select, #yiv1228834807 input, #yiv1228834807 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1228834807 #yiv1228834807ygrp-mlmsg pre, #yiv1228834807 code {font:115% monospace;}#yiv1228834807 #yiv1228834807ygrp-mlmsg * {line-height:1.22em;}#yiv1228834807 #yiv1228834807ygrp-mlmsg #yiv1228834807logo {padding-bottom:10px;}#yiv1228834807 #yiv1228834807ygrp-msg p a {font-family:Verdana;}#yiv1228834807 #yiv1228834807ygrp-msg p#yiv1228834807attach-count span {color:#1E66AE;font-weight:700;}#yiv1228834807 #yiv1228834807ygrp-reco #yiv1228834807reco-head {color:#ff7900;font-weight:700;}#yiv1228834807 #yiv1228834807ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ov li a {font-size:130%;text-decoration:none;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ov ul {margin:0;padding:0 0 0 8px;}#yiv1228834807 #yiv1228834807ygrp-text {font-family:Georgia;}#yiv1228834807 #yiv1228834807ygrp-text p {margin:0 0 1em 0;}#yiv1228834807 #yiv1228834807ygrp-text tt {font-size:120%;}#yiv1228834807 #yiv1228834807ygrp-vital ul li:last-child {border-right:none !important;}#yiv1228834807

Wed Jan 13, 2016 7:14 pm (PST) . Posted by:

"anas hasbullah" hasbullah_anas

formatnya tetap seperti ini, gimana solusinya
terimakasih
best regardanas

Pada Kamis, 14 Januari 2016 7:27, "'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

  Mas Imam,maaf saya rubah rumusnya, tetapi semoga hasilnya sesuai yang diharapkan.detail, silakan lihat file terlampir.  terimakasih+zainul  From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, January 13, 2016 7:00 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] cari data [1 Attachment]    dear master excel  saya minta bantuan mengenai rumus yg valueberikut kami lampirkan filnya  Pada Rabu, 13 Januari 2016 15:23, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:    dear para expert  mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan    terima kasih   #yiv1228834807 #yiv1228834807 -- #yiv1228834807ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1228834807 #yiv1228834807ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1228834807 #yiv1228834807ygrp-mkp #yiv1228834807hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1228834807 #yiv1228834807ygrp-mkp #yiv1228834807ads {margin-bottom:10px;}#yiv1228834807 #yiv1228834807ygrp-mkp .yiv1228834807ad {padding:0 0;}#yiv1228834807 #yiv1228834807ygrp-mkp .yiv1228834807ad p {margin:0;}#yiv1228834807 #yiv1228834807ygrp-mkp .yiv1228834807ad a {color:#0000ff;text-decoration:none;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ygrp-lc {font-family:Arial;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ygrp-lc #yiv1228834807hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ygrp-lc .yiv1228834807ad {margin-bottom:10px;padding:0 0;}#yiv1228834807 #yiv1228834807actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1228834807 #yiv1228834807activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1228834807 #yiv1228834807activity span {font-weight:700;}#yiv1228834807 #yiv1228834807activity span:first-child {text-transform:uppercase;}#yiv1228834807 #yiv1228834807activity span a {color:#5085b6;text-decoration:none;}#yiv1228834807 #yiv1228834807activity span span {color:#ff7900;}#yiv1228834807 #yiv1228834807activity span .yiv1228834807underline {text-decoration:underline;}#yiv1228834807 .yiv1228834807attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1228834807 .yiv1228834807attach div a {text-decoration:none;}#yiv1228834807 .yiv1228834807attach img {border:none;padding-right:5px;}#yiv1228834807 .yiv1228834807attach label {display:block;margin-bottom:5px;}#yiv1228834807 .yiv1228834807attach label a {text-decoration:none;}#yiv1228834807 blockquote {margin:0 0 0 4px;}#yiv1228834807 .yiv1228834807bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1228834807 .yiv1228834807bold a {text-decoration:none;}#yiv1228834807 dd.yiv1228834807last p a {font-family:Verdana;font-weight:700;}#yiv1228834807 dd.yiv1228834807last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1228834807 dd.yiv1228834807last p span.yiv1228834807yshortcuts {margin-right:0;}#yiv1228834807 div.yiv1228834807attach-table div div a {text-decoration:none;}#yiv1228834807 div.yiv1228834807attach-table {width:400px;}#yiv1228834807 div.yiv1228834807file-title a, #yiv1228834807 div.yiv1228834807file-title a:active, #yiv1228834807 div.yiv1228834807file-title a:hover, #yiv1228834807 div.yiv1228834807file-title a:visited {text-decoration:none;}#yiv1228834807 div.yiv1228834807photo-title a, #yiv1228834807 div.yiv1228834807photo-title a:active, #yiv1228834807 div.yiv1228834807photo-title a:hover, #yiv1228834807 div.yiv1228834807photo-title a:visited {text-decoration:none;}#yiv1228834807 div#yiv1228834807ygrp-mlmsg #yiv1228834807ygrp-msg p a span.yiv1228834807yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1228834807 .yiv1228834807green {color:#628c2a;}#yiv1228834807 .yiv1228834807MsoNormal {margin:0 0 0 0;}#yiv1228834807 o {font-size:0;}#yiv1228834807 #yiv1228834807photos div {float:left;width:72px;}#yiv1228834807 #yiv1228834807photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1228834807 #yiv1228834807photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1228834807 #yiv1228834807reco-category {font-size:77%;}#yiv1228834807 #yiv1228834807reco-desc {font-size:77%;}#yiv1228834807 .yiv1228834807replbq {margin:4px;}#yiv1228834807 #yiv1228834807ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1228834807 #yiv1228834807ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1228834807 #yiv1228834807ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1228834807 #yiv1228834807ygrp-mlmsg select, #yiv1228834807 input, #yiv1228834807 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1228834807 #yiv1228834807ygrp-mlmsg pre, #yiv1228834807 code {font:115% monospace;}#yiv1228834807 #yiv1228834807ygrp-mlmsg * {line-height:1.22em;}#yiv1228834807 #yiv1228834807ygrp-mlmsg #yiv1228834807logo {padding-bottom:10px;}#yiv1228834807 #yiv1228834807ygrp-msg p a {font-family:Verdana;}#yiv1228834807 #yiv1228834807ygrp-msg p#yiv1228834807attach-count span {color:#1E66AE;font-weight:700;}#yiv1228834807 #yiv1228834807ygrp-reco #yiv1228834807reco-head {color:#ff7900;font-weight:700;}#yiv1228834807 #yiv1228834807ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ov li a {font-size:130%;text-decoration:none;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1228834807 #yiv1228834807ygrp-sponsor #yiv1228834807ov ul {margin:0;padding:0 0 0 8px;}#yiv1228834807 #yiv1228834807ygrp-text {font-family:Georgia;}#yiv1228834807 #yiv1228834807ygrp-text p {margin:0 0 1em 0;}#yiv1228834807 #yiv1228834807ygrp-text tt {font-size:120%;}#yiv1228834807 #yiv1228834807ygrp-vital ul li:last-child {border-right:none !important;}#yiv1228834807

Wed Jan 13, 2016 7:18 am (PST) . Posted by:

boyodibyo

dear suhu dan master,,,

mohon bantuan untuk memisahkan data dari sheet1 ke sheet baru berikutnya tetapi masih 1 file yang sama?

apakah ada cara nya pake rumus/ pake macro vba?

mohon dibantu karena jika data nya banyak akan sulit sekali karena masih manual

terlampir data contoh terlampir

Wed Jan 13, 2016 4:22 pm (PST) . Posted by:

"zainul_ulum[at]yahoo[dot]com" zainul_ulum

Silakan dicoba file terlampir Mas,

semoga sesuai harapan

+zainul

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, January 13, 2016 8:37 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] mohon bantuan memisahkan data ke sheet baru [1 Attachment]

dear suhu dan master,,,

mohon bantuan untuk memisahkan data dari sheet1 ke sheet baru berikutnya tetapi masih 1 file yang sama?

apakah ada cara nya pake rumus/ pake macro vba?

mohon dibantu karena jika data nya banyak akan sulit sekali karena masih manual

terlampir data contoh terlampir

Wed Jan 13, 2016 8:50 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Imam,

Bisa di lampirkan kode VBAnya ngga...

Sent from Yahoo Mail on Android

Wed Jan 13, 2016 7:13 pm (PST) . Posted by:

"imam cahyo yuwono"

dear Mr Toby
maaf Mr Toby saya juga masih bingung menyusun kode vba nya intinya ingin mencari data dari pilihan 2 kategori menggunakan option button pada textbox di ketik yang akan dicari dan listbox menampilkan secara langsungkalo pun ada contoh yang mendekati juga tidak apa-apa sekalian menambah ilmu vba sayaterima kasih


On Wednesday, January 13, 2016 11:50 PM, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


 
| Dear Imam,Bisa di lampirkan kode VBAnya ngga...Sent from Yahoo Mail on Android |

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] cari data [1 Attachment]
Sent: Wed, Jan 13, 2016 8:23:26 AM


|   dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih
|

#yiv1300438828 #yiv1300438828 -- #yiv1300438828ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1300438828 #yiv1300438828ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1300438828 #yiv1300438828ygrp-mkp #yiv1300438828hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1300438828 #yiv1300438828ygrp-mkp #yiv1300438828ads {margin-bottom:10px;}#yiv1300438828 #yiv1300438828ygrp-mkp .yiv1300438828ad {padding:0 0;}#yiv1300438828 #yiv1300438828ygrp-mkp .yiv1300438828ad p {margin:0;}#yiv1300438828 #yiv1300438828ygrp-mkp .yiv1300438828ad a {color:#0000ff;text-decoration:none;}#yiv1300438828 #yiv1300438828ygrp-sponsor #yiv1300438828ygrp-lc {font-family:Arial;}#yiv1300438828 #yiv1300438828ygrp-sponsor #yiv1300438828ygrp-lc #yiv1300438828hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1300438828 #yiv1300438828ygrp-sponsor #yiv1300438828ygrp-lc .yiv1300438828ad {margin-bottom:10px;padding:0 0;}#yiv1300438828 #yiv1300438828actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1300438828 #yiv1300438828activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1300438828 #yiv1300438828activity span {font-weight:700;}#yiv1300438828 #yiv1300438828activity span:first-child {text-transform:uppercase;}#yiv1300438828 #yiv1300438828activity span a {color:#5085b6;text-decoration:none;}#yiv1300438828 #yiv1300438828activity span span {color:#ff7900;}#yiv1300438828 #yiv1300438828activity span .yiv1300438828underline {text-decoration:underline;}#yiv1300438828 .yiv1300438828attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1300438828 .yiv1300438828attach div a {text-decoration:none;}#yiv1300438828 .yiv1300438828attach img {border:none;padding-right:5px;}#yiv1300438828 .yiv1300438828attach label {display:block;margin-bottom:5px;}#yiv1300438828 .yiv1300438828attach label a {text-decoration:none;}#yiv1300438828 blockquote {margin:0 0 0 4px;}#yiv1300438828 .yiv1300438828bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1300438828 .yiv1300438828bold a {text-decoration:none;}#yiv1300438828 dd.yiv1300438828last p a {font-family:Verdana;font-weight:700;}#yiv1300438828 dd.yiv1300438828last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1300438828 dd.yiv1300438828last p span.yiv1300438828yshortcuts {margin-right:0;}#yiv1300438828 div.yiv1300438828attach-table div div a {text-decoration:none;}#yiv1300438828 div.yiv1300438828attach-table {width:400px;}#yiv1300438828 div.yiv1300438828file-title a, #yiv1300438828 div.yiv1300438828file-title a:active, #yiv1300438828 div.yiv1300438828file-title a:hover, #yiv1300438828 div.yiv1300438828file-title a:visited {text-decoration:none;}#yiv1300438828 div.yiv1300438828photo-title a, #yiv1300438828 div.yiv1300438828photo-title a:active, #yiv1300438828 div.yiv1300438828photo-title a:hover, #yiv1300438828 div.yiv1300438828photo-title a:visited {text-decoration:none;}#yiv1300438828 div#yiv1300438828ygrp-mlmsg #yiv1300438828ygrp-msg p a span.yiv1300438828yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1300438828 .yiv1300438828green {color:#628c2a;}#yiv1300438828 .yiv1300438828MsoNormal {margin:0 0 0 0;}#yiv1300438828 o {font-size:0;}#yiv1300438828 #yiv1300438828photos div {float:left;width:72px;}#yiv1300438828 #yiv1300438828photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1300438828 #yiv1300438828photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1300438828 #yiv1300438828reco-category {font-size:77%;}#yiv1300438828 #yiv1300438828reco-desc {font-size:77%;}#yiv1300438828 .yiv1300438828replbq {margin:4px;}#yiv1300438828 #yiv1300438828ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1300438828 #yiv1300438828ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1300438828 #yiv1300438828ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1300438828 #yiv1300438828ygrp-mlmsg select, #yiv1300438828 input, #yiv1300438828 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1300438828 #yiv1300438828ygrp-mlmsg pre, #yiv1300438828 code {font:115% monospace;}#yiv1300438828 #yiv1300438828ygrp-mlmsg * {line-height:1.22em;}#yiv1300438828 #yiv1300438828ygrp-mlmsg #yiv1300438828logo {padding-bottom:10px;}#yiv1300438828 #yiv1300438828ygrp-msg p a {font-family:Verdana;}#yiv1300438828 #yiv1300438828ygrp-msg p#yiv1300438828attach-count span {color:#1E66AE;font-weight:700;}#yiv1300438828 #yiv1300438828ygrp-reco #yiv1300438828reco-head {color:#ff7900;font-weight:700;}#yiv1300438828 #yiv1300438828ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1300438828 #yiv1300438828ygrp-sponsor #yiv1300438828ov li a {font-size:130%;text-decoration:none;}#yiv1300438828 #yiv1300438828ygrp-sponsor #yiv1300438828ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1300438828 #yiv1300438828ygrp-sponsor #yiv1300438828ov ul {margin:0;padding:0 0 0 8px;}#yiv1300438828 #yiv1300438828ygrp-text {font-family:Georgia;}#yiv1300438828 #yiv1300438828ygrp-text p {margin:0 0 1em 0;}#yiv1300438828 #yiv1300438828ygrp-text tt {font-size:120%;}#yiv1300438828 #yiv1300438828ygrp-vital ul li:last-child {border-right:none !important;}#yiv1300438828

Wed Jan 13, 2016 7:13 pm (PST) . Posted by:

"anas hasbullah" hasbullah_anas

ini file xlnya, mohon bantuannya
terimakasih

Pada Rabu, 13 Januari 2016 23:50, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
| Dear Imam,Bisa di lampirkan kode VBAnya ngga...Sent from Yahoo Mail on Android |

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>;

To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] cari data [1 Attachment]
Sent: Wed, Jan 13, 2016 8:23:26 AM


|   dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih
|

#yiv0463196066 #yiv0463196066 -- #yiv0463196066ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0463196066 #yiv0463196066ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0463196066 #yiv0463196066ygrp-mkp #yiv0463196066hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0463196066 #yiv0463196066ygrp-mkp #yiv0463196066ads {margin-bottom:10px;}#yiv0463196066 #yiv0463196066ygrp-mkp .yiv0463196066ad {padding:0 0;}#yiv0463196066 #yiv0463196066ygrp-mkp .yiv0463196066ad p {margin:0;}#yiv0463196066 #yiv0463196066ygrp-mkp .yiv0463196066ad a {color:#0000ff;text-decoration:none;}#yiv0463196066 #yiv0463196066ygrp-sponsor #yiv0463196066ygrp-lc {font-family:Arial;}#yiv0463196066 #yiv0463196066ygrp-sponsor #yiv0463196066ygrp-lc #yiv0463196066hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0463196066 #yiv0463196066ygrp-sponsor #yiv0463196066ygrp-lc .yiv0463196066ad {margin-bottom:10px;padding:0 0;}#yiv0463196066 #yiv0463196066actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0463196066 #yiv0463196066activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0463196066 #yiv0463196066activity span {font-weight:700;}#yiv0463196066 #yiv0463196066activity span:first-child {text-transform:uppercase;}#yiv0463196066 #yiv0463196066activity span a {color:#5085b6;text-decoration:none;}#yiv0463196066 #yiv0463196066activity span span {color:#ff7900;}#yiv0463196066 #yiv0463196066activity span .yiv0463196066underline {text-decoration:underline;}#yiv0463196066 .yiv0463196066attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0463196066 .yiv0463196066attach div a {text-decoration:none;}#yiv0463196066 .yiv0463196066attach img {border:none;padding-right:5px;}#yiv0463196066 .yiv0463196066attach label {display:block;margin-bottom:5px;}#yiv0463196066 .yiv0463196066attach label a {text-decoration:none;}#yiv0463196066 blockquote {margin:0 0 0 4px;}#yiv0463196066 .yiv0463196066bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0463196066 .yiv0463196066bold a {text-decoration:none;}#yiv0463196066 dd.yiv0463196066last p a {font-family:Verdana;font-weight:700;}#yiv0463196066 dd.yiv0463196066last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0463196066 dd.yiv0463196066last p span.yiv0463196066yshortcuts {margin-right:0;}#yiv0463196066 div.yiv0463196066attach-table div div a {text-decoration:none;}#yiv0463196066 div.yiv0463196066attach-table {width:400px;}#yiv0463196066 div.yiv0463196066file-title a, #yiv0463196066 div.yiv0463196066file-title a:active, #yiv0463196066 div.yiv0463196066file-title a:hover, #yiv0463196066 div.yiv0463196066file-title a:visited {text-decoration:none;}#yiv0463196066 div.yiv0463196066photo-title a, #yiv0463196066 div.yiv0463196066photo-title a:active, #yiv0463196066 div.yiv0463196066photo-title a:hover, #yiv0463196066 div.yiv0463196066photo-title a:visited {text-decoration:none;}#yiv0463196066 div#yiv0463196066ygrp-mlmsg #yiv0463196066ygrp-msg p a span.yiv0463196066yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0463196066 .yiv0463196066green {color:#628c2a;}#yiv0463196066 .yiv0463196066MsoNormal {margin:0 0 0 0;}#yiv0463196066 o {font-size:0;}#yiv0463196066 #yiv0463196066photos div {float:left;width:72px;}#yiv0463196066 #yiv0463196066photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0463196066 #yiv0463196066photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0463196066 #yiv0463196066reco-category {font-size:77%;}#yiv0463196066 #yiv0463196066reco-desc {font-size:77%;}#yiv0463196066 .yiv0463196066replbq {margin:4px;}#yiv0463196066 #yiv0463196066ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0463196066 #yiv0463196066ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0463196066 #yiv0463196066ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0463196066 #yiv0463196066ygrp-mlmsg select, #yiv0463196066 input, #yiv0463196066 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0463196066 #yiv0463196066ygrp-mlmsg pre, #yiv0463196066 code {font:115% monospace;}#yiv0463196066 #yiv0463196066ygrp-mlmsg * {line-height:1.22em;}#yiv0463196066 #yiv0463196066ygrp-mlmsg #yiv0463196066logo {padding-bottom:10px;}#yiv0463196066 #yiv0463196066ygrp-msg p a {font-family:Verdana;}#yiv0463196066 #yiv0463196066ygrp-msg p#yiv0463196066attach-count span {color:#1E66AE;font-weight:700;}#yiv0463196066 #yiv0463196066ygrp-reco #yiv0463196066reco-head {color:#ff7900;font-weight:700;}#yiv0463196066 #yiv0463196066ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0463196066 #yiv0463196066ygrp-sponsor #yiv0463196066ov li a {font-size:130%;text-decoration:none;}#yiv0463196066 #yiv0463196066ygrp-sponsor #yiv0463196066ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0463196066 #yiv0463196066ygrp-sponsor #yiv0463196066ov ul {margin:0;padding:0 0 0 8px;}#yiv0463196066 #yiv0463196066ygrp-text {font-family:Georgia;}#yiv0463196066 #yiv0463196066ygrp-text p {margin:0 0 1em 0;}#yiv0463196066 #yiv0463196066ygrp-text tt {font-size:120%;}#yiv0463196066 #yiv0463196066ygrp-vital ul li:last-child {border-right:none !important;}#yiv0463196066

Thu Jan 14, 2016 2:11 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Ini file warisan mbak Siti yang mirip, hanya pilihannya 1 kategori.
Salam,HK

From: "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 14 January 2016, 6:48
Subject: Re: [belajar-excel] cari data

  dear Mr Toby
maaf Mr Toby saya juga masih bingung menyusun kode vba nya intinya ingin mencari data dari pilihan 2 kategori menggunakan option button pada textbox di ketik yang akan dicari dan listbox menampilkan secara langsungkalo pun ada contoh yang mendekati juga tidak apa-apa sekalian menambah ilmu vba sayaterima kasih


On Wednesday, January 13, 2016 11:50 PM, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


 
| Dear Imam,Bisa di lampirkan kode VBAnya ngga...Sent from Yahoo Mail on Android |

From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] cari data [1 Attachment]
Sent: Wed, Jan 13, 2016 8:23:26 AM


|   dear para expert

mohon bantuannya membuat pencarian data dengan contoh form seperti yang saya lampirkan

terima kasih
|

#yiv0624300030 #yiv0624300030 -- #yiv0624300030ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0624300030 #yiv0624300030ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0624300030 #yiv0624300030ygrp-mkp #yiv0624300030hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0624300030 #yiv0624300030ygrp-mkp #yiv0624300030ads {margin-bottom:10px;}#yiv0624300030 #yiv0624300030ygrp-mkp .yiv0624300030ad {padding:0 0;}#yiv0624300030 #yiv0624300030ygrp-mkp .yiv0624300030ad p {margin:0;}#yiv0624300030 #yiv0624300030ygrp-mkp .yiv0624300030ad a {color:#0000ff;text-decoration:none;}#yiv0624300030 #yiv0624300030ygrp-sponsor #yiv0624300030ygrp-lc {font-family:Arial;}#yiv0624300030 #yiv0624300030ygrp-sponsor #yiv0624300030ygrp-lc #yiv0624300030hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0624300030 #yiv0624300030ygrp-sponsor #yiv0624300030ygrp-lc .yiv0624300030ad {margin-bottom:10px;padding:0 0;}#yiv0624300030 #yiv0624300030actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0624300030 #yiv0624300030activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0624300030 #yiv0624300030activity span {font-weight:700;}#yiv0624300030 #yiv0624300030activity span:first-child {text-transform:uppercase;}#yiv0624300030 #yiv0624300030activity span a {color:#5085b6;text-decoration:none;}#yiv0624300030 #yiv0624300030activity span span {color:#ff7900;}#yiv0624300030 #yiv0624300030activity span .yiv0624300030underline {text-decoration:underline;}#yiv0624300030 .yiv0624300030attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0624300030 .yiv0624300030attach div a {text-decoration:none;}#yiv0624300030 .yiv0624300030attach img {border:none;padding-right:5px;}#yiv0624300030 .yiv0624300030attach label {display:block;margin-bottom:5px;}#yiv0624300030 .yiv0624300030attach label a {text-decoration:none;}#yiv0624300030 blockquote {margin:0 0 0 4px;}#yiv0624300030 .yiv0624300030bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0624300030 .yiv0624300030bold a {text-decoration:none;}#yiv0624300030 dd.yiv0624300030last p a {font-family:Verdana;font-weight:700;}#yiv0624300030 dd.yiv0624300030last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0624300030 dd.yiv0624300030last p span.yiv0624300030yshortcuts {margin-right:0;}#yiv0624300030 div.yiv0624300030attach-table div div a {text-decoration:none;}#yiv0624300030 div.yiv0624300030attach-table {width:400px;}#yiv0624300030 div.yiv0624300030file-title a, #yiv0624300030 div.yiv0624300030file-title a:active, #yiv0624300030 div.yiv0624300030file-title a:hover, #yiv0624300030 div.yiv0624300030file-title a:visited {text-decoration:none;}#yiv0624300030 div.yiv0624300030photo-title a, #yiv0624300030 div.yiv0624300030photo-title a:active, #yiv0624300030 div.yiv0624300030photo-title a:hover, #yiv0624300030 div.yiv0624300030photo-title a:visited {text-decoration:none;}#yiv0624300030 div#yiv0624300030ygrp-mlmsg #yiv0624300030ygrp-msg p a span.yiv0624300030yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0624300030 .yiv0624300030green {color:#628c2a;}#yiv0624300030 .yiv0624300030MsoNormal {margin:0 0 0 0;}#yiv0624300030 o {font-size:0;}#yiv0624300030 #yiv0624300030photos div {float:left;width:72px;}#yiv0624300030 #yiv0624300030photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0624300030 #yiv0624300030photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0624300030 #yiv0624300030reco-category {font-size:77%;}#yiv0624300030 #yiv0624300030reco-desc {font-size:77%;}#yiv0624300030 .yiv0624300030replbq {margin:4px;}#yiv0624300030 #yiv0624300030ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0624300030 #yiv0624300030ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0624300030 #yiv0624300030ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0624300030 #yiv0624300030ygrp-mlmsg select, #yiv0624300030 input, #yiv0624300030 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0624300030 #yiv0624300030ygrp-mlmsg pre, #yiv0624300030 code {font:115% monospace;}#yiv0624300030 #yiv0624300030ygrp-mlmsg * {line-height:1.22em;}#yiv0624300030 #yiv0624300030ygrp-mlmsg #yiv0624300030logo {padding-bottom:10px;}#yiv0624300030 #yiv0624300030ygrp-msg p a {font-family:Verdana;}#yiv0624300030 #yiv0624300030ygrp-msg p#yiv0624300030attach-count span {color:#1E66AE;font-weight:700;}#yiv0624300030 #yiv0624300030ygrp-reco #yiv0624300030reco-head {color:#ff7900;font-weight:700;}#yiv0624300030 #yiv0624300030ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0624300030 #yiv0624300030ygrp-sponsor #yiv0624300030ov li a {font-size:130%;text-decoration:none;}#yiv0624300030 #yiv0624300030ygrp-sponsor #yiv0624300030ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0624300030 #yiv0624300030ygrp-sponsor #yiv0624300030ov ul {margin:0;padding:0 0 0 8px;}#yiv0624300030 #yiv0624300030ygrp-text {font-family:Georgia;}#yiv0624300030 #yiv0624300030ygrp-text p {margin:0 0 1em 0;}#yiv0624300030 #yiv0624300030ygrp-text tt {font-size:120%;}#yiv0624300030 #yiv0624300030ygrp-vital ul li:last-child {border-right:none !important;}#yiv0624300030

Wed Jan 13, 2016 5:52 pm (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Coba cari juga di file milis...
Topiknya split atau memisahkan data.

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:14/01/2016 7:21 AM (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: RE: [belajar-excel] mohon bantuan memisahkan data ke sheet baru [1 Attachment] </div><div>
</div>Silakan dicoba file terlampir Mas,

semoga sesuai harapan

+zainul

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, January 13, 2016 8:37 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] mohon bantuan memisahkan data ke sheet baru [1 Attachment]

dear suhu dan master,,,

mohon bantuan untuk memisahkan data dari sheet1 ke sheet baru berikutnya tetapi masih 1 file yang sama?

apakah ada cara nya pake rumus/ pake macro vba?

mohon dibantu karena jika data nya banyak akan sulit sekali karena masih manual

terlampir data contoh terlampir

============================================================
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