Jumat, 05 Februari 2016

[belajar-excel] Digest Number 3746

12 Messages

Digest #3746

Messages

Thu Feb 4, 2016 3:07 am (PST) . Posted by:

"odong nando"

itu bisa kok,
insert table pada masing2 sheet yang ada, untuk menghindari salah input nama barang bisa di buatkan list validation yang di ambil dari sheet stok, untuk lebih jelasnya bisa liat lampiran berikut.
 br,

odong nando

Dari: "Dody Irawan dodyirawan84@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 4 Februari 2016 14:49
Judul: [belajar-excel] [belajar excel] mohon bantuan untuk membuat stok sederhana [1 Attachment]

  Mohon bantuannya temen-temen master.

gimana caranya buat stok yang otomatis ter update.

file terlampir.

maaf pemula banget..... #yiv4867285830 #yiv4867285830 -- #yiv4867285830ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4867285830 #yiv4867285830ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4867285830 #yiv4867285830ygrp-mkp #yiv4867285830hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4867285830 #yiv4867285830ygrp-mkp #yiv4867285830ads {margin-bottom:10px;}#yiv4867285830 #yiv4867285830ygrp-mkp .yiv4867285830ad {padding:0 0;}#yiv4867285830 #yiv4867285830ygrp-mkp .yiv4867285830ad p {margin:0;}#yiv4867285830 #yiv4867285830ygrp-mkp .yiv4867285830ad a {color:#0000ff;text-decoration:none;}#yiv4867285830 #yiv4867285830ygrp-sponsor #yiv4867285830ygrp-lc {font-family:Arial;}#yiv4867285830 #yiv4867285830ygrp-sponsor #yiv4867285830ygrp-lc #yiv4867285830hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4867285830 #yiv4867285830ygrp-sponsor #yiv4867285830ygrp-lc .yiv4867285830ad {margin-bottom:10px;padding:0 0;}#yiv4867285830 #yiv4867285830actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4867285830 #yiv4867285830activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4867285830 #yiv4867285830activity span {font-weight:700;}#yiv4867285830 #yiv4867285830activity span:first-child {text-transform:uppercase;}#yiv4867285830 #yiv4867285830activity span a {color:#5085b6;text-decoration:none;}#yiv4867285830 #yiv4867285830activity span span {color:#ff7900;}#yiv4867285830 #yiv4867285830activity span .yiv4867285830underline {text-decoration:underline;}#yiv4867285830 .yiv4867285830attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4867285830 .yiv4867285830attach div a {text-decoration:none;}#yiv4867285830 .yiv4867285830attach img {border:none;padding-right:5px;}#yiv4867285830 .yiv4867285830attach label {display:block;margin-bottom:5px;}#yiv4867285830 .yiv4867285830attach label a {text-decoration:none;}#yiv4867285830 blockquote {margin:0 0 0 4px;}#yiv4867285830 .yiv4867285830bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4867285830 .yiv4867285830bold a {text-decoration:none;}#yiv4867285830 dd.yiv4867285830last p a {font-family:Verdana;font-weight:700;}#yiv4867285830 dd.yiv4867285830last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4867285830 dd.yiv4867285830last p span.yiv4867285830yshortcuts {margin-right:0;}#yiv4867285830 div.yiv4867285830attach-table div div a {text-decoration:none;}#yiv4867285830 div.yiv4867285830attach-table {width:400px;}#yiv4867285830 div.yiv4867285830file-title a, #yiv4867285830 div.yiv4867285830file-title a:active, #yiv4867285830 div.yiv4867285830file-title a:hover, #yiv4867285830 div.yiv4867285830file-title a:visited {text-decoration:none;}#yiv4867285830 div.yiv4867285830photo-title a, #yiv4867285830 div.yiv4867285830photo-title a:active, #yiv4867285830 div.yiv4867285830photo-title a:hover, #yiv4867285830 div.yiv4867285830photo-title a:visited {text-decoration:none;}#yiv4867285830 div#yiv4867285830ygrp-mlmsg #yiv4867285830ygrp-msg p a span.yiv4867285830yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4867285830 .yiv4867285830green {color:#628c2a;}#yiv4867285830 .yiv4867285830MsoNormal {margin:0 0 0 0;}#yiv4867285830 o {font-size:0;}#yiv4867285830 #yiv4867285830photos div {float:left;width:72px;}#yiv4867285830 #yiv4867285830photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4867285830 #yiv4867285830photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4867285830 #yiv4867285830reco-category {font-size:77%;}#yiv4867285830 #yiv4867285830reco-desc {font-size:77%;}#yiv4867285830 .yiv4867285830replbq {margin:4px;}#yiv4867285830 #yiv4867285830ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4867285830 #yiv4867285830ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4867285830 #yiv4867285830ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4867285830 #yiv4867285830ygrp-mlmsg select, #yiv4867285830 input, #yiv4867285830 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4867285830 #yiv4867285830ygrp-mlmsg pre, #yiv4867285830 code {font:115% monospace;}#yiv4867285830 #yiv4867285830ygrp-mlmsg * {line-height:1.22em;}#yiv4867285830 #yiv4867285830ygrp-mlmsg #yiv4867285830logo {padding-bottom:10px;}#yiv4867285830 #yiv4867285830ygrp-msg p a {font-family:Verdana;}#yiv4867285830 #yiv4867285830ygrp-msg p#yiv4867285830attach-count span {color:#1E66AE;font-weight:700;}#yiv4867285830 #yiv4867285830ygrp-reco #yiv4867285830reco-head {color:#ff7900;font-weight:700;}#yiv4867285830 #yiv4867285830ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4867285830 #yiv4867285830ygrp-sponsor #yiv4867285830ov li a {font-size:130%;text-decoration:none;}#yiv4867285830 #yiv4867285830ygrp-sponsor #yiv4867285830ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4867285830 #yiv4867285830ygrp-sponsor #yiv4867285830ov ul {margin:0;padding:0 0 0 8px;}#yiv4867285830 #yiv4867285830ygrp-text {font-family:Georgia;}#yiv4867285830 #yiv4867285830ygrp-text p {margin:0 0 1em 0;}#yiv4867285830 #yiv4867285830ygrp-text tt {font-size:120%;}#yiv4867285830 #yiv4867285830ygrp-vital ul li:last-child {border-right:none !important;}#yiv4867285830

