[belajar-excel] Mohon rumus formula kelipatan [1 Attachment]

[Rudhie rudhied...@yahoo.com [belajar-excel]]

Dear Be Exceller
Selamat siangMohon bantuannya bagaimana membuat formula perhitungan kelipatan 
untuk decimal dibelakang angka.Contoh file saya lampirkan.
Terima Kasih


hitung kelipatan.xlsx
Description: MS-Excel 2007 spreadsheet

Trs: [belajar-excel] Filter dengan Vba Excel [1 Attachment]

[HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]]

   Assalamualaikum
 

 Yth. Para Master
 

 Terlampir file excel yang saya mau buat filter VBA, bisakah dibantu untuk code 
VBA pada kasus saya
 

 Terimakasih
 Wassalamualaikum

 
 
 
 



 
 
 
 




FILTER DATA DENGAN VBA.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: RE: RE: RE: [belajar-excel] macro untuk menyembunyikan kolom

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

pake method protect/unprotect sebelum hidden columns.

Sent from Yahoo Mail on Android

[belajar-excel] Lookup List Value [1 Attachment]

['Heri Pamungkas ( Gmail )' ghery.dha...@gmail.com [belajar-excel]]

-- 
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.

Dear Rekan-Rekan,

Saya mempunyai kasus dalam membuat Report data.
Yaitu merubah kumpulan data menjadi Format yang mudah di lihat.

Tetapi tidak boleh menggunakan Kolom bantu atau Pivot.

Terlampir File nya.

Bagaimana Formula untuk Valuenya ?!


وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

Warm Regards,



Problem.xlsx
Description: MS-Excel 2007 spreadsheet

RE: RE: RE: [belajar-excel] macro untuk menyembunyikan kolom

['prazt' praztm...@gmail.com [belajar-excel]]

Tapi jika sheet yg di maksud tersebut di protect kok ga bisa jalan ya...ada 
solusi ?

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] 
Sent: 7 Nopember 2015 14:05
To: belajar-excel@yahoogroups.com
Subject: Re: RE: RE: [belajar-excel] macro untuk menyembunyikan kolom [1 
Attachment]

 

  


Hai Prazt,

sebenarnya sedikit modifikasi dari formula yg td bisa kita inginkan apa aja yg 
mau di hide.
ok,ini saya berikan contohnya tetap dgn menggunakan method columns hidden di 
tambah dgn method loop untuk mencari data yg kosong, anda bisa kembangkan 
sesuai kebutuhan,tapi kalo memang belum memenuhi keinginan anda ya"maaf".
mungkin teman2 beexceler yg akan menambahkan.

TerimaKasih.

Sent from Yahoo Mail on Android 
 

 

  _  

From: 'prazt' praztm...@gmail.com [belajar-excel] 
; 
To: ; 
Subject: RE: RE: [belajar-excel] macro untuk menyembunyikan kolom 
Sent: Sat, Nov 7, 2015 5:12:28 AM 

 


  

Maksudnya Kolom yang tanpa nilai, tetapi perlu diperhatikan bahwa setiap SK itu 
ada rerata nilainya di samping kanan, nah kolom rerata SK tersebut juga ikut 
terhidden sesuai SK yg tidak ada nilainya, coba perhatikan file lampirannya 
untuk lebih spesifik.

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] 
Sent: 7 Nopember 2015 11:58
To: belajar-excel@yahoogroups.com
Subject: Re: RE: [belajar-excel] macro untuk menyembunyikan kolom

 

  


maksudnya kolom yg tanpa nilai yg di hidden..? atau specifik apa yg mesti di 
hidden..

Sent from Yahoo Mail on Android 
 

 

  _  

From: 'prazt' praztm...@gmail.com [belajar-excel] 
; 
To: ; 
Subject: RE: [belajar-excel] macro untuk menyembunyikan kolom 
Sent: Sat, Nov 7, 2015 4:46:09 AM 

 


  

Kalau seperti ini kan hanya kolom “AE:AX” saja yang kosong, padahal kolom yang 
kosong bisa berubah ubah sesaui si guru yang makai,

Dengan asumsi bahwa setiap mata pelajaran kan banyaknya materi berbeda-beda 
sehingga kurang efisien kalau seperti itu “maaf”

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] 
Sent: 7 Nopember 2015 11:39
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] macro untuk menyembunyikan kolom

 

  


Hai Prazt,

Coba gunakan method Coulumns hidden.
mungkin seperti ini:
jika yg mau di hidden coulumn "AE:AX"
Sheet1.Coulumns("AE:AX").Hidden = True

