12 Messages
Digest #3718
2b
Re: mohon bantuan memisahkan data ke sheet baru [1 Attachment] by "zainul_ulum[at]yahoo[dot]com" zainul_ulum
4
Fwd: RE: [belajar-excel] mohon bantuan memisahkan data ke sheet baru 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
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-
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
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-
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
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
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-
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
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-
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
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
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
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
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-
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
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-
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
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-
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
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
---------------------------------------------------------------------
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:
Posting Komentar