Thu Feb 4, 2016 4:04 am (PST) . Posted by:

"Tio Adi Bayu Adjie"

Salam Excel Expert,
Saya ada code untuk import query Microsoft access ke Excel tapi tidak jalan. Mohon pencerahannya, bagaimana solusinya ?
Error yang muncul di .Parameters("[Harga <= Dari?]") = Range("B1").Value (yg saya kasih tanda warna hijau). Di computer saya 2003 tidak berhasil, tapi kalau di Access 2007 berhasil. Mohon pencerahannya

Berikut yang saya dapat :

Sub CopyRecordDariAccess2()
'Sebelum menjalankan procedure dibawah ini, pastikan library ini sudah ditambahkan
'di Tools -> References:
'- Microsoft ActiveX Data Objects Library
'Versi sesuai dengan Office yg diinstall di PC nya

'Tahap 1: Deklarasi nama object dan variable yg digunakan
Dim MyConnect As String
Dim MyRecordset As ADODB.Recordset
Dim MyQueryDef As DAO.QueryDef
Dim MyDatabase As ADODB.Recordset

'Tahap 2: Deklarasi jenis koneksi database dan lokasinya
MyConnect = "Provider=Microsoft.JET.OLEDB.4.0;" & _
"Data Source=" & ActiveWorkbook.Path & "\KolaborasiAccessExcel.mdb"

'Tahap 3: Tentukan nama table/query
Set MyDatabase = New ADODB.Recordset
MyRecordset.Open "[TestParameterQuery]", MyConnect, adOpenStatic, adLockReadOnly

Set MyQueryDef = MyDatabase.QueryDefs("TestParameterQuery")

'Tahap 3: Definiskan Parameter yg digunakan
With MyQueryDef
.Parameters("[Harga <= Dari?]") = Range("B1").Value
End With

'Langkah 4: Membuka query
Set MyRecordset = MyQueryDef.OpenRecordset

'Tahap 4: Copy seluruh record ke Excel
Sheets("Sheet1").Select
ActiveSheet.Range("A2").CopyFromRecordset MyRecordset

'Tahap 5: Tambahkan judul kolom di Excel
For i = 1 To MyRecordset.Fields.Count
ActiveSheet.Cells(1, i).Value = MyRecordset.Fields(i - 1).Name
Next i

'Tahap 6: Bersihkan memory di VBA
MyRecordset.Close
Set MyRecordset = Nothing




Terima kasih.
Tio_,_._,___

Thu Feb 4, 2016 6:01 am (PST) . Posted by:

"Widodo Budi"

Assalamu'alaikum,