kalo mau di buka lagi tinggal di ubah aja True jadi False.

Semoga membantu.

TerimaKasih.

Sent from Yahoo Mail on Android 
 

 

  _  

From: 'prazt' praztm...@gmail.com [belajar-excel] 
; 
To: ; 
Subject: [belajar-excel] macro untuk menyembunyikan kolom [1 Attachment] 
Sent: Sat, Nov 7, 2015 3:49:56 AM 

 


  

Assalamu’alaikum Wr.Wb

Dear rekan-rekan semua

Mohon bantuannya ya..saya ingin menyembunyikan kolom yang nilainya kosong/tidak 
ada nilainya (maaf kalau ada salah penyebutan) dengan menggunakan makro

dengan cara mengklik tombol yang disediakan, dan jika suatu saat kolom tersebut 
dibutuhkan maka bisa ditampilkan kembali dengan mengklik tombol

tampilkan semua (yg sudah tersedia)

ilustrasinya ada pada file lampiran

 

Wassalamu’alaikum

 

  _  


  Avast logo

Email tidak mengandung virus pemeriksaan mengunakan piranti Avast antivirus. 
www.avast.com   

 

  _  


  Avast logo

Email tidak mengandung virus pemeriksaan mengunakan piranti Avast antivirus. 
www.avast.com   

 

  _  


  Avast logo

Email tidak mengandung virus pemeriksaan mengunakan piranti Avast antivirus. 
www.avast.com   





---
Email tidak mengandung virus pemeriksaan mengunakan piranti Avast antivirus.
https://www.avast.com/antivirus

Re: Bls: [belajar-excel] Extract data lapangan ke dalam form report

[Teuku Machfudz Gani aku.ma...@yahoo.com [belajar-excel]]

Re: [belajar-excel] Menampilkan data berstatus 0 di listbox

[Rudi Anto rudi.ex...@yahoo.com [belajar-excel]]

Terima kasih atas responnya om toby, ada contoh yang lainnya.Sekiranya seperti 
file di maksud.
Salam,Rudi





 On Monday, November 9, 2015 1:19 AM, "Toby kenzo tobyke...@yahoo.co.id 
[belajar-excel]"  wrote:



  
| Hai Rudi,Mungkin file ini bisa membantu.

TerimaKasih.Sent from Yahoo Mail on Android |



 From:  Rudi Anto rudi.ex...@yahoo.com [belajar-excel] 
;
  To:  ;
  Subject:  Re: [belajar-excel] Menampilkan data berstatus 0 di listbox [1 
Attachment]
  Sent:  Sun, Nov 8, 2015 2:53:17 PM


|     mohon maaf, waktu kirim file tidak melihat ukuran filenya.. jadi melar 
banget,berikut saya sertakan file attachmentnya
salam,Rudi








  On Sunday, November 8, 2015 7:22 PM, "Hendrik Karnadi 
hendrikkarn...@yahoo.com [belajar-excel]"  wrote:



     Hai Rudi,Sambil menunggu lampirannya...pada prinsipnya bisa.
Salam,HK
Sent from Samsung Mobile


 Original message From: "Rudi Anto rudi.ex...@yahoo.com 
[belajar-excel]" Date:08/11/2015 5:52 PM (GMT+07:00) To: 
belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilkan data 
berstatus 0 di listbox
   Selamat malam member Be-Excel, smoga smua slalu dalam lindungan-Nya. Aamiin.
Langsung ke pokok permasalahan, disini saya punya contoh data yang mana saya 
menginginkan data yang tampil di listbox hanya yang mempunyai status 0,
mohon bantuan rekan2 untuk permasalahan yang saya hadapi.Sebelumnya saya 
ucapkan terima kasih yang sebesar-besarnya


Salam,Rudi


--- Mods ---File lampiran melebihi 250KB dilepas dari email. Silakan posting 
ulang file lampiran yang diusahakan maksimal 250KB dengan cara me-reply email 
ini.--


  |


 #yiv4462108085 #yiv4462108085 -- #yiv4462108085ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4462108085 
