Minggu, 29 Mei 2016

[belajar-excel] Digest Number 3866

2 Messages

Digest #3866

Messages

Sat May 28, 2016 3:56 pm (PDT) . Posted by:

"Ayub Barin"

Yth, mas toby, mas hendrik, mas nang
dan Masters lainnya,

Ini saya coba kirimkan filenya, walau jujur banyak malunya saya sebab dalam
file ini banyak meng akali dan tidak bnyk mengikuti kaidah excel
sebenarnya, mohon maaf krn saya minim ilmu dan pengetahuan ttng excel ini,
Demikian masters, saya haturkan banyak banyak terima kasih atas perhatian
dan semua jawab yg membantu saya.

Wassalam,

Sun May 29, 2016 12:23 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Ayub,
Untuk Data range yang mobile(dinamis) bisa memanfaatkan NameManager,artinya data tidak terbatas sesuai dengan data yang di ambil untuk membuat NameMeneger, waktu itu khan sudah saya kasi contoh untuk membuat data range yang dinamis  pada NameManager.
Ok, berikut saya kasi contoh penggunaan AutoFilter pada case yang anda hadapi, semoga bisa membantu.

TerimaKasih.

Pada Sabtu, 28 Mei 2016 14:17, "Ayub Barin ayubbarin@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth, mas toby, mas hendrik, mas nang
dan Masters lainnya,Ini saya coba kirimkan filenya, walau jujur banyak malunya saya sebab dalam file ini banyak meng akali dan tidak bnyk mengikuti kaidah excel sebenarnya, mohon maaf krn saya minim ilmu dan pengetahuan ttng excel ini,
Demikian masters, saya haturkan banyak banyak terima kasih atas perhatian dan semua jawab yg membantu saya.Wassalam, #yiv8000082493 #yiv8000082493 -- #yiv8000082493ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8000082493 #yiv8000082493ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8000082493 #yiv8000082493ygrp-mkp #yiv8000082493hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8000082493 #yiv8000082493ygrp-mkp #yiv8000082493ads {margin-bottom:10px;}#yiv8000082493 #yiv8000082493ygrp-mkp .yiv8000082493ad {padding:0 0;}#yiv8000082493 #yiv8000082493ygrp-mkp .yiv8000082493ad p {margin:0;}#yiv8000082493 #yiv8000082493ygrp-mkp .yiv8000082493ad a {color:#0000ff;text-decoration:none;}#yiv8000082493 #yiv8000082493ygrp-sponsor #yiv8000082493ygrp-lc {font-family:Arial;}#yiv8000082493 #yiv8000082493ygrp-sponsor #yiv8000082493ygrp-lc #yiv8000082493hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8000082493 #yiv8000082493ygrp-sponsor #yiv8000082493ygrp-lc .yiv8000082493ad {margin-bottom:10px;padding:0 0;}#yiv8000082493 #yiv8000082493actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8000082493 #yiv8000082493activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8000082493 #yiv8000082493activity span {font-weight:700;}#yiv8000082493 #yiv8000082493activity span:first-child {text-transform:uppercase;}#yiv8000082493 #yiv8000082493activity span a {color:#5085b6;text-decoration:none;}#yiv8000082493 #yiv8000082493activity span span {color:#ff7900;}#yiv8000082493 #yiv8000082493activity span .yiv8000082493underline {text-decoration:underline;}#yiv8000082493 .yiv8000082493attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8000082493 .yiv8000082493attach div a {text-decoration:none;}#yiv8000082493 .yiv8000082493attach img {border:none;padding-right:5px;}#yiv8000082493 .yiv8000082493attach label {display:block;margin-bottom:5px;}#yiv8000082493 .yiv8000082493attach label a {text-decoration:none;}#yiv8000082493 blockquote {margin:0 0 0 4px;}#yiv8000082493 .yiv8000082493bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8000082493 .yiv8000082493bold a {text-decoration:none;}#yiv8000082493 dd.yiv8000082493last p a {font-family:Verdana;font-weight:700;}#yiv8000082493 dd.yiv8000082493last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8000082493 dd.yiv8000082493last p span.yiv8000082493yshortcuts {margin-right:0;}#yiv8000082493 div.yiv8000082493attach-table div div a {text-decoration:none;}#yiv8000082493 div.yiv8000082493attach-table {width:400px;}#yiv8000082493 div.yiv8000082493file-title a, #yiv8000082493 div.yiv8000082493file-title a:active, #yiv8000082493 div.yiv8000082493file-title a:hover, #yiv8000082493 div.yiv8000082493file-title a:visited {text-decoration:none;}#yiv8000082493 div.yiv8000082493photo-title a, #yiv8000082493 div.yiv8000082493photo-title a:active, #yiv8000082493 div.yiv8000082493photo-title a:hover, #yiv8000082493 div.yiv8000082493photo-title a:visited {text-decoration:none;}#yiv8000082493 div#yiv8000082493ygrp-mlmsg #yiv8000082493ygrp-msg p a span.yiv8000082493yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8000082493 .yiv8000082493green {color:#628c2a;}#yiv8000082493 .yiv8000082493MsoNormal {margin:0 0 0 0;}#yiv8000082493 o {font-size:0;}#yiv8000082493 #yiv8000082493photos div {float:left;width:72px;}#yiv8000082493 #yiv8000082493photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8000082493 #yiv8000082493photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8000082493 #yiv8000082493reco-category {font-size:77%;}#yiv8000082493 #yiv8000082493reco-desc {font-size:77%;}#yiv8000082493 .yiv8000082493replbq {margin:4px;}#yiv8000082493 #yiv8000082493ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8000082493 #yiv8000082493ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8000082493 #yiv8000082493ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8000082493 #yiv8000082493ygrp-mlmsg select, #yiv8000082493 input, #yiv8000082493 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8000082493 #yiv8000082493ygrp-mlmsg pre, #yiv8000082493 code {font:115% monospace;}#yiv8000082493 #yiv8000082493ygrp-mlmsg * {line-height:1.22em;}#yiv8000082493 #yiv8000082493ygrp-mlmsg #yiv8000082493logo {padding-bottom:10px;}#yiv8000082493 #yiv8000082493ygrp-msg p a {font-family:Verdana;}#yiv8000082493 #yiv8000082493ygrp-msg p#yiv8000082493attach-count span {color:#1E66AE;font-weight:700;}#yiv8000082493 #yiv8000082493ygrp-reco #yiv8000082493reco-head {color:#ff7900;font-weight:700;}#yiv8000082493 #yiv8000082493ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8000082493 #yiv8000082493ygrp-sponsor #yiv8000082493ov li a {font-size:130%;text-decoration:none;}#yiv8000082493 #yiv8000082493ygrp-sponsor #yiv8000082493ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8000082493 #yiv8000082493ygrp-sponsor #yiv8000082493ov ul {margin:0;padding:0 0 0 8px;}#yiv8000082493 #yiv8000082493ygrp-text {font-family:Georgia;}#yiv8000082493 #yiv8000082493ygrp-text p {margin:0 0 1em 0;}#yiv8000082493 #yiv8000082493ygrp-text tt {font-size:120%;}#yiv8000082493 #yiv8000082493ygrp-vital ul li:last-child {border-right:none !important;}#yiv8000082493

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