Rasyid,
Kalau begitu coba kembangkan alternatif program excel tanpa makro.

Wassalamu'alaikum
Wid

Sent from my iPhone

> On Feb 4, 2016, at 14:15, "'Contract Mining Assistant, Asam-Asam' apassistant@arutmin.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
> Dear Mr Kid & all member,
>
> Sudah saya coba, akan tetapi hasilnya masih nihil, bahkan saya sudah uninstall tetapi hasilnya masih sama.
>
> Ternyata file apapun yang menggunakan VBA yang di buat di PC Server (file_A.xlsb) walaupun hanya sekedar menampilkan MessageBox, begitu file (file_A.xlsb) di Copas
>
> di PC Client macronya tidak jalan. Setting security sudah betul saja. Begitu saya alihkan ke mode design untuk membuka jendela VBA, begitu saya run codingnya melalui VBA akan tampil message error yg berbunyi
>
> "compile error: Object library invalid or contains references to object definitions that Could not be found".
>
>
>
> Add note:
>
> - setiap kali saya bikin command button baru di PC server selalu defaulnya dari commandbutton21
>
> - saat file (file_A.xlsb) yg ada di PC client dibuka dan macronya tidak bisa running, akan tetapi begitu saya menambahkan command button di sheet yg baru tetapi masih di PC client macro berjalan normal, biru saya pindah ke sheet sebelumnya macro tetap tidak bisa jalan.
>
>
>
> Mohon kiranya bantuan, kalau saja dari mr Kid dan semua member pernah mengalami case seperti ini.
>
>
>
> Terima kasih sebelumnya.
>
>
>
> Salam Hormat,
>
> Rasyid
>
>
>
>
>
> From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
> Sent: Wednesday, January 20, 2016 6:01 PM
> To: BeExcel
> Subject: Re: [belajar-excel] membuka file bermakro di PC lain tidak bisa.
>
>
>
>
>
> Hai Rasyid,
>
> Coba tutup semua Excel, lalu unduh yang ada disini : (fix dari MS -- lihat agak ke bawah, ada tombol download --)
> https://support.microsoft.com/en-us/kb/3025036
>
> Unduh yang sesuai (khusus untuk user yang sedang login atau punya akses sebagai admin agar bisa untuk seluruh user) dan jalankan
>
>
>
> Wassalam,
>
> Kid
>
>
>
>
>
> On Wed, Jan 20, 2016 at 1:45 PM, 'Contract Mining Assistant, Asam-Asam' apassistant@arutmin.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Dear Toby Kenzo and all members,
>
> Jawaban:
>
> 1- Ya masih dengan extention xlsm
>
> 2- Ya dengan nama file yg sama
>
> 3- Ya menjadi commandbutton21 dll.
>
>
>
> Salam, Rasyid
>
>
>
> From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
> Sent: Wednesday, January 20, 2016 2:22 PM
> To: belajar-excel@yahoogroups.com
> Subject: Bls: [belajar-excel] membuka file bermakro di PC lain tidak bisa.
>
>

>
>
>
> Dear Rasyid,
>
> Ada beberapa pertanyaan dari saya tentang masalah yg anda alami saat ini.
>
> 1. Apakah pada saat copy Paste ke client filenya tetap berextentiom XLSM..?
> 2. Apakah pada saat copy Paste ke client dengan nama file yang sama atau tidak..?
> 3. Apakah perubahan name dari commondbutton berubah menjadi commondbutton21 atau yg lain..?
>
> TerimaKasih.
>
> --------------------------------------------
> Pada Rab, 20/1/16, 'Contract Mining Assistant, Asam-Asam' apassistant@arutmin.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
>
> Judul: [belajar-excel] membuka file bermakro di PC lain tidak bisa.
> Kepada: belajar-excel@yahoogroups.com
> Tanggal: Rabu, 20 Januari, 2016, 10:27 AM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Dear Milis Belajar
> Excel.
> Mohon bantuannya.
> Ilustrasi kasus:
> Saya mempunya 2 buah
> file excel,
> 1.file_server.xlsb
> 2.file_client.xlsm.
>
> Rencana nya
> file_client.xlsm akan di running di tiap2 PC client, yang
> mana isi dari file tsb ada makro, formula dan ada bahasa
> basic nya.
> Akan tetapi ketika di
> paste di PC client dan dijalankan, ketika kita mengklik
> salah satu button yang disisipkan bahasa basic, sama sekali
> tidak merespon, setelah saya masuk ke jendela VBA ternya
> name dari button tsb telah berubah
> Dan tidak ada listing
> programnya, setelah saya manual bikinkan listing programnya,
> tetap tombol tsb tidak bereaksi. dan tampil kotak pesan "
> compile error: Object library invalid or contains references
> to object definitions that Could not
> be found".
> Saya sudah mencoba dengan
> merubah setting di Trush Center dengan mengubah ActiveX
> Setting dan Macro Setting ke option Enable. Akan tetapi
> masih error.
>
> Mohon bantunnya dan terima
> kasih sebelumnya.
>
>
> Note: saya pakai
> Excel 2010.
>
> Salam,
> |Rasyid|
>
>
> Disclaimer - This message including any
> attachments and information contained
>
> herein ("Message"; ) may contain privileged
> information or otherwise is protected
>
> from disclosure. Any unauthorized use of this
> Message by any person may lead to
>
> legal consequences. If you receive this Message
> in error, or if the recipient
>
> of this Message is not the intended recipient or the
> employee or agent authorized
>
>
> for delivering this Message to the intended recipient you
> are hereby notified that
>
> any disclosure, dissemination, distribution or copying
> of this Message or let or
>
> cause this Message to be disclosed,disseminated,
> distributed, or copied is strictly

