keren amat mas...
kayak mana buatnya...? itu formulanya dimana ya...? Pada 6 Februari 2016 17.05, Toby kenzo tobyke...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis: > > > Hai Dody, > > Berikut filenya. > tinggal click "Deskripsi Transaksi Penjualan" warna biru untuk merefresh > transaksi penjualan jd kl mau di print bisa terlihat semua. > > TerimaKasih. > > Sent from Yahoo Mail on Android > <http://overview.mail.yahoo.com/mobile/?.src=Android> > > ------------------------------ > * From: * Dody Irawan dodyirawa...@gmail.com [belajar-excel] < > belajar-excel@yahoogroups.com>; > * To: * <belajar-excel@yahoogroups.com>; > * Subject: * Re: [belajar-excel] [belajar excel] mohon bantuan untuk > membuat stok sederhana > * Sent: * Sat, Feb 6, 2016 1:10:11 AM > > > > 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 >> > > >
