Dear Excel Master,Terima kasih atas jawabannya, sangat membantu untuk saya
pelajari kembali.Untuk program VBAnya saya belum familiar, bisa nggak yah saya
diajarkan teori dasar VBA?..
Semoga Master tidak bosan dalam berbagi.
Terima Kasih,
Salam,Zulfikar
Palopo, Sul-sel
Pada Minggu, 8 Februari 2015 22:36, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
| Dear Zulfikar,Berikut saya kasi contoh penyelesaian dgn menggunakan VBA.Jika
anda sudah familiar dgn VBA,anda bisa memodifikasi programnya,karena yg saya
buat masih dasar.Semoga membantu.
TerimaKasih.Sent from Yahoo Mail on Android |
From: Zulfikar N [email protected] [belajar-excel]
<[email protected]>;
To: <[email protected]>;
Subject: [belajar-excel] FORMULA MENAMPILKAN ITEM MENURUT PERIODE [1
Attachment]
Sent: Mon, Feb 2, 2015 6:00:05 AM
| Dear Excel Master,Mohon Bantuannya untuk menampilkan Item sesuai periode
yang diinginkan menggunakan data validation, contoh kasus dapat dilihat pada
file terlampir.
Terima Kasih,
Salam,Zulfikar
Palopo, Sul-sel
|
#yiv7671305424 #yiv7671305424 -- #yiv7671305424ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7671305424
#yiv7671305424ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7671305424
#yiv7671305424ygrp-mkp #yiv7671305424hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7671305424 #yiv7671305424ygrp-mkp #yiv7671305424ads
{margin-bottom:10px;}#yiv7671305424 #yiv7671305424ygrp-mkp .yiv7671305424ad
{padding:0 0;}#yiv7671305424 #yiv7671305424ygrp-mkp .yiv7671305424ad p
{margin:0;}#yiv7671305424 #yiv7671305424ygrp-mkp .yiv7671305424ad a
{color:#0000ff;text-decoration:none;}#yiv7671305424 #yiv7671305424ygrp-sponsor
#yiv7671305424ygrp-lc {font-family:Arial;}#yiv7671305424
#yiv7671305424ygrp-sponsor #yiv7671305424ygrp-lc #yiv7671305424hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7671305424
#yiv7671305424ygrp-sponsor #yiv7671305424ygrp-lc .yiv7671305424ad
{margin-bottom:10px;padding:0 0;}#yiv7671305424 #yiv7671305424actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7671305424
#yiv7671305424activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7671305424
#yiv7671305424activity span {font-weight:700;}#yiv7671305424
#yiv7671305424activity span:first-child
{text-transform:uppercase;}#yiv7671305424 #yiv7671305424activity span a
{color:#5085b6;text-decoration:none;}#yiv7671305424 #yiv7671305424activity span
span {color:#ff7900;}#yiv7671305424 #yiv7671305424activity span
.yiv7671305424underline {text-decoration:underline;}#yiv7671305424
.yiv7671305424attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7671305424 .yiv7671305424attach div a
{text-decoration:none;}#yiv7671305424 .yiv7671305424attach img
{border:none;padding-right:5px;}#yiv7671305424 .yiv7671305424attach label
{display:block;margin-bottom:5px;}#yiv7671305424 .yiv7671305424attach label a
{text-decoration:none;}#yiv7671305424 blockquote {margin:0 0 0
4px;}#yiv7671305424 .yiv7671305424bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7671305424
.yiv7671305424bold a {text-decoration:none;}#yiv7671305424 dd.yiv7671305424last
p a {font-family:Verdana;font-weight:700;}#yiv7671305424 dd.yiv7671305424last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7671305424
dd.yiv7671305424last p span.yiv7671305424yshortcuts
{margin-right:0;}#yiv7671305424 div.yiv7671305424attach-table div div a
{text-decoration:none;}#yiv7671305424 div.yiv7671305424attach-table
{width:400px;}#yiv7671305424 div.yiv7671305424file-title a, #yiv7671305424
div.yiv7671305424file-title a:active, #yiv7671305424
div.yiv7671305424file-title a:hover, #yiv7671305424 div.yiv7671305424file-title
a:visited {text-decoration:none;}#yiv7671305424 div.yiv7671305424photo-title a,
#yiv7671305424 div.yiv7671305424photo-title a:active, #yiv7671305424
div.yiv7671305424photo-title a:hover, #yiv7671305424
div.yiv7671305424photo-title a:visited {text-decoration:none;}#yiv7671305424
div#yiv7671305424ygrp-mlmsg #yiv7671305424ygrp-msg p a
span.yiv7671305424yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7671305424
.yiv7671305424green {color:#628c2a;}#yiv7671305424 .yiv7671305424MsoNormal
{margin:0 0 0 0;}#yiv7671305424 o {font-size:0;}#yiv7671305424
#yiv7671305424photos div {float:left;width:72px;}#yiv7671305424
#yiv7671305424photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7671305424
#yiv7671305424photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7671305424
#yiv7671305424reco-category {font-size:77%;}#yiv7671305424
#yiv7671305424reco-desc {font-size:77%;}#yiv7671305424 .yiv7671305424replbq
{margin:4px;}#yiv7671305424 #yiv7671305424ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7671305424 #yiv7671305424ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7671305424
#yiv7671305424ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7671305424
#yiv7671305424ygrp-mlmsg select, #yiv7671305424 input, #yiv7671305424 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7671305424
#yiv7671305424ygrp-mlmsg pre, #yiv7671305424 code {font:115%
monospace;}#yiv7671305424 #yiv7671305424ygrp-mlmsg *
{line-height:1.22em;}#yiv7671305424 #yiv7671305424ygrp-mlmsg #yiv7671305424logo
{padding-bottom:10px;}#yiv7671305424 #yiv7671305424ygrp-msg p a
{font-family:Verdana;}#yiv7671305424 #yiv7671305424ygrp-msg
p#yiv7671305424attach-count span {color:#1E66AE;font-weight:700;}#yiv7671305424
#yiv7671305424ygrp-reco #yiv7671305424reco-head
{color:#ff7900;font-weight:700;}#yiv7671305424 #yiv7671305424ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7671305424 #yiv7671305424ygrp-sponsor
#yiv7671305424ov li a {font-size:130%;text-decoration:none;}#yiv7671305424
#yiv7671305424ygrp-sponsor #yiv7671305424ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7671305424
#yiv7671305424ygrp-sponsor #yiv7671305424ov ul {margin:0;padding:0 0 0
8px;}#yiv7671305424 #yiv7671305424ygrp-text
{font-family:Georgia;}#yiv7671305424 #yiv7671305424ygrp-text p {margin:0 0 1em
0;}#yiv7671305424 #yiv7671305424ygrp-text tt {font-size:120%;}#yiv7671305424
#yiv7671305424ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7671305424