>
> prohibited, and please notify the sender by return
> message and immediately delete
>
> this Message from your system. Incoming and
> outgoing communications using this
>
> electronic mail may be monitored by PT Arutmin Indonesia,as
> permitted by applicable
>
> law and regulations. Unless it is made by the authorized
> person,any views expressed
>
> in this Message are those of the individual sender and may
> not necessarily reflect
>
> the views of PT Arutmin Indonesia.
>
> You should check attachments for viruses and defects before
> opening or using them.
>
> We are not liable to recover any injuries caused by virused
> or defected attachments.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> #yiv1861964602 #yiv1861964602 --
> #yiv1861964602ygrp-mkp {
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
> 0;padding:0 10px;}
>
> #yiv1861964602 #yiv1861964602ygrp-mkp hr {
> border:1px solid #d8d8d8;}
>
> #yiv1861964602 #yiv1861964602ygrp-mkp #yiv1861964602hd {
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}
>
> #yiv1861964602 #yiv1861964602ygrp-mkp #yiv1861964602ads {
> margin-bottom:10px;}
>
> #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad {
> padding:0 0;}
>
> #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad p {
> margin:0;}
>
> #yiv1861964602 #yiv1861964602ygrp-mkp .yiv1861964602ad a {
> color:#0000ff;text-decoration:none;}
> #yiv1861964602 #yiv1861964602ygrp-sponsor
> #yiv1861964602ygrp-lc {
> font-family:Arial;}
>
> #yiv1861964602 #yiv1861964602ygrp-sponsor
> #yiv1861964602ygrp-lc #yiv1861964602hd {
> margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
> #yiv1861964602 #yiv1861964602ygrp-sponsor
> #yiv1861964602ygrp-lc .yiv1861964602ad {
> margin-bottom:10px;padding:0 0;}
>
> #yiv1861964602 #yiv1861964602actions {
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
> #yiv1861964602 #yiv1861964602activity {
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
> #yiv1861964602 #yiv1861964602activity span {
> font-weight:700;}
>
> #yiv1861964602 #yiv1861964602activity span:first-child {
> text-transform:uppercase;}
>
> #yiv1861964602 #yiv1861964602activity span a {
> color:#5085b6;text-decoration:none;}
>
> #yiv1861964602 #yiv1861964602activity span span {
> color:#ff7900;}
>
> #yiv1861964602 #yiv1861964602activity span
> .yiv1861964602underline {
> text-decoration:underline;}
>
> #yiv1861964602 .yiv1861964602attach {
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}
>
> #yiv1861964602 .yiv1861964602attach div a {
> text-decoration:none;}
>
> #yiv1861964602 .yiv1861964602attach img {
> border:none;padding-right:5px;}
>
> #yiv1861964602 .yiv1861964602attach label {
> display:block;margin-bottom:5px;}
>
> #yiv1861964602 .yiv1861964602attach label a {
> text-decoration:none;}
>
> #yiv1861964602 blockquote {
> margin:0 0 0 4px;}
>
> #yiv1861964602 .yiv1861964602bold {
> font-family:Arial;font-size:13px;font-weight:700;}
>
> #yiv1861964602 .yiv1861964602bold a {
> text-decoration:none;}
>
> #yiv1861964602 dd.yiv1861964602last p a {
> font-family:Verdana;font-weight:700;}
>
> #yiv1861964602 dd.yiv1861964602last p span {
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
> #yiv1861964602 dd.yiv1861964602last p
> span.yiv1861964602yshortcuts {
> margin-right:0;}
>
> #yiv1861964602 div.yiv1861964602attach-table div div a {
> text-decoration:none;}
>
> #yiv1861964602 div.yiv1861964602attach-table {
> width:400px;}
>
> #yiv1861964602 div.yiv1861964602file-title a, #yiv1861964602
> div.yiv1861964602file-title a:active, #yiv1861964602
> div.yiv1861964602file-title a:hover, #yiv1861964602

