Keren banget mas Toby, tapi kalau untuk di print jadi sulit ya, kalau
tampilnya seperti itu.
Mohon bantuannya lagi mas toby, kalau untuk tampil di kolom keterangan saja
gimana ya?
2016-02-05 17:25 GMT+07:00 Toby kenzo tobyke...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:
>
>
> Dear Dody,
>
> Berikut filenya yang menggunakan VBA.
> Untuk mengetahi historical tanggal penjualan bisa langsung di klik di
> kolom E (Nama Barang yang warna biru).
> Jangan lupa aktifkan Enabled Macronya..
>
> TerimaKasih.
>
> Pada Jum, 5/2/16, Dody Irawan dodyirawa...@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com> menulis:
>
> Judul: Re: [belajar-excel] [belajar excel] mohon bantuan untuk membuat
> stok sederhana [1 Attachment]
> Kepada: belajar-excel@yahoogroups.com
> Tanggal: Jumat, 5 Februari, 2016, 10:24 AM
>
>
>
>
>
>
>
>
>
>
>
>
> Mas Toby,
> kalau do sheet jual, satu jenis
> barang terjual di tanggal yang sama dengan kuantitas yang
> berbeda, tanggal yang masuk di kolom keterangan cuma 1
> tanggal ya, bagaimana caranaya supaya masuk kedua-dua
> tanggal nya?
>
> terimakasih.
>
> Pada 5 Februari 2016 07.14,
> Dody Irawan <dodyirawa...@gmail.com>
> menulis:
> @Nando dan @Tobi, terimakasih
> banyak..... saya coba pelajari dulu ya, kalo mentok, ya
> nanya lagi..... hehe... maklum pemula...
> Pada 4 Februari 2016 22.21,
> Toby kenzo tobyke...@yahoo.co.id
> [belajar-excel] <belajar-excel@yahoogroups.com>
> menulis:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hai Dody,
> Coba file berikut..
> TerimaKasih
> Sent
> from Yahoo Mail on Android
>
>
>
>
>
>
>
>
> From:
>
> Dody Irawan dodyirawa...@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com>;
>
>
>
> To:
>
> <belajar-excel@yahoogroups.com>;
>
>
>
>
>
> Subject:
>
> [belajar-excel] [belajar excel]
> mohon bantuan untuk membuat stok sederhana [1 Attachment]
>
>
>
> Sent:
>
> Thu, Feb 4, 2016 7:49:27 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Mohon bantuannya temen-temen
> master.
>
> gimana caranya buat stok yang
> otomatis ter update.
>
> file
> terlampir.
>
> maaf pemula banget.....
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> #yiv3838187067 #yiv3838187067 --
> #yiv3838187067ygrp-mkp {
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
> 0;padding:0 10px;}
>
> #yiv3838187067 #yiv3838187067ygrp-mkp hr {
> border:1px solid #d8d8d8;}
>
> #yiv3838187067 #yiv3838187067ygrp-mkp #yiv3838187067hd {
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}
>
> #yiv3838187067 #yiv3838187067ygrp-mkp #yiv3838187067ads {
> margin-bottom:10px;}
>
> #yiv3838187067 #yiv3838187067ygrp-mkp .yiv3838187067ad {
> padding:0 0;}
>
> #yiv3838187067 #yiv3838187067ygrp-mkp .yiv3838187067ad p {
> margin:0;}
>
> #yiv3838187067 #yiv3838187067ygrp-mkp .yiv3838187067ad a {
> color:#0000ff;text-decoration:none;}
> #yiv3838187067 #yiv3838187067ygrp-sponsor
> #yiv3838187067ygrp-lc {
> font-family:Arial;}
>
> #yiv3838187067 #yiv3838187067ygrp-sponsor
> #yiv3838187067ygrp-lc #yiv3838187067hd {
> margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
> #yiv3838187067 #yiv3838187067ygrp-sponsor
> #yiv3838187067ygrp-lc .yiv3838187067ad {
> margin-bottom:10px;padding:0 0;}
>
> #yiv3838187067 #yiv3838187067actions {
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
> #yiv3838187067 #yiv3838187067activity {
>
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
> #yiv3838187067 #yiv3838187067activity span {
> font-weight:700;}
>
> #yiv3838187067 #yiv3838187067activity span:first-child {
> text-transform:uppercase;}
>
> #yiv3838187067 #yiv3838187067activity span a {
> color:#5085b6;text-decoration:none;}
>
> #yiv3838187067 #yiv3838187067activity span span {
> color:#ff7900;}
>
> #yiv3838187067 #yiv3838187067activity span
> .yiv3838187067underline {
> text-decoration:underline;}
>
> #yiv3838187067 .yiv3838187067attach {
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}
>
> #yiv3838187067 .yiv3838187067attach div a {
> text-decoration:none;}
>
> #yiv3838187067 .yiv3838187067attach img {
> border:none;padding-right:5px;}
>
> #yiv3838187067 .yiv3838187067attach label {
> display:block;margin-bottom:5px;}
>
> #yiv3838187067 .yiv3838187067attach label a {
> text-decoration:none;}
>
> #yiv3838187067 blockquote {
> margin:0 0 0 4px;}
>
> #yiv3838187067 .yiv3838187067bold {
> font-family:Arial;font-size:13px;font-weight:700;}
>
> #yiv3838187067 .yiv3838187067bold a {
> text-decoration:none;}
>
> #yiv3838187067 dd.yiv3838187067last p a {
> font-family:Verdana;font-weight:700;}
>
> #yiv3838187067 dd.yiv3838187067last p span {
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
> #yiv3838187067 dd.yiv3838187067last p
> span.yiv3838187067yshortcuts {
> margin-right:0;}
>
> #yiv3838187067 div.yiv3838187067attach-table div div a {
> text-decoration:none;}
>
> #yiv3838187067 div.yiv3838187067attach-table {
> width:400px;}
>
> #yiv3838187067 div.yiv3838187067file-title a, #yiv3838187067
> div.yiv3838187067file-title a:active, #yiv3838187067
> div.yiv3838187067file-title a:hover, #yiv3838187067
> div.yiv3838187067file-title a:visited {
> text-decoration:none;}
>
> #yiv3838187067 div.yiv3838187067photo-title a,
> #yiv3838187067 div.yiv3838187067photo-title a:active,
> #yiv3838187067 div.yiv3838187067photo-title a:hover,
> #yiv3838187067 div.yiv3838187067photo-title a:visited {
> text-decoration:none;}
>
> #yiv3838187067 div#yiv3838187067ygrp-mlmsg
> #yiv3838187067ygrp-msg p a span.yiv3838187067yshortcuts {
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
> #yiv3838187067 .yiv3838187067green {
> color:#628c2a;}
>
> #yiv3838187067 .yiv3838187067MsoNormal {
> margin:0 0 0 0;}
>
> #yiv3838187067 o {
> font-size:0;}
>
> #yiv3838187067 #yiv3838187067photos div {
> float:left;width:72px;}
>
> #yiv3838187067 #yiv3838187067photos div div {
> border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}
>
> #yiv3838187067 #yiv3838187067photos div label {
>
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
> #yiv3838187067 #yiv3838187067reco-category {
> font-size:77%;}
>
> #yiv3838187067 #yiv3838187067reco-desc {
> font-size:77%;}
>
> #yiv3838187067 .yiv3838187067replbq {
> margin:4px;}
>
> #yiv3838187067 #yiv3838187067ygrp-actbar div a:first-child {
> margin-right:2px;padding-right:5px;}
>
> #yiv3838187067 #yiv3838187067ygrp-mlmsg {
> font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}
>
> #yiv3838187067 #yiv3838187067ygrp-mlmsg table {
> font-size:inherit;font:100%;}
>
> #yiv3838187067 #yiv3838187067ygrp-mlmsg select,
> #yiv3838187067 input, #yiv3838187067 textarea {
> font:99% Arial, Helvetica, clean, sans-serif;}
>
> #yiv3838187067 #yiv3838187067ygrp-mlmsg pre, #yiv3838187067
> code {
> font:115% monospace;}
>
> #yiv3838187067 #yiv3838187067ygrp-mlmsg * {
> line-height:1.22em;}
>
> #yiv3838187067 #yiv3838187067ygrp-mlmsg #yiv3838187067logo {
> padding-bottom:10px;}
>
>
> #yiv3838187067 #yiv3838187067ygrp-msg p a {
> font-family:Verdana;}
>
> #yiv3838187067 #yiv3838187067ygrp-msg
> p#yiv3838187067attach-count span {
> color:#1E66AE;font-weight:700;}
>
> #yiv3838187067 #yiv3838187067ygrp-reco
> #yiv3838187067reco-head {
> color:#ff7900;font-weight:700;}
>
> #yiv3838187067 #yiv3838187067ygrp-reco {
> margin-bottom:20px;padding:0px;}
>
> #yiv3838187067 #yiv3838187067ygrp-sponsor #yiv3838187067ov
> li a {
> font-size:130%;text-decoration:none;}
>
> #yiv3838187067 #yiv3838187067ygrp-sponsor #yiv3838187067ov
> li {
> font-size:77%;list-style-type:square;padding:6px 0;}
>
> #yiv3838187067 #yiv3838187067ygrp-sponsor #yiv3838187067ov
> ul {
> margin:0;padding:0 0 0 8px;}
>
> #yiv3838187067 #yiv3838187067ygrp-text {
> font-family:Georgia;}
>
> #yiv3838187067 #yiv3838187067ygrp-text p {
> margin:0 0 1em 0;}
>
> #yiv3838187067 #yiv3838187067ygrp-text tt {
> font-size:120%;}
>
> #yiv3838187067 #yiv3838187067ygrp-vital ul li:last-child {
> border-right:none !important;
> }
> #yiv3838187067
>
>