#yiv4462108085ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4462108085 
#yiv4462108085ygrp-mkp #yiv4462108085hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4462108085 #yiv4462108085ygrp-mkp #yiv4462108085ads 
{margin-bottom:10px;}#yiv4462108085 #yiv4462108085ygrp-mkp .yiv4462108085ad 
{padding:0 0;}#yiv4462108085 #yiv4462108085ygrp-mkp .yiv4462108085ad p 
{margin:0;}#yiv4462108085 #yiv4462108085ygrp-mkp .yiv4462108085ad a 
{color:#ff;text-decoration:none;}#yiv4462108085 #yiv4462108085ygrp-sponsor 
#yiv4462108085ygrp-lc {font-family:Arial;}#yiv4462108085 
#yiv4462108085ygrp-sponsor #yiv4462108085ygrp-lc #yiv4462108085hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4462108085 
#yiv4462108085ygrp-sponsor #yiv4462108085ygrp-lc .yiv4462108085ad 
{margin-bottom:10px;padding:0 0;}#yiv4462108085 #yiv4462108085actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4462108085 
#yiv4462108085activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4462108085
 #yiv4462108085activity span {font-weight:700;}#yiv4462108085 
#yiv4462108085activity span:first-child 
{text-transform:uppercase;}#yiv4462108085 #yiv4462108085activity span a 
{color:#5085b6;text-decoration:none;}#yiv4462108085 #yiv4462108085activity span 
span {color:#ff7900;}#yiv4462108085 #yiv4462108085activity span 
.yiv4462108085underline {text-decoration:underline;}#yiv4462108085 
.yiv4462108085attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4462108085 .yiv4462108085attach div a 
{text-decoration:none;}#yiv4462108085 .yiv4462108085attach img 
{border:none;padding-right:5px;}#yiv4462108085 .yiv4462108085attach label 
{display:block;margin-bottom:5px;}#yiv4462108085 .yiv4462108085attach label a 
{text-decoration:none;}#yiv4462108085 blockquote {margin:0 0 0 
4px;}#yiv4462108085 .yiv4462108085bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4462108085 
.yiv4462108085bold a {text-decoration:none;}#yiv4462108085 dd.yiv4462108085last 
p a {font-family:Verdana;font-weight:700;}#yiv4462108085 dd.yiv4462108085last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4462108085 
dd.yiv4462108085last p span.yiv4462108085yshortcuts 
{margin-right:0;}#yiv4462108085 div.yiv4462108085attach-table div div a 
{text-decoration:none;}#yiv4462108085 div.yiv4462108085attach-table 
{width:400px;}#yiv4462108085 div.yiv4462108085file-title a, #yiv4462108085 
div.yiv4462108085file-title a:active, #yiv4462108085 
div.yiv4462108085file-title a:hover, #yiv4462108085 div.yiv4462108085file-title 
a:visited {text-decoration:none;}#yiv4462108085 div.yiv4462108085photo-title a, 
#yiv4462108085 div.yiv4462108085photo-title a:active, #yiv4462108085 
div.yiv4462108085photo-title a:hover, #yiv4462108085 
div.yiv4462108085photo-title a:visited {text-decoration:none;}#yiv4462108085 
div#yiv4462108085ygrp-mlmsg #yiv4462108085ygrp-msg p a 
span.yiv4462108085yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4462108085 
.yiv4462108085green {color:#628c2a;}#yiv4462108085 .yiv4462108085MsoNormal 
{margin:0 0 0 0;}#yiv446210

Re: [belajar-excel] Menampilkan data berstatus 0 di listbox [1 Attachment]

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

Hai Rudi,

Mungkin file ini bisa membantu.

TerimaKasih.

Sent from Yahoo Mail on Android



contoh_toby.xlsb
Description: Zip archive

Re: [belajar-excel] Menampilkan data berstatus 0 di listbox [1 Attachment]

[Rudi Anto rudi.ex...@yahoo.com [belajar-excel]]

mohon maaf, waktu kirim file tidak melihat ukuran filenya.. jadi melar 
banget,berikut saya sertakan file attachmentnya
salam,Rudi








  On Sunday, November 8, 2015 7:22 PM, "Hendrik Karnadi 
hendrikkarn...@yahoo.com [belajar-excel]"  wrote:



     Hai Rudi,Sambil menunggu lampirannya...pada prinsipnya bisa.
Salam,HK
Sent from Samsung Mobile


 Original message From: "Rudi Anto rudi.ex...@yahoo.com 
[belajar-excel]" Date:08/11/2015 5:52 PM (GMT+07:00) To: 
belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilkan data 
berstatus 0 di listbox
   Selamat malam member Be-Excel, smoga smua slalu dalam lindungan-Nya. Aamiin.
Langsung ke pokok permasalahan, disini saya punya contoh data yang mana saya 
menginginkan data yang tampil di listbox hanya yang mempunyai status 0,
mohon bantuan rekan2 untuk permasalahan yang saya hadapi.Sebelumnya saya 
ucapkan terima kasih yang sebesar-besarnya


Salam,Rudi


--- Mods ---File lampiran melebihi 250KB dilepas dari email. Silakan posting 
ulang file lampiran yang diusahakan maksimal 250KB dengan cara me-reply email 
ini.--   #yiv6466480400 -- #yiv6466480400ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6466480400 
#yiv6466480400ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6466480400 
#yiv6466480400ygrp-mkp #yiv6466480400hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv6466480400 #yiv6466480400ygrp-mkp #yiv6466480400ads 
{margin-bottom:10px;}#yiv6466480400 #yiv6466480400ygrp-mkp .yiv6466480400ad 
{padding:0 0;}#yiv6466480400 #yiv6466480400ygrp-mkp .yiv6466480400ad p 
{margin:0;}#yiv6466480400 #yiv6466480400ygrp-mkp .yiv6466480400ad a 
{color:#ff;text-decoration:none;}#yiv6466480400 #yiv6466480400ygrp-sponsor 
#yiv6466480400ygrp-lc {font-family:Arial;}#yiv6466480400 
#yiv6466480400ygrp-sponsor #yiv6466480400ygrp-lc #yiv6466480400hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6466480400 
#yiv6466480400ygrp-sponsor #yiv6466480400ygrp-lc .yiv6466480400ad 
{margin-bottom:10px;padding:0 0;}#yiv6466480400 #yiv6466480400actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6466480400 
#yiv6466480400activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6466480400
 #yiv6466480400activity span {font-weight:700;}#yiv6466480400 
#yiv6466480400activity span:first-child 
{text-transform:uppercase;}#yiv6466480400 #yiv6466480400activity span a 
{color:#5085b6;text-decoration:none;}#yiv6466480400 #yiv6466480400activity span 
span {color:#ff7900;}#yiv6466480400 #yiv6466480400activity span 
.yiv6466480400underline {text-decoration:underline;}#yiv6466480400 
.yiv6466480400attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv6466480400 .yiv6466480400attach div a 
{text-decoration:none;}#yiv6466480400 .yiv6466480400attach img 
{border:none;padding-right:5px;}#yiv6466480400 .yiv6466480400attach label 
{display:block;margin-bottom:5px;}#yiv6466480400 .yiv6466480400attach label a 
{text-decoration:none;}#yiv6466480400 blockquote {margin:0 0 0 
4px;}#yiv6466480400 .yiv6466480400bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6466480400 
.yiv6466480400bold a {text-decoration:none;}#yiv6466480400 dd.yiv6466480400last 
p a {font-family:Verdana;font-weight:700;}#yiv6466480400 dd.yiv6466480400last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6466480400 
dd.yiv6466480400last p span.yiv6466480400yshortcuts 
{margin-right:0;}#yiv6466480400 div.yiv6466480400attach-table div div a 
{text-decoration:none;}#yiv6466480400 div.yiv6466480400attach-table 
{width:400px;}#yiv6466480400 div.yiv6466480400file-title a, #yiv6466480400 
div.yiv6466480400file-title a:active, #yiv6466480400 
div.yiv6466480400file-title a:hover, #yiv6466480400 div.yiv6466480400file-title 
a:visited {text-decoration:none;}#yiv6466480400 div.yiv6466480400photo-title a, 
#yiv6466480400 div.yiv6466480400photo-title a:active, #yiv6466480400 
div.yiv6466480400photo-title a:hover, #yiv6466480400 
div.yiv6466480400photo-title a:visited {text-decoration:none;}#yiv6466480400 
div#yiv6466480400ygrp-mlmsg #yiv6466480400ygrp-msg p a 
span.yiv6466480400yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6466480400 
.yiv6466480400green {color:#628c2a;}#yiv6466480400 .yiv6466480400MsoNormal 
{margin:0 0 0 0;}#yiv6466480400 o {font-size:0;}#yiv6466480400 
#yiv6466480400photos div {float:left;width:72px;}#yiv6466480400 
#yiv6466480400photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv6466480400 
#yiv6466480400photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6466480400
  #yiv6466480400reco-category {font-size:77%;}#yiv6466480400 
#yiv6466480400reco-desc {font-size:77%;}#yiv6466480400 .yiv6466480400replbq 
{margin:4px;}#yiv6466480400 #yiv6466480400ygrp-actba

Bls: [belajar-excel] hapus kolom kosong

[odong nando odongna...@yahoo.com [belajar-excel]]

yoo liem,
- blok headernya
- Tekan tombol F5,klik spesial, lalu pilih blanks,OK
- klik kanan disalah satu cell terblock blank, pilih entri column, OK
semoga sesuai harapan
 br,

odong nando
 


 Pada Rabu, 17 Juni 2015 13:16, "Liem Suliem liemsul...@yahoo.co.id 
[belajar-excel]"  menulis:
   

     dh..salam be excel..saya ada tarikan data dari program yang datanya ada 
kolom kolom yang kosong.. biasanya saya hpus kolom2 kosong tersebut satu 
persatu..

adkah cara untuk hapus kolom kosong tersebut bersamaan??

untuk jelasnya file terlampir..

salamliem

  #yiv3551566697 #yiv3551566697 -- #yiv3551566697ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3551566697 
#yiv3551566697ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3551566697 
#yiv3551566697ygrp-mkp #yiv3551566697hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3551566697 #yiv3551566697ygrp-mkp #yiv3551566697ads 
{margin-bottom:10px;}#yiv3551566697 #yiv3551566697ygrp-mkp .yiv3551566697ad 
{padding:0 0;}#yiv3551566697 #yiv3551566697ygrp-mkp .yiv3551566697ad p 
{margin:0;}#yiv3551566697 #yiv3551566697ygrp-mkp .yiv3551566697ad a 
{color:#ff;text-decoration:none;}#yiv3551566697 #yiv3551566697ygrp-sponsor 
#yiv3551566697ygrp-lc {font-family:Arial;}#yiv3551566697 
#yiv3551566697ygrp-sponsor #yiv3551566697ygrp-lc #yiv3551566697hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3551566697 
#yiv3551566697ygrp-sponsor #yiv3551566697ygrp-lc .yiv3551566697ad 
{margin-bottom:10px;padding:0 0;}#yiv3551566697 #yiv3551566697actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3551566697 
#yiv3551566697activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3551566697
 #yiv3551566697activity span {font-weight:700;}#yiv3551566697 
#yiv3551566697activity span:first-child 
{text-transform:uppercase;}#yiv3551566697 #yiv3551566697activity span a 
{color:#5085b6;text-decoration:none;}#yiv3551566697 #yiv3551566697activity span 
span {color:#ff7900;}#yiv3551566697 #yiv3551566697activity span 
.yiv3551566697underline {text-decoration:underline;}#yiv3551566697 
.yiv3551566697attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3551566697 .yiv3551566697attach div a 
{text-decoration:none;}#yiv3551566697 .yiv3551566697attach img 
{border:none;padding-right:5px;}#yiv3551566697 .yiv3551566697attach label 
{display:block;margin-bottom:5px;}#yiv3551566697 .yiv3551566697attach label a 
{text-decoration:none;}#yiv3551566697 blockquote {margin:0 0 0 
4px;}#yiv3551566697 .yiv3551566697bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3551566697 
.yiv3551566697bold a {text-decoration:none;}#yiv3551566697 dd.yiv3551566697last 
p a {font-family:Verdana;font-weight:700;}#yiv3551566697 dd.yiv3551566697last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3551566697 
dd.yiv3551566697last p span.yiv3551566697yshortcuts 
{margin-right:0;}#yiv3551566697 div.yiv3551566697attach-table div div a 
{text-decoration:none;}#yiv3551566697 div.yiv3551566697attach-table 
{width:400px;}#yiv3551566697 div.yiv3551566697file-title a, #yiv3551566697 
div.yiv3551566697file-title a:active, #yiv3551566697 
div.yiv3551566697file-title a:hover, #yiv3551566697 div.yiv3551566697file-title 
a:visited {text-decoration:none;}#yiv3551566697 div.yiv3551566697photo-title a, 
#yiv3551566697 div.yiv3551566697photo-title a:active, #yiv3551566697 
div.yiv3551566697photo-title a:hover, #yiv3551566697 
div.yiv3551566697photo-title a:visited {text-decoration:none;}#yiv3551566697 
div#yiv3551566697ygrp-mlmsg #yiv3551566697ygrp-msg p a 
span.yiv3551566697yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3551566697 
.yiv3551566697green {color:#628c2a;}#yiv3551566697 .yiv3551566697MsoNormal 
{margin:0 0 0 0;}#yiv3551566697 o {font-size:0;}#yiv3551566697 
#yiv3551566697photos div {float:left;width:72px;}#yiv3551566697 
#yiv3551566697photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3551566697 
#yiv3551566697photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3551566697
 #yiv3551566697reco-category {font-size:77%;}#yiv3551566697 
#yiv3551566697reco-desc {font-size:77%;}#yiv3551566697 .yiv3551566697replbq 
{margin:4px;}#yiv3551566697 #yiv3551566697ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3551566697 #yiv3551566697ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3551566697 
#yiv3551566697ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3551566697 
#yiv3551566697ygrp-mlmsg select, #yiv3551566697 input, #yiv3551566697 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3551566697 
#yiv3551566697ygrp-mlmsg pre, #yiv3551566697 code {font:115% 
monospace;}#yiv3551566697 #yiv3551566697ygrp-mlmsg * 
{line-height:1.22em;}#

Re: [belajar-excel] Menampilkan data berstatus 0 di listbox

[Hendrik Karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Hai Rudi,
Sambil menunggu lampirannya...pada prinsipnya bisa.

Salam,
HK

Sent from Samsung Mobile

 Original message From: "Rudi Anto 
rudi.ex...@yahoo.com [belajar-excel]"  
Date:08/11/2015  5:52 PM  (GMT+07:00) To: 
belajar-excel@yahoogroups.com Subject: [belajar-excel] Menampilkan 
data berstatus 0 di listbox 
Selamat malam member Be-Excel, smoga smua slalu dalam lindungan-Nya. 
Aamiin.

Langsung ke pokok permasalahan, disini saya punya contoh data yang mana saya 
menginginkan data yang tampil di listbox hanya yang mempunyai status 0, 
mohon bantuan rekan2 untuk permasalahan yang saya hadapi.
Sebelumnya saya ucapkan terima kasih yang sebesar-besarnya


Salam,
Rudi

--- Mods ---
File lampiran melebihi 250KB dilepas dari email. Silakan posting ulang file 
lampiran yang diusahakan maksimal 250KB dengan cara me-reply email ini.
--

Bls: [belajar-excel] Mohon maaf file Excel baru di lampirkan ... [1 Attachment]

[odong nando odongna...@yahoo.com [belajar-excel]]

yoo nunuh,
case 2 = 
case 3 = 
=IF(L5="open","○",IF(L5="close","●",""))

case 4 = 
block all cell, klik kanan, format cells, protection, hilangkan checklist pada 
locked.setelahnya pilih cell yang akan  di protect, klik kanan, format cells, 
protection, checklist pada locked setelah itu masuk ribon review, protect 
sheet, masukan pasword, ulangi, OK.
br,

odong nando
 


 Pada Sabtu, 7 November 2015 12:17, "Nunuh Sumanta 
nunuhassamaw...@gmail.com [belajar-excel]"  
menulis:
   

     Salam sukses Para Suhu Be-Excel

Kasus yg laen . Kriteria "minor" dan "mayor" bisa dijumlahkan berdasarkan 
warna secara otomatis,  trs kasus selanjutnya tanda close (hitam) dan open 
(lingkaran) otomatis berubah juga sesuai simbol, dan kasus selanjutnya cell yg 
ada rumusnya pengen di password krn file ini sy kirim ke pihak ke tiga dan agar 
t idak dirubah krn otoritas tuk perubahan status ada pada pihak ke satu,

semoga para suhu be-excel dapat memberikan solusinya ...

terima kasih


nunu_assamawaat
  #yiv7793046470 #yiv7793046470 -- #yiv7793046470ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7793046470 
#yiv7793046470ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7793046470 
#yiv7793046470ygrp-mkp #yiv7793046470hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7793046470 #yiv7793046470ygrp-mkp #yiv7793046470ads 
{margin-bottom:10px;}#yiv7793046470 #yiv7793046470ygrp-mkp .yiv7793046470ad 
{padding:0 0;}#yiv7793046470 #yiv7793046470ygrp-mkp .yiv7793046470ad p 
{margin:0;}#yiv7793046470 #yiv7793046470ygrp-mkp .yiv7793046470ad a 
{color:#ff;text-decoration:none;}#yiv7793046470 #yiv7793046470ygrp-sponsor 
#yiv7793046470ygrp-lc {font-family:Arial;}#yiv7793046470 
#yiv7793046470ygrp-sponsor #yiv7793046470ygrp-lc #yiv7793046470hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7793046470 
#yiv7793046470ygrp-sponsor #yiv7793046470ygrp-lc .yiv7793046470ad 
{margin-bottom:10px;padding:0 0;}#yiv7793046470 #yiv7793046470actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7793046470 
#yiv7793046470activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7793046470
 #yiv7793046470activity span {font-weight:700;}#yiv7793046470 
#yiv7793046470activity span:first-child 
{text-transform:uppercase;}#yiv7793046470 #yiv7793046470activity span a 
{color:#5085b6;text-decoration:none;}#yiv7793046470 #yiv7793046470activity span 
span {color:#ff7900;}#yiv7793046470 #yiv7793046470activity span 
.yiv7793046470underline {text-decoration:underline;}#yiv7793046470 
.yiv7793046470attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7793046470 .yiv7793046470attach div a 
{text-decoration:none;}#yiv7793046470 .yiv7793046470attach img 
{border:none;padding-right:5px;}#yiv7793046470 .yiv7793046470attach label 
{display:block;margin-bottom:5px;}#yiv7793046470 .yiv7793046470attach label a 
{text-decoration:none;}#yiv7793046470 blockquote {margin:0 0 0 
4px;}#yiv7793046470 .yiv7793046470bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7793046470 
.yiv7793046470bold a {text-decoration:none;}#yiv7793046470 dd.yiv7793046470last 
p a {font-family:Verdana;font-weight:700;}#yiv7793046470 dd.yiv7793046470last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7793046470 
dd.yiv7793046470last p span.yiv7793046470yshortcuts 
{margin-right:0;}#yiv7793046470 div.yiv7793046470attach-table div div a 
{text-decoration:none;}#yiv7793046470 div.yiv7793046470attach-table 
{width:400px;}#yiv7793046470 div.yiv7793046470file-title a, #yiv7793046470 
div.yiv7793046470file-title a:active, #yiv7793046470 
div.yiv7793046470file-title a:hover, #yiv7793046470 div.yiv7793046470file-title 
a:visited {text-decoration:none;}#yiv7793046470 div.yiv7793046470photo-title a, 
#yiv7793046470 div.yiv7793046470photo-title a:active, #yiv7793046470 
div.yiv7793046470photo-title a:hover, #yiv7793046470 
div.yiv7793046470photo-title a:visited {text-decoration:none;}#yiv7793046470 
div#yiv7793046470ygrp-mlmsg #yiv7793046470ygrp-msg p a 
span.yiv7793046470yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7793046470 
.yiv7793046470green {color:#628c2a;}#yiv7793046470 .yiv7793046470MsoNormal 
{margin:0 0 0 0;}#yiv7793046470 o {font-size:0;}#yiv7793046470 
#yiv7793046470photos div {float:left;width:72px;}#yiv7793046470 
#yiv7793046470photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv7793046470 
#yiv7793046470photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7793046470
 #yiv7793046470reco-category {font-size:77%;}#yiv7793046470 
#yiv7793046470reco-desc {font-size:77%;}#yiv7793046470 .yiv7793046470replbq 
{margin:4px;}#yiv7793046470 #yiv7793046470ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv7793046470 #yiv7793046470y

[belajar-excel] Menampilkan data berstatus 0 di listbox

[Rudi Anto rudi.ex...@yahoo.com [belajar-excel]]

Selamat malam member Be-Excel, smoga smua slalu dalam lindungan-Nya. Aamiin.
 

 Langsung ke pokok permasalahan, disini saya punya contoh data yang mana saya 
menginginkan data yang tampil di listbox hanya yang mempunyai status 0, 

 mohon bantuan rekan2 untuk permasalahan yang saya hadapi.
 Sebelumnya saya ucapkan terima kasih yang sebesar-besarnya
 

 

 Salam,
 Rudi

 

 --- Mods ---
 File lampiran melebihi 250KB dilepas dari email. Silakan posting ulang file 
lampiran yang diusahakan maksimal 250KB dengan cara me-reply email ini.
 --

Bls: [belajar-excel] Extract data lapangan ke dalam form report [1 Attachment]

[odong nando odongna...@yahoo.com [belajar-excel]]

yoo T,
file terlampir,
btw, untuk tanggalnya blm bisa langsung, karena 1 area bisa terdapat 2 tanggal, 
untuk sementara pilih tanggal sendiri ya...
 br,

odong nando
 


 Pada Sabtu, 7 November 2015 9:59, "Teuku Machfudz Gani aku.ma...@yahoo.com 
[belajar-excel]"  menulis:
   

  Assalamualaikum wr wb, 
Rekan rekan,
Saya mau buat report berdasarkan data lapangan. Gimana caranya extract data 
lapangan ke form Report. 

Wassalam.
Terimakasih, 
T‎  #yiv5329457295 #yiv5329457295 -- #yiv5329457295ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5329457295 
#yiv5329457295ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5329457295 
#yiv5329457295ygrp-mkp #yiv5329457295hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5329457295 #yiv5329457295ygrp-mkp #yiv5329457295ads 
{margin-bottom:10px;}#yiv5329457295 #yiv5329457295ygrp-mkp .yiv5329457295ad 
{padding:0 0;}#yiv5329457295 #yiv5329457295ygrp-mkp .yiv5329457295ad p 
{margin:0;}#yiv5329457295 #yiv5329457295ygrp-mkp .yiv5329457295ad a 
{color:#ff;text-decoration:none;}#yiv5329457295 #yiv5329457295ygrp-sponsor 
#yiv5329457295ygrp-lc {font-family:Arial;}#yiv5329457295 
#yiv5329457295ygrp-sponsor #yiv5329457295ygrp-lc #yiv5329457295hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5329457295 
#yiv5329457295ygrp-sponsor #yiv5329457295ygrp-lc .yiv5329457295ad 
{margin-bottom:10px;padding:0 0;}#yiv5329457295 #yiv5329457295actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5329457295 
#yiv5329457295activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5329457295
 #yiv5329457295activity span {font-weight:700;}#yiv5329457295 
#yiv5329457295activity span:first-child 
{text-transform:uppercase;}#yiv5329457295 #yiv5329457295activity span a 
{color:#5085b6;text-decoration:none;}#yiv5329457295 #yiv5329457295activity span 
span {color:#ff7900;}#yiv5329457295 #yiv5329457295activity span 
.yiv5329457295underline {text-decoration:underline;}#yiv5329457295 
.yiv5329457295attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv5329457295 .yiv5329457295attach div a 
{text-decoration:none;}#yiv5329457295 .yiv5329457295attach img 
{border:none;padding-right:5px;}#yiv5329457295 .yiv5329457295attach label 
{display:block;margin-bottom:5px;}#yiv5329457295 .yiv5329457295attach label a 
{text-decoration:none;}#yiv5329457295 blockquote {margin:0 0 0 
4px;}#yiv5329457295 .yiv5329457295bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5329457295 
.yiv5329457295bold a {text-decoration:none;}#yiv5329457295 dd.yiv5329457295last 
p a {font-family:Verdana;font-weight:700;}#yiv5329457295 dd.yiv5329457295last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5329457295 
dd.yiv5329457295last p span.yiv5329457295yshortcuts 
{margin-right:0;}#yiv5329457295 div.yiv5329457295attach-table div div a 
{text-decoration:none;}#yiv5329457295 div.yiv5329457295attach-table 
{width:400px;}#yiv5329457295 div.yiv5329457295file-title a, #yiv5329457295 
div.yiv5329457295file-title a:active, #yiv5329457295 
div.yiv5329457295file-title a:hover, #yiv5329457295 div.yiv5329457295file-title 
a:visited {text-decoration:none;}#yiv5329457295 div.yiv5329457295photo-title a, 
#yiv5329457295 div.yiv5329457295photo-title a:active, #yiv5329457295 
div.yiv5329457295photo-title a:hover, #yiv5329457295 
div.yiv5329457295photo-title a:visited {text-decoration:none;}#yiv5329457295 
div#yiv5329457295ygrp-mlmsg #yiv5329457295ygrp-msg p a 
span.yiv5329457295yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5329457295 
.yiv5329457295green {color:#628c2a;}#yiv5329457295 .yiv5329457295MsoNormal 
{margin:0 0 0 0;}#yiv5329457295 o {font-size:0;}#yiv5329457295 
#yiv5329457295photos div {float:left;width:72px;}#yiv5329457295 
#yiv5329457295photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv5329457295 
#yiv5329457295photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5329457295
 #yiv5329457295reco-category {font-size:77%;}#yiv5329457295 
#yiv5329457295reco-desc {font-size:77%;}#yiv5329457295 .yiv5329457295replbq 
{margin:4px;}#yiv5329457295 #yiv5329457295ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv5329457295 #yiv5329457295ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5329457295 
#yiv5329457295ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5329457295 
#yiv5329457295ygrp-mlmsg select, #yiv5329457295 input, #yiv5329457295 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5329457295 
#yiv5329457295ygrp-mlmsg pre, #yiv5329457295 code {font:115% 
monospace;}#yiv5329457295 #yiv5329457295ygrp-mlmsg * 
{line-height:1.22em;}#yiv5329457295 #yiv5329457295ygrp-mlmsg #yiv5329457295logo 
{padding-bottom:10px;}#yiv5329457295 #yiv53294572