> div.yiv1861964602file-title a:visited {
> text-decoration:none;}
>
> #yiv1861964602 div.yiv1861964602photo-title a,
> #yiv1861964602 div.yiv1861964602photo-title a:active,
> #yiv1861964602 div.yiv1861964602photo-title a:hover,
> #yiv1861964602 div.yiv1861964602photo-title a:visited {
> text-decoration:none;}
>
> #yiv1861964602 div#yiv1861964602ygrp-mlmsg
> #yiv1861964602ygrp-msg p a span.yiv1861964602yshortcuts {
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
> #yiv1861964602 .yiv1861964602green {
> color:#628c2a;}
>
> #yiv1861964602 .yiv1861964602MsoNormal {
> margin:0 0 0 0;}
>
> #yiv1861964602 o {
> font-size:0;}
>
> #yiv1861964602 #yiv1861964602photos div {
> float:left;width:72px;}
>
> #yiv1861964602 #yiv1861964602photos div div {
> border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}
>
> #yiv1861964602 #yiv1861964602photos div label {
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
> #yiv1861964602 #yiv1861964602reco-category {
> font-size:77%;}
>
> #yiv1861964602 #yiv1861964602reco-desc {
> font-size:77%;}
>
> #yiv1861964602 .yiv1861964602replbq {
> margin:4px;}
>
> #yiv1861964602 #yiv1861964602ygrp-actbar div a:first-child {
> margin-right:2px;padding-right:5px;}
>
> #yiv1861964602 #yiv1861964602ygrp-mlmsg {
> font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}
>
> #yiv1861964602 #yiv1861964602ygrp-mlmsg table {
> font-size:inherit;font:100%;}
>
> #yiv1861964602 #yiv1861964602ygrp-mlmsg select,
> #yiv1861964602 input, #yiv1861964602 textarea {
> font:99% Arial, Helvetica, clean, sans-serif;}
>
> #yiv1861964602 #yiv1861964602ygrp-mlmsg pre, #yiv1861964602
> code {
> font:115% monospace;}
>
> #yiv1861964602 #yiv1861964602ygrp-mlmsg * {
> line-height:1.22em;}
>
> #yiv1861964602 #yiv1861964602ygrp-mlmsg #yiv1861964602logo {
> padding-bottom:10px;}
>
>
> #yiv1861964602 #yiv1861964602ygrp-msg p a {
> font-family:Verdana;}
>
> #yiv1861964602 #yiv1861964602ygrp-msg
> p#yiv1861964602attach-count span {
> color:#1E66AE;font-weight:700;}
>
> #yiv1861964602 #yiv1861964602ygrp-reco
> #yiv1861964602reco-head {
> color:#ff7900;font-weight:700;}
>
> #yiv1861964602 #yiv1861964602ygrp-reco {
> margin-bottom:20px;padding:0px;}
>
> #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov
> li a {
> font-size:130%;text-decoration:none;}
>
> #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov
> li {
> font-size:77%;list-style-type:square;padding:6px 0;}
>
> #yiv1861964602 #yiv1861964602ygrp-sponsor #yiv1861964602ov
> ul {
> margin:0;padding:0 0 0 8px;}
>
> #yiv1861964602 #yiv1861964602ygrp-text {
> font-family:Georgia;}
>
> #yiv1861964602 #yiv1861964602ygrp-text p {
> margin:0 0 1em 0;}
>
> #yiv1861964602 #yiv1861964602ygrp-text tt {
> font-size:120%;}
>
> #yiv1861964602 #yiv1861964602ygrp-vital ul li:last-child {
> border-right:none !important;
> }
> #yiv1861964602
>
> Disclaimer - This message including any attachments and information contained
> herein ("Message"; ) may contain privileged information or otherwise is protected
> from disclosure. Any unauthorized use of this Message by any person may lead to
> legal consequences. If you receive this Message in error, or if the recipient
> of this Message is not the intended recipient or the employee or agent authorized
> for delivering this Message to the intended recipient you are hereby notified that
> any disclosure, dissemination, distribution or copying of this Message or let or
> cause this Message to be disclosed,disseminated, distributed, or copied is strictly
> prohibited, and please notify the sender by return message and immediately delete
> this Message from your system. Incoming and outgoing communications using this
> electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable
> law and regulations. Unless it is made by the authorized person,any views expressed
> in this Message are those of the individual sender and may not necessarily reflect
> the views of PT Arutmin Indonesia.
> You should check attachments for viruses and defects before opening or using them.
> We are not liable to recover any injuries caused by virused or defected attachments.
>
>
>

>
> Disclaimer - This message including any attachments and information contained
> herein ("Message"; ) may contain privileged information or otherwise is protected
> from disclosure. Any unauthorized use of this Message by any person may lead to
> legal consequences. If you receive this Message in error, or if the recipient
> of this Message is not the intended recipient or the employee or agent authorized
> for delivering this Message to the intended recipient you are hereby notified that
> any disclosure, dissemination, distribution or copying of this Message or let or
> cause this Message to be disclosed,disseminated, distributed, or copied is strictly
> prohibited, and please notify the sender by return message and immediately delete
> this Message from your system. Incoming and outgoing communications using this
> electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable
> law and regulations. Unless it is made by the authorized person,any views expressed
> in this Message are those of the individual sender and may not necessarily reflect
> the views of PT Arutmin Indonesia.
> You should check attachments for viruses and defects before opening or using them.
> We are not liable to recover any injuries caused by virused or defected attachments.
>
>

Thu Feb 4, 2016 7:28 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Dody,

Coba file berikut..

TerimaKasih

Sent from Yahoo Mail on Android

Thu Feb 4, 2016 4:27 pm (PST) . Posted by:

"Dody Irawan"

@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 tobykenzo@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

>
>
> Hai Dody,
>
> Coba file berikut..
>
> TerimaKasih
>
> Sent from Yahoo Mail on Android
> <http://overview.mail.yahoo.com/mobile/?.src=Android>
>
> ------------------------------
> * From: * Dody Irawan dodyirawan84@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.....
>
>
>

Thu Feb 4, 2016 10:06 pm (PST) . Posted by:

"Dody Irawan"

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 <dodyirawan84@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 tobykenzo@yahoo.co.id
> [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
>
>>
>>
>> Hai Dody,
>>
>> Coba file berikut..
>>
>> TerimaKasih
>>
>> Sent from Yahoo Mail on Android
>> <http://overview.mail.yahoo.com/mobile/?.src=Android>
>>
>> ------------------------------
>> * From: * Dody Irawan dodyirawan84@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.....
>>
>>
>>
>
>

Thu Feb 4, 2016 4:36 pm (PST) . Posted by:

"Dody Irawan"

Terimakasih Mas Subroto, maaf belum paham saya.

hehe, maaf pemula. rumus itu untuk sel yang mana mas..?

Pada 4 Februari 2016 16.04, 'Subroto, Matzen' matzen.subroto@akzonobel.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

>
>
> Hi dody
>
>
>
> Saya baru bisa bantu formula seperti ini
>
>
>
>
> =SUMIFS(Beli!$D$4:$D$18;Beli!$C$4:$C$18;$B13)-SUMIFS(Jual!$D$4:$D$18;Jual!$C$4:$C$18;$B13)
>
>
>
>
>
> Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila
> ada kata-kata yang kurang berkenan
>
>
>
>
>
> *Terima Kasih*
>
>
>
> *Matzen*
>
>
>
>
>
>
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* 04 Februari 2016 14:49
> *To:* belajar-excel@yahoogroups.com
> *Subject:* [belajar-excel] [belajar excel] mohon bantuan untuk membuat
> stok sederhana [1 Attachment]
>
>
>
>
>
> Mohon bantuannya temen-temen master.
>
>
>
>

>
> gimana caranya buat stok yang otomatis ter update.
>
>
>
>
>
> file terlampir.
>
>
>
>
>
> maaf pemula banget.....
>
>
>
> __________________________________________________________
> This email has been scanned by AkzoNobel for Viruses and Spam.
> For more information please contact your local IT Service Desk.
>
> __________________________________________________________
>
>
>

Thu Feb 4, 2016 5:36 pm (PST) . Posted by:

"Subroto, Matzen"

Dear Mas Dody

Formula tersebut untuk di sheet stok, coloum C, setelah list stock yang ada di sheet Beli di copy ke coloum b di sheet stock atau list nama barang yang ada.

Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan


Terima Kasih

Matzen




From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 05 Februari 2016 7:10
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] [belajar excel] mohon bantuan untuk membuat stok sederhana


Terimakasih Mas Subroto, maaf belum paham saya.

hehe, maaf pemula. rumus itu untuk sel yang mana mas..?

Pada 4 Februari 2016 16.04, 'Subroto, Matzen' matzen.subroto@akzonobel.com<mailto:matzen.subroto@akzonobel.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> menulis:

Hi dody

Saya baru bisa bantu formula seperti ini

=SUMIFS(Beli!$D$4:$D$18;Beli!$C$4:$C$18;$B13)-SUMIFS(Jual!$D$4:$D$18;Jual!$C$4:$C$18;$B13)


Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan


Terima Kasih

Matzen



From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>]
Sent: 04 Februari 2016 14:49
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: [belajar-excel] [belajar excel] mohon bantuan untuk membuat stok sederhana [1 Attachment]


Mohon bantuannya temen-temen master.


gimana caranya buat stok yang otomatis ter update.


file terlampir.


maaf pemula banget.....

__________________________________________________________
This email has been scanned by AkzoNobel for Viruses and Spam.
For more information please contact your local IT Service Desk.
__________________________________________________________



__________________________________________________________
This email has been scanned by AkzoNobel for Viruses and Spam.
For more information please contact your local IT Service Desk.
__________________________________________________________

Thu Feb 4, 2016 5:54 pm (PST) . Posted by:

"Darto Chandra"

Mohon bantuannya untuk memodifikasi macronya supaya image logo dapat
munculkan gambarnya. Gambar nama dan logo berada dalam 1 folder. Terima
kasih sebelumnya.

--
*Darto Chandra*
*Sent from mobile Gmail*
*Powered by INDOSAT*

Thu Feb 4, 2016 6:39 pm (PST) . Posted by:

"Toby kenzo" tobykenzo


Hai Darto,

Sepertinya sudah pernah deh di bahas pada waktu itu, coba di lihat2 lagi filenya di milis..

TerimaKasih.

Pada Jum, 5/2/16, Darto Chandra d_c@gmx.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Fwd: 2 image berbeda dlm 1 sheet [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Jumat, 5 Februari, 2016, 8:54 AM


 









Mohon bantuannya
untuk memodifikasi macronya supaya image logo dapat
munculkan gambarnya. Gambar nama dan logo berada dalam 1
folder. Terima kasih sebelumnya.

--
Darto
Chandra
Sent from
mobile GmailPowered by
INDOSAT













#yiv4284737427 #yiv4284737427 --
#yiv4284737427ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv4284737427 #yiv4284737427ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4284737427 #yiv4284737427ygrp-mkp #yiv4284737427hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4284737427 #yiv4284737427ygrp-mkp #yiv4284737427ads {
margin-bottom:10px;}

#yiv4284737427 #yiv4284737427ygrp-mkp .yiv4284737427ad {
padding:0 0;}

#yiv4284737427 #yiv4284737427ygrp-mkp .yiv4284737427ad p {
margin:0;}

#yiv4284737427 #yiv4284737427ygrp-mkp .yiv4284737427ad a {
color:#0000ff;text-decoration:none;}
#yiv4284737427 #yiv4284737427ygrp-sponsor
#yiv4284737427ygrp-lc {
font-family:Arial;}

#yiv4284737427 #yiv4284737427ygrp-sponsor
#yiv4284737427ygrp-lc #yiv4284737427hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4284737427 #yiv4284737427ygrp-sponsor
#yiv4284737427ygrp-lc .yiv4284737427ad {
margin-bottom:10px;padding:0 0;}

#yiv4284737427 #yiv4284737427actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv4284737427 #yiv4284737427activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv4284737427 #yiv4284737427activity span {
font-weight:700;}

#yiv4284737427 #yiv4284737427activity span:first-child {
text-transform:uppercase;}

#yiv4284737427 #yiv4284737427activity span a {
color:#5085b6;text-decoration:none;}

#yiv4284737427 #yiv4284737427activity span span {
color:#ff7900;}

#yiv4284737427 #yiv4284737427activity span
.yiv4284737427underline {
text-decoration:underline;}

#yiv4284737427 .yiv4284737427attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv4284737427 .yiv4284737427attach div a {
text-decoration:none;}

#yiv4284737427 .yiv4284737427attach img {
border:none;padding-right:5px;}

#yiv4284737427 .yiv4284737427attach label {
display:block;margin-bottom:5px;}

#yiv4284737427 .yiv4284737427attach label a {
text-decoration:none;}

#yiv4284737427 blockquote {
margin:0 0 0 4px;}

#yiv4284737427 .yiv4284737427bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4284737427 .yiv4284737427bold a {
text-decoration:none;}

#yiv4284737427 dd.yiv4284737427last p a {
font-family:Verdana;font-weight:700;}

#yiv4284737427 dd.yiv4284737427last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv4284737427 dd.yiv4284737427last p
span.yiv4284737427yshortcuts {
margin-right:0;}

#yiv4284737427 div.yiv4284737427attach-table div div a {
text-decoration:none;}

#yiv4284737427 div.yiv4284737427attach-table {
width:400px;}

#yiv4284737427 div.yiv4284737427file-title a, #yiv4284737427
div.yiv4284737427file-title a:active, #yiv4284737427
div.yiv4284737427file-title a:hover, #yiv4284737427
div.yiv4284737427file-title a:visited {
text-decoration:none;}

#yiv4284737427 div.yiv4284737427photo-title a,
#yiv4284737427 div.yiv4284737427photo-title a:active,
#yiv4284737427 div.yiv4284737427photo-title a:hover,
#yiv4284737427 div.yiv4284737427photo-title a:visited {
text-decoration:none;}

#yiv4284737427 div#yiv4284737427ygrp-mlmsg
#yiv4284737427ygrp-msg p a span.yiv4284737427yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4284737427 .yiv4284737427green {
color:#628c2a;}

#yiv4284737427 .yiv4284737427MsoNormal {
margin:0 0 0 0;}

#yiv4284737427 o {
font-size:0;}

#yiv4284737427 #yiv4284737427photos div {
float:left;width:72px;}

#yiv4284737427 #yiv4284737427photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv4284737427 #yiv4284737427photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv4284737427 #yiv4284737427reco-category {
font-size:77%;}

#yiv4284737427 #yiv4284737427reco-desc {
font-size:77%;}

#yiv4284737427 .yiv4284737427replbq {
margin:4px;}

#yiv4284737427 #yiv4284737427ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv4284737427 #yiv4284737427ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv4284737427 #yiv4284737427ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv4284737427 #yiv4284737427ygrp-mlmsg select,
#yiv4284737427 input, #yiv4284737427 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv4284737427 #yiv4284737427ygrp-mlmsg pre, #yiv4284737427
code {
font:115% monospace;}

#yiv4284737427 #yiv4284737427ygrp-mlmsg * {
line-height:1.22em;}

#yiv4284737427 #yiv4284737427ygrp-mlmsg #yiv4284737427logo {
padding-bottom:10px;}


#yiv4284737427 #yiv4284737427ygrp-msg p a {
font-family:Verdana;}

#yiv4284737427 #yiv4284737427ygrp-msg
p#yiv4284737427attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4284737427 #yiv4284737427ygrp-reco
#yiv4284737427reco-head {
color:#ff7900;font-weight:700;}

#yiv4284737427 #yiv4284737427ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4284737427 #yiv4284737427ygrp-sponsor #yiv4284737427ov
li a {
font-size:130%;text-decoration:none;}

#yiv4284737427 #yiv4284737427ygrp-sponsor #yiv4284737427ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4284737427 #yiv4284737427ygrp-sponsor #yiv4284737427ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4284737427 #yiv4284737427ygrp-text {
font-family:Georgia;}

#yiv4284737427 #yiv4284737427ygrp-text p {
margin:0 0 1em 0;}

#yiv4284737427 #yiv4284737427ygrp-text tt {
font-size:120%;}

#yiv4284737427 #yiv4284737427ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4284737427

Thu Feb 4, 2016 10:05 pm (PST) . Posted by:

"asam gatal"

Berikut saya bagikan hasil penambahan dan pengurangan tahun bulan dan hari
sesuai janji saya berikut sesuai anjuran Pak Kid

SIlakan lihat lampiran

Thu Feb 4, 2016 11:01 pm (PST) . Posted by:

"asam gatal"

Mohon bantuan lagi nih.

Bagaimana mengisi kolom E sampai dengan H secara otomatis.

Ketentuan: Silakan lihat lampiran

Terima kasih atas bantuannya.
============================================================
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