Rabu, 23 Desember 2015

[belajar-excel] Digest Number 3694

15 Messages

Digest #3694
2a
3a
Re: File sharing by "Tio Adi Bayu Adjie"
4.1
Re: Bls: [belajar-excel] Belajar Makro & VBA by "Contract Mining Assistant, Asam-Asam"
4.3
Re: Bls: [belajar-excel] Belajar Makro & VBA by "hendrik karnadi" hendrikkarnadi
4.4
Re: Bls: [belajar-excel] Belajar Makro & VBA by "hendrik karnadi" hendrikkarnadi
6a
7.1
7.2
Re: BLS: [belajar-excel] Belajar Makro & VBA by "hendrik karnadi" hendrikkarnadi

Messages

Tue Dec 22, 2015 7:06 pm (PST) . Posted by:

"odong nando"

dear all,
saya ingin menanyakan untuk lampiran file yang dari bos kid shet mydata, ada yang saya bingung neh, 1. ada filds yang namanya SAK, tapi di source datanya tidak ada yang header SAK...tu buat or cara mengadakannya gmn ya...?2. dalam pivot yang bos kid buat ada header namanya saldo akhir, itu maksudnya gmn ya, cara buatnya...?
tolong di bantu untuk menjelaskannya trimakasih. br,

odong nando


Pada Selasa, 22 Desember 2015 20:02, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Nando,

Untuk kasus Anda,
Pivot consolidation kurang fleksibel.
Excel Pivot Table masih cukup fleksibel walau banyak batasannya.

File terlampir.

Wassalam,
Kid

2015-12-21 14:57 GMT+07:00 odong nando odongnando@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  dear all,
saya sedang membuat report dengan menggunakan 2 sheet sebagai data, hasil yang di inginkan seperti membuat pivot saja, namun ada beberapa tambahan sedikit yang membuat bingun saya sendiri, saya sudah menggunakan pivot wizart namun masih bingung untuk mendapat hasil yang diinginkan.
untuk lebih jelas bisa dilihat dari lampiran berikut. br,

odong nando


#yiv4256253419 #yiv4256253419 -- #yiv4256253419ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4256253419 #yiv4256253419ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4256253419 #yiv4256253419ygrp-mkp #yiv4256253419hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4256253419 #yiv4256253419ygrp-mkp #yiv4256253419ads {margin-bottom:10px;}#yiv4256253419 #yiv4256253419ygrp-mkp .yiv4256253419ad {padding:0 0;}#yiv4256253419 #yiv4256253419ygrp-mkp .yiv4256253419ad p {margin:0;}#yiv4256253419 #yiv4256253419ygrp-mkp .yiv4256253419ad a {color:#0000ff;text-decoration:none;}#yiv4256253419 #yiv4256253419ygrp-sponsor #yiv4256253419ygrp-lc {font-family:Arial;}#yiv4256253419 #yiv4256253419ygrp-sponsor #yiv4256253419ygrp-lc #yiv4256253419hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4256253419 #yiv4256253419ygrp-sponsor #yiv4256253419ygrp-lc .yiv4256253419ad {margin-bottom:10px;padding:0 0;}#yiv4256253419 #yiv4256253419actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4256253419 #yiv4256253419activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4256253419 #yiv4256253419activity span {font-weight:700;}#yiv4256253419 #yiv4256253419activity span:first-child {text-transform:uppercase;}#yiv4256253419 #yiv4256253419activity span a {color:#5085b6;text-decoration:none;}#yiv4256253419 #yiv4256253419activity span span {color:#ff7900;}#yiv4256253419 #yiv4256253419activity span .yiv4256253419underline {text-decoration:underline;}#yiv4256253419 .yiv4256253419attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4256253419 .yiv4256253419attach div a {text-decoration:none;}#yiv4256253419 .yiv4256253419attach img {border:none;padding-right:5px;}#yiv4256253419 .yiv4256253419attach label {display:block;margin-bottom:5px;}#yiv4256253419 .yiv4256253419attach label a {text-decoration:none;}#yiv4256253419 blockquote {margin:0 0 0 4px;}#yiv4256253419 .yiv4256253419bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4256253419 .yiv4256253419bold a {text-decoration:none;}#yiv4256253419 dd.yiv4256253419last p a {font-family:Verdana;font-weight:700;}#yiv4256253419 dd.yiv4256253419last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4256253419 dd.yiv4256253419last p span.yiv4256253419yshortcuts {margin-right:0;}#yiv4256253419 div.yiv4256253419attach-table div div a {text-decoration:none;}#yiv4256253419 div.yiv4256253419attach-table {width:400px;}#yiv4256253419 div.yiv4256253419file-title a, #yiv4256253419 div.yiv4256253419file-title a:active, #yiv4256253419 div.yiv4256253419file-title a:hover, #yiv4256253419 div.yiv4256253419file-title a:visited {text-decoration:none;}#yiv4256253419 div.yiv4256253419photo-title a, #yiv4256253419 div.yiv4256253419photo-title a:active, #yiv4256253419 div.yiv4256253419photo-title a:hover, #yiv4256253419 div.yiv4256253419photo-title a:visited {text-decoration:none;}#yiv4256253419 div#yiv4256253419ygrp-mlmsg #yiv4256253419ygrp-msg p a span.yiv4256253419yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4256253419 .yiv4256253419green {color:#628c2a;}#yiv4256253419 .yiv4256253419MsoNormal {margin:0 0 0 0;}#yiv4256253419 o {font-size:0;}#yiv4256253419 #yiv4256253419photos div {float:left;width:72px;}#yiv4256253419 #yiv4256253419photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4256253419 #yiv4256253419photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4256253419 #yiv4256253419reco-category {font-size:77%;}#yiv4256253419 #yiv4256253419reco-desc {font-size:77%;}#yiv4256253419 .yiv4256253419replbq {margin:4px;}#yiv4256253419 #yiv4256253419ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4256253419 #yiv4256253419ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4256253419 #yiv4256253419ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4256253419 #yiv4256253419ygrp-mlmsg select, #yiv4256253419 input, #yiv4256253419 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4256253419 #yiv4256253419ygrp-mlmsg pre, #yiv4256253419 code {font:115% monospace;}#yiv4256253419 #yiv4256253419ygrp-mlmsg * {line-height:1.22em;}#yiv4256253419 #yiv4256253419ygrp-mlmsg #yiv4256253419logo {padding-bottom:10px;}#yiv4256253419 #yiv4256253419ygrp-msg p a {font-family:Verdana;}#yiv4256253419 #yiv4256253419ygrp-msg p#yiv4256253419attach-count span {color:#1E66AE;font-weight:700;}#yiv4256253419 #yiv4256253419ygrp-reco #yiv4256253419reco-head {color:#ff7900;font-weight:700;}#yiv4256253419 #yiv4256253419ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4256253419 #yiv4256253419ygrp-sponsor #yiv4256253419ov li a {font-size:130%;text-decoration:none;}#yiv4256253419 #yiv4256253419ygrp-sponsor #yiv4256253419ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4256253419 #yiv4256253419ygrp-sponsor #yiv4256253419ov ul {margin:0;padding:0 0 0 8px;}#yiv4256253419 #yiv4256253419ygrp-text {font-family:Georgia;}#yiv4256253419 #yiv4256253419ygrp-text p {margin:0 0 1em 0;}#yiv4256253419 #yiv4256253419ygrp-text tt {font-size:120%;}#yiv4256253419 #yiv4256253419ygrp-vital ul li:last-child {border-right:none !important;}#yiv4256253419

Tue Dec 22, 2015 8:00 pm (PST) . Posted by:

"Subroto, Matzen"

Assalamu alaikum Mr.Kid

Semoga selalu dalam Lindungan Allah SWT. Mr.Kid bisa dibuatkan step untuk mendapatkan data seperti table yang paling terakhir, karena saya masih bingung step yang mana terlebih dahulu di kerjakan dan untuk jadwal tiba, apakah tiba di loksai tujuan bongkar muat atau tiba di tujuan loading.


Wassalamu alaikum
Terima Kasih

Matzen





From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 22 Desember 2015 20:04
To: BeExcel
Subject: Re: [belajar-excel] transport plan [1 Attachment]


hmmm...
masih belum ada yang reply...
File terlampir adalah contoh dengan banyak asumsi.

Wassalam,
Kid




2015-12-21 9:37 GMT+07:00 Mr. Kid <mr.nmkid@gmail.com<mailto:mr.nmkid@gmail.com>>:
Dear BeExceller,
Thread ini sudah dilengkapi dengan informasi sebagai berikut :
1. Target kapasitas yang perlu diantar oleh Truck(s) per location untuk sampai dilokasi disuatu tanggal tertentu.
> ada banyak tanggal target dengan kapasitas permintaan yang bisa berbeda-beda.
> data disusun per location (sisi baris) dan per tanggal (sisi kolom) dengan nilai kapasitas target per location per tanggal
2. Location :
> ada banyak location,
> data yang tersedia adalah nama location dan jumlah hari untuk mencapai location
> Misal, location bernama Location1 ditempuh dalam 1 hari.
> Artinya, jadwal truck untuk Location1 adalah 1 hari sebelum tanggal target dengan kapasitas permintaan sesuai tanggal tersebut.
3. Daftar Truck
> ada banyak truck dengan berbagai kapasitas
> data yang tersedia adalah nama Truck dan kapasitas angkut truck tersebut
4. Kondisi
> untuk memenuhi sebuah target permintaan (nomor 1), bisa memerlukan banyak truck.
> truck yang sudah berangkat menuju location tertentu tidak dapat digunakan lagi, karena belum tersedia informasi kapan truck yang sudah selesai mencapai suatu target bisa digunakan kembali (jika membutuhkan waktu untuk mencapai suatu location, maka akan ada waktu untuk kembali ke location, dan akan ada waktu untuk bongkar muat).
5. File lampiran
> Pak Yudi telah menyertakan file lampiran pada email yang lalu di thread ini.
Selamat mencoba...
Regards,
Kid




2015-12-21 9:00 GMT+07:00 Yudi Dwiyono yudidwiyono@gmail.com<mailto:yudidwiyono@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Dear Master Kid,

pada tanggal 4 kita memakai truck 1 dengan kapasitas 1200, pada tanggal 5 seharusnya pakai truck 2 dengan kapasitas 1200 karena truk 1 dengan kapasitas 1200 sudah beroperasi, maaf file yang saya lampirkan tadi adalah file dengan formula coba coba dari saya..tpo nimbulnya kok truck 1 terus..
Demikian Mr kid.

Regards,
Yudi

2015-12-21 8:51 GMT+07:00 'Mr. Kid' mr.nmkid@gmail.com<mailto:mr.nmkid@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Oh gitu...
Kapan pakai Truck1 atau Truck2 atau truck lainnya selain dengan batasan kapasitas yang dibutuhkan ?


2015-12-21 8:26 GMT+07:00 Yudi Dwiyono yudidwiyono@gmail.com<mailto:yudidwiyono@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Dear Mr Kid,

Ya, Terima kasih atas sarannya.

1. Saya mau merencana kan keberangkatan barang yang akan di supply
2. Lead time untuk samai ke lokasi 1 adalah 1 hari, lokasi 2 adalah 3 hari dst.
3. Let say saya mempunyai armada sebanyak 22 truck dengan kapasitas sampai 1200 kg dan 1200 - 2000 kg
4. Jika pengiriman ke lokasi 1 yang di jadwalkan harus tiba di tanggal 5 jan , dengan berat barang 500 kg artinya memakai truck dengan kapasitas 1200 kg maka truck haru berangkat 1 hari sebelumnya . seperti terlampir.

Adakah formula otomatis yang dapat mengatur nya.
Terima kasih master atas masukan nya.

Regards,
Yudi


2015-12-20 11:10 GMT+07:00 'Mr. Kid' mr.nmkid@gmail.com<mailto:mr.nmkid@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Sepertinya trit ini tidak ada yang merespon karena BeExceller kurang mampu memahami kasusnya.
Bagaimana jika dicontohkan dengan detil tentang langkah manual pengerjaannya (misal kalau di entri data itu seperti apa prosesnya [bukan hanya hasilnya])
Contoh :
saya mau plan keberangkatan yang ini. Langkah 1, lihat nilai ini. kalau yang nilainya segini, berarti diletakkan disini bunyi begini
dst
xixixixi...
sapa tahu terus ada respon yang memuaskan dari BeExceller yang bisa paham.
Regards,
Kid





2015-12-15 15:01 GMT+07:00 Yudi Dwiyono yudidwiyono@gmail.com<mailto:yudidwiyono@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Dear para Master Excel,

Saya mau bertanya untuk Transport Plan terlampir, bagaimana cara untuk merencanakan keberangkatan armada. filte terlampir.
Thanks.

Regards,
Yudi









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

Tue Dec 22, 2015 9:47 pm (PST) . Posted by:

"Tio Adi Bayu Adjie"

Terima kasih masukannya.
Bagaimana yah setelah file sharing itu diedit oleh banyak orang, pastinya khan setelah input data harus di protek lagi ? Apakah ada solusi protek data setelah di input oleh banyak orang di file sharing itu ?

Terima kasih.

Best Regards,
Tio Adi Bayu Adjie
Mobile : 082125577485
Email : tio.adjie@ptssb.co.id<mailto:stefany.muller@ptssb.co.id>





From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, December 23, 2015 9:00 AM
To: BExcel
Subject: Re: [belajar-excel] File sharing


Dear Tio,
setahu saya share workbook banyak keterbatasan, misalnya gak bisa: protect worksheet, write vba (tapi masih bisa rekam macro kok)
merger center, Conditional formating, create table, insert objec apapun, dll.
untuk membuat sebuah sheet terprotect pada share workbook langkah yang harus dilakukan adalah:
1. File jangan berupa share worbook dahulu.
2. Protect sheet yang dibutuhkan, bila perlu gunakan userinterfaceOnly, agar dapat menulis pada sheet terprotect menggunakan VBA.
3. ubah file menjadi share workbook.
Jadi sesudah file merupakan ShareWorkbook, maka sudah tidak bisa diprotect worksheetnya.
salam
NangAgus

2015-12-23 8:21 GMT+07:00 Tio Adi Bayu Adjie tio.adjie@ptssb.co.id<mailto:tio.adjie@ptssb.co.id> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Semangat Pagi XL-Expert,
Untuk file sharing ini, saya kesulitan mem-protek sheet di file sharing ini. Saya sudah pakai code vba tapi tetap tidak bekerja.
Seperti dengan memakai code vba :
strFilePathName = "CLS Monitoring Share-3.xlsm"
ActiveWorkbook.ProtectSharing Filename:=strFilePathName, sharingpassword:="1"

Dan unprotek sheet di file sharing dg code :
ActiveWorkbook.UnprotectSharing sharingpassword:="1"

Kira-kira kenapa ya tidak bisa code tersebut, adakah solusinya ?
Saya googling di internet, di file sharing memang tidak bisa di protek/unprotek sheet, benarkah ? Adakah solusinya ?

Terima kasih sekali atas bantuannya.

Best Regards,
Tio Adi Bayu Adjie
Email : tio.adjie@ptssb.co.id<mailto:stefany.muller@ptssb.co.id>



From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Sunday, December 20, 2015 5:31 AM
To: BeExcel
Subject: Re: [belajar-excel] File sharing


Hai Tio,
Tidak ada yang perlu ditambahkan. Bisa jadi, langkah nomor 1 tidak diperlukan. Tetapi, bila ingin lebih terasa lebih aman, langkah 1 juga dilakukan. Langkah 2 adalah unprotect sheet. Langkah 5 adalah protect sheet.
Jika tidak ingin muncul pesan-pesan dari Excel, atur aplikasi Excel properti DisplayAlerts menjadi off sebelum langkah 1 dan atur kembali menjadi on setelah langkah 5.
Wassalam,
Kid

2015-12-19 8:03 GMT+07:00 Tio Ali tioali2011@yahoo.co.id<mailto:tioali2011@yahoo.co.id> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Salam para pakar Excel.
Saya sedang buat file sharing excel dan buat code untuk input data.
Langkah2nya sbb :
1. Save data dulu biar bisa lihat perubahan data yg ter-update
2. Buka protek baris yang mau diisi datanya
3. Buat code untuk input data
4. Save data
5. Protek workbook lagi

Adakah langkah2 saya yang perlu ditambahkan /perlu dikoreksi ?

Terima kasih.
Tio


Dikirim dari Yahoo Mail pada Android<https://overview.mail.yahoo.com/mobile/?.src=Android>

________________________________


---------- Forwarded message ----------
From: dwint ruswanto dwint.ruswanto@gmail.com<mailto:dwint.ruswanto@gmail.com> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
Date: 2015-12-14 12:45 GMT+07:00
Subject: [belajar-excel] Mariori - Makanan Ringan Obrolan Ringan Be-Excel
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>

Assalamu'alaikum wr. wb.,

Dear Be-Exceler,

Dalam upaya memperetat silaturahmi dan mendekatkan diri antara member milis Belajar Excel, moderator memiliki rencana untuk melakukan pertemuan rutin 2-3 bulan sekali di luar jadwal Kopdar Millis.

Pertemuan akan dilakukan bergilir di sekitar wilayah Jabodetabek. Lokasi diusahakan yang mudah dijangkau oleh kendaraan umum. Tidak ada biaya yang dipungut untuk hadir dalam pertemuan ini, karena konsumsi makan dan minum ditanggung oleh masing-masing anggota yang hadir.

Jadwal perdana, Insha Allah akan dilaksanakan pada:

Hari/Tanggal : Sabtu, 19 Desember 2015
Jam : 12:00 - selesai
Lokasi : Starbucks Sarinah, Jl. MH Thamrin, Jakarta Pusat

Undangan ini terbuka untuk seluruh anggota millis Belajar Excel.

Be-Exceler yang Insha Allah sudah menyatakan diri akan hadir adalah:
1. Mr Kid
2. Pak Anton
3. Pak Hendrik Karnadi
4. saya sendiri
5. reserved for pak Aliif :)
6. reserved for Bang Aksan :)
7. ....
8. ... dst

Berhubung acara ini bukanlah kopdar, jadi tidak ada materi khusus yang akan dibahas dalam bentuk presentasi, tetapi jika ada yang ingin membawa kasus silakan disampaikan. Insha Allah akan dicari solusinya bersama-sama.

Ditunggu kehadiran rekan Be-Exceler yang lain.

Wassalamu'alaikum wr. wb.,

dwint









Tue Dec 22, 2015 9:48 pm (PST) . Posted by:

"Contract Mining Assistant, Asam-Asam"

Pak Hendrik,
Mohon invite juga saya ya. tks.

Salam, Rasyid

Email: rasyid_1005@yahoo.co.id

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, December 23, 2015 10:16 AM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA


Hai Tio, sdh saya invite

Salam,
HK

________________________________
From: "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id<mailto:tio.adjie@ptssb.co.id> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Sent: Wednesday, 23 December 2015, 8:13
Subject: RE: Bls: [belajar-excel] Belajar Makro & VBA


Hallo Pak Hendrik,
Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.

Terima kasih.

Email : tio.adjie@ptssb.co.id<mailto:stefany.muller@ptssb.co.id>





From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA


Hai Haris,
Sdh saya invite.

Salam,
HK


Sent from Samsung Mobile

-------- Original message --------
From: "Rian Sutarsa riansutarsa@yahoo.com<mailto:riansutarsa@yahoo.com> [belajar-excel]"
Date:22/12/2015 5:26 PM (GMT+07:00)
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Bls: [belajar-excel] Belajar Makro VBA


saya juga mau belajar Makro & VBA sungguh :)

Pada Selasa, 22 Desember 2015 13:56, "ris ha har1sn.excel@yahoo.com<mailto:har1sn.excel@yahoo.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> menulis:


Dear Pak Hendrik

Saya juga ingein belajar menggunakan makro. har1sn.excel@yahoo.com<mailto:har1sn.excel@yahoo.com>

salam
Haris

On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]<mailto:rudhiedhie@yahoo.com%20[belajar-excel]>" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> wrote:


Dear Pak Hendrik

Bolehkan di invited email Saya ?
Saya juga ingein belajar menggunakan makro.

Wassalam




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.

Tue Dec 22, 2015 9:49 pm (PST) . Posted by:

"wahyu abdi" wahyu71

Dear Pak HK,
Saya juga mau dong.
Regards,Wahyu

On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Hallo Pak Hendrik, Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.   Terima kasih.  
| Email :tio.adjie@ptssb.co.id | |
| | | |
| | | | |

    From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA     Hai Haris, Sdh saya invite.   Salam, HK     Sent from Samsung Mobile   -------- Original message -------- From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]" Date:22/12/2015 5:26 PM (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] Belajar Makro VBA     saya juga mau belajar Makro & VBA sungguh :)   Pada Selasa, 22 Desember 2015 13:56, "ris hahar1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:     Dear Pak Hendrik   Saya juga ingein belajar menggunakan makro.har1sn.excel@yahoo.com   salam Haris   On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:     Dear Pak Hendrik   Bolehkan di invited email Saya ? Saya juga ingein belajar menggunakan makro.   Wassalam     #yiv3883108968 -- #yiv3883108968ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3883108968 #yiv3883108968ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3883108968 #yiv3883108968ygrp-mkp #yiv3883108968hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3883108968 #yiv3883108968ygrp-mkp #yiv3883108968ads {margin-bottom:10px;}#yiv3883108968 #yiv3883108968ygrp-mkp .yiv3883108968ad {padding:0 0;}#yiv3883108968 #yiv3883108968ygrp-mkp .yiv3883108968ad p {margin:0;}#yiv3883108968 #yiv3883108968ygrp-mkp .yiv3883108968ad a {color:#0000ff;text-decoration:none;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ygrp-lc {font-family:Arial;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ygrp-lc #yiv3883108968hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ygrp-lc .yiv3883108968ad {margin-bottom:10px;padding:0 0;}#yiv3883108968 #yiv3883108968actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3883108968 #yiv3883108968activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3883108968 #yiv3883108968activity span {font-weight:700;}#yiv3883108968 #yiv3883108968activity span:first-child {text-transform:uppercase;}#yiv3883108968 #yiv3883108968activity span a {color:#5085b6;text-decoration:none;}#yiv3883108968 #yiv3883108968activity span span {color:#ff7900;}#yiv3883108968 #yiv3883108968activity span .yiv3883108968underline {text-decoration:underline;}#yiv3883108968 .yiv3883108968attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3883108968 .yiv3883108968attach div a {text-decoration:none;}#yiv3883108968 .yiv3883108968attach img {border:none;padding-right:5px;}#yiv3883108968 .yiv3883108968attach label {display:block;margin-bottom:5px;}#yiv3883108968 .yiv3883108968attach label a {text-decoration:none;}#yiv3883108968 blockquote {margin:0 0 0 4px;}#yiv3883108968 .yiv3883108968bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3883108968 .yiv3883108968bold a {text-decoration:none;}#yiv3883108968 dd.yiv3883108968last p a {font-family:Verdana;font-weight:700;}#yiv3883108968 dd.yiv3883108968last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3883108968 dd.yiv3883108968last p span.yiv3883108968yshortcuts {margin-right:0;}#yiv3883108968 div.yiv3883108968attach-table div div a {text-decoration:none;}#yiv3883108968 div.yiv3883108968attach-table {width:400px;}#yiv3883108968 div.yiv3883108968file-title a, #yiv3883108968 div.yiv3883108968file-title a:active, #yiv3883108968 div.yiv3883108968file-title a:hover, #yiv3883108968 div.yiv3883108968file-title a:visited {text-decoration:none;}#yiv3883108968 div.yiv3883108968photo-title a, #yiv3883108968 div.yiv3883108968photo-title a:active, #yiv3883108968 div.yiv3883108968photo-title a:hover, #yiv3883108968 div.yiv3883108968photo-title a:visited {text-decoration:none;}#yiv3883108968 div#yiv3883108968ygrp-mlmsg #yiv3883108968ygrp-msg p a span.yiv3883108968yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3883108968 .yiv3883108968green {color:#628c2a;}#yiv3883108968 .yiv3883108968MsoNormal {margin:0 0 0 0;}#yiv3883108968 o {font-size:0;}#yiv3883108968 #yiv3883108968photos div {float:left;width:72px;}#yiv3883108968 #yiv3883108968photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3883108968 #yiv3883108968photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3883108968 #yiv3883108968reco-category {font-size:77%;}#yiv3883108968 #yiv3883108968reco-desc {font-size:77%;}#yiv3883108968 .yiv3883108968replbq {margin:4px;}#yiv3883108968 #yiv3883108968ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3883108968 #yiv3883108968ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3883108968 #yiv3883108968ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3883108968 #yiv3883108968ygrp-mlmsg select, #yiv3883108968 input, #yiv3883108968 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3883108968 #yiv3883108968ygrp-mlmsg pre, #yiv3883108968 code {font:115% monospace;}#yiv3883108968 #yiv3883108968ygrp-mlmsg * {line-height:1.22em;}#yiv3883108968 #yiv3883108968ygrp-mlmsg #yiv3883108968logo {padding-bottom:10px;}#yiv3883108968 #yiv3883108968ygrp-msg p a {font-family:Verdana;}#yiv3883108968 #yiv3883108968ygrp-msg p#yiv3883108968attach-count span {color:#1E66AE;font-weight:700;}#yiv3883108968 #yiv3883108968ygrp-reco #yiv3883108968reco-head {color:#ff7900;font-weight:700;}#yiv3883108968 #yiv3883108968ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ov li a {font-size:130%;text-decoration:none;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ov ul {margin:0;padding:0 0 0 8px;}#yiv3883108968 #yiv3883108968ygrp-text {font-family:Georgia;}#yiv3883108968 #yiv3883108968ygrp-text p {margin:0 0 1em 0;}#yiv3883108968 #yiv3883108968ygrp-text tt {font-size:120%;}#yiv3883108968 #yiv3883108968ygrp-vital ul li:last-child {border-right:none !important;}#yiv3883108968

Tue Dec 22, 2015 11:43 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Saya sdh invite.
Salam,HK


From: "wahyu abdi wahyu71@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 23 December 2015, 11:43
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA

  Dear Pak HK,
Saya juga mau dong.
Regards,Wahyu

On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Hallo Pak Hendrik, Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.   Terima kasih.  
| Email :tio.adjie@ptssb.co.id | |
| | | |
| | | | |

    From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA     Hai Haris, Sdh saya invite.   Salam, HK     Sent from Samsung Mobile   -------- Original message -------- From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]" Date:22/12/2015 5:26 PM (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] Belajar Makro VBA     saya juga mau belajar Makro & VBA sungguh :)   Pada Selasa, 22 Desember 2015 13:56, "ris hahar1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:     Dear Pak Hendrik   Saya juga ingein belajar menggunakan makro.har1sn.excel@yahoo.com   salam Haris   On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:     Dear Pak Hendrik   Bolehkan di invited email Saya ? Saya juga ingein belajar menggunakan makro.   Wassalam    

#yiv8480182278 #yiv8480182278 -- #yiv8480182278ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8480182278 #yiv8480182278ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8480182278 #yiv8480182278ygrp-mkp #yiv8480182278hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8480182278 #yiv8480182278ygrp-mkp #yiv8480182278ads {margin-bottom:10px;}#yiv8480182278 #yiv8480182278ygrp-mkp .yiv8480182278ad {padding:0 0;}#yiv8480182278 #yiv8480182278ygrp-mkp .yiv8480182278ad p {margin:0;}#yiv8480182278 #yiv8480182278ygrp-mkp .yiv8480182278ad a {color:#0000ff;text-decoration:none;}#yiv8480182278 #yiv8480182278ygrp-sponsor #yiv8480182278ygrp-lc {font-family:Arial;}#yiv8480182278 #yiv8480182278ygrp-sponsor #yiv8480182278ygrp-lc #yiv8480182278hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8480182278 #yiv8480182278ygrp-sponsor #yiv8480182278ygrp-lc .yiv8480182278ad {margin-bottom:10px;padding:0 0;}#yiv8480182278 #yiv8480182278actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8480182278 #yiv8480182278activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8480182278 #yiv8480182278activity span {font-weight:700;}#yiv8480182278 #yiv8480182278activity span:first-child {text-transform:uppercase;}#yiv8480182278 #yiv8480182278activity span a {color:#5085b6;text-decoration:none;}#yiv8480182278 #yiv8480182278activity span span {color:#ff7900;}#yiv8480182278 #yiv8480182278activity span .yiv8480182278underline {text-decoration:underline;}#yiv8480182278 .yiv8480182278attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8480182278 .yiv8480182278attach div a {text-decoration:none;}#yiv8480182278 .yiv8480182278attach img {border:none;padding-right:5px;}#yiv8480182278 .yiv8480182278attach label {display:block;margin-bottom:5px;}#yiv8480182278 .yiv8480182278attach label a {text-decoration:none;}#yiv8480182278 blockquote {margin:0 0 0 4px;}#yiv8480182278 .yiv8480182278bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8480182278 .yiv8480182278bold a {text-decoration:none;}#yiv8480182278 dd.yiv8480182278last p a {font-family:Verdana;font-weight:700;}#yiv8480182278 dd.yiv8480182278last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8480182278 dd.yiv8480182278last p span.yiv8480182278yshortcuts {margin-right:0;}#yiv8480182278 div.yiv8480182278attach-table div div a {text-decoration:none;}#yiv8480182278 div.yiv8480182278attach-table {width:400px;}#yiv8480182278 div.yiv8480182278file-title a, #yiv8480182278 div.yiv8480182278file-title a:active, #yiv8480182278 div.yiv8480182278file-title a:hover, #yiv8480182278 div.yiv8480182278file-title a:visited {text-decoration:none;}#yiv8480182278 div.yiv8480182278photo-title a, #yiv8480182278 div.yiv8480182278photo-title a:active, #yiv8480182278 div.yiv8480182278photo-title a:hover, #yiv8480182278 div.yiv8480182278photo-title a:visited {text-decoration:none;}#yiv8480182278 div#yiv8480182278ygrp-mlmsg #yiv8480182278ygrp-msg p a span.yiv8480182278yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8480182278 .yiv8480182278green {color:#628c2a;}#yiv8480182278 .yiv8480182278MsoNormal {margin:0 0 0 0;}#yiv8480182278 o {font-size:0;}#yiv8480182278 #yiv8480182278photos div {float:left;width:72px;}#yiv8480182278 #yiv8480182278photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8480182278 #yiv8480182278photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8480182278 #yiv8480182278reco-category {font-size:77%;}#yiv8480182278 #yiv8480182278reco-desc {font-size:77%;}#yiv8480182278 .yiv8480182278replbq {margin:4px;}#yiv8480182278 #yiv8480182278ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8480182278 #yiv8480182278ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8480182278 #yiv8480182278ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8480182278 #yiv8480182278ygrp-mlmsg select, #yiv8480182278 input, #yiv8480182278 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8480182278 #yiv8480182278ygrp-mlmsg pre, #yiv8480182278 code {font:115% monospace;}#yiv8480182278 #yiv8480182278ygrp-mlmsg * {line-height:1.22em;}#yiv8480182278 #yiv8480182278ygrp-mlmsg #yiv8480182278logo {padding-bottom:10px;}#yiv8480182278 #yiv8480182278ygrp-msg p a {font-family:Verdana;}#yiv8480182278 #yiv8480182278ygrp-msg p#yiv8480182278attach-count span {color:#1E66AE;font-weight:700;}#yiv8480182278 #yiv8480182278ygrp-reco #yiv8480182278reco-head {color:#ff7900;font-weight:700;}#yiv8480182278 #yiv8480182278ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8480182278 #yiv8480182278ygrp-sponsor #yiv8480182278ov li a {font-size:130%;text-decoration:none;}#yiv8480182278 #yiv8480182278ygrp-sponsor #yiv8480182278ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8480182278 #yiv8480182278ygrp-sponsor #yiv8480182278ov ul {margin:0;padding:0 0 0 8px;}#yiv8480182278 #yiv8480182278ygrp-text {font-family:Georgia;}#yiv8480182278 #yiv8480182278ygrp-text p {margin:0 0 1em 0;}#yiv8480182278 #yiv8480182278ygrp-text tt {font-size:120%;}#yiv8480182278 #yiv8480182278ygrp-vital ul li:last-child {border-right:none !important;}#yiv8480182278

Tue Dec 22, 2015 11:45 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

saya sdh invite.
Salam,Ht

From: "'Contract Mining Assistant, Asam-Asam' apassistant@arutmin.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 23 December 2015, 9:42
Subject: RE: Bls: [belajar-excel] Belajar Makro & VBA

  Pak Hendrik, Mohon invite juga saya ya. tks.   Salam, Rasyid   Email: rasyid_1005@yahoo.co.id   From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, December 23, 2015 10:16 AM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA     Hai Tio, sdh saya invite   Salam, HK   From: "Tio Adi Bayu Adjietio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 23 December 2015, 8:13
Subject: RE: Bls: [belajar-excel] Belajar Makro & VBA     Hallo Pak Hendrik, Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.   Terima kasih.  
| Email : tio.adjie@ptssb.co.id | |
| | | |
| | | | |

    From:belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA     Hai Haris, Sdh saya invite.   Salam, HK     Sent from Samsung Mobile   -------- Original message -------- From: "Rian Sutarsariansutarsa@yahoo.com [belajar-excel]" Date:22/12/2015 5:26 PM (GMT+07:00) To:belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] Belajar Makro VBA     saya juga mau belajar Makro & VBA sungguh :)   Pada Selasa, 22 Desember 2015 13:56, "ris hahar1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:     Dear Pak Hendrik   Saya juga ingein belajar menggunakan makro.har1sn.excel@yahoo.com   salam Haris   On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:     Dear Pak Hendrik   Bolehkan di invited email Saya ? Saya juga ingein belajar menggunakan makro.   Wassalam       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. #yiv7195070304 #yiv7195070304 -- #yiv7195070304ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7195070304 #yiv7195070304ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7195070304 #yiv7195070304ygrp-mkp #yiv7195070304hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7195070304 #yiv7195070304ygrp-mkp #yiv7195070304ads {margin-bottom:10px;}#yiv7195070304 #yiv7195070304ygrp-mkp .yiv7195070304ad {padding:0 0;}#yiv7195070304 #yiv7195070304ygrp-mkp .yiv7195070304ad p {margin:0;}#yiv7195070304 #yiv7195070304ygrp-mkp .yiv7195070304ad a {color:#0000ff;text-decoration:none;}#yiv7195070304 #yiv7195070304ygrp-sponsor #yiv7195070304ygrp-lc {font-family:Arial;}#yiv7195070304 #yiv7195070304ygrp-sponsor #yiv7195070304ygrp-lc #yiv7195070304hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7195070304 #yiv7195070304ygrp-sponsor #yiv7195070304ygrp-lc .yiv7195070304ad {margin-bottom:10px;padding:0 0;}#yiv7195070304 #yiv7195070304actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7195070304 #yiv7195070304activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7195070304 #yiv7195070304activity span {font-weight:700;}#yiv7195070304 #yiv7195070304activity span:first-child {text-transform:uppercase;}#yiv7195070304 #yiv7195070304activity span a {color:#5085b6;text-decoration:none;}#yiv7195070304 #yiv7195070304activity span span {color:#ff7900;}#yiv7195070304 #yiv7195070304activity span .yiv7195070304underline {text-decoration:underline;}#yiv7195070304 .yiv7195070304attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7195070304 .yiv7195070304attach div a {text-decoration:none;}#yiv7195070304 .yiv7195070304attach img {border:none;padding-right:5px;}#yiv7195070304 .yiv7195070304attach label {display:block;margin-bottom:5px;}#yiv7195070304 .yiv7195070304attach label a {text-decoration:none;}#yiv7195070304 blockquote {margin:0 0 0 4px;}#yiv7195070304 .yiv7195070304bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7195070304 .yiv7195070304bold a {text-decoration:none;}#yiv7195070304 dd.yiv7195070304last p a {font-family:Verdana;font-weight:700;}#yiv7195070304 dd.yiv7195070304last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7195070304 dd.yiv7195070304last p span.yiv7195070304yshortcuts {margin-right:0;}#yiv7195070304 div.yiv7195070304attach-table div div a {text-decoration:none;}#yiv7195070304 div.yiv7195070304attach-table {width:400px;}#yiv7195070304 div.yiv7195070304file-title a, #yiv7195070304 div.yiv7195070304file-title a:active, #yiv7195070304 div.yiv7195070304file-title a:hover, #yiv7195070304 div.yiv7195070304file-title a:visited {text-decoration:none;}#yiv7195070304 div.yiv7195070304photo-title a, #yiv7195070304 div.yiv7195070304photo-title a:active, #yiv7195070304 div.yiv7195070304photo-title a:hover, #yiv7195070304 div.yiv7195070304photo-title a:visited {text-decoration:none;}#yiv7195070304 div#yiv7195070304ygrp-mlmsg #yiv7195070304ygrp-msg p a span.yiv7195070304yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7195070304 .yiv7195070304green {color:#628c2a;}#yiv7195070304 .yiv7195070304MsoNormal {margin:0 0 0 0;}#yiv7195070304 o {font-size:0;}#yiv7195070304 #yiv7195070304photos div {float:left;width:72px;}#yiv7195070304 #yiv7195070304photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7195070304 #yiv7195070304photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7195070304 #yiv7195070304reco-category {font-size:77%;}#yiv7195070304 #yiv7195070304reco-desc {font-size:77%;}#yiv7195070304 .yiv7195070304replbq {margin:4px;}#yiv7195070304 #yiv7195070304ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7195070304 #yiv7195070304ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7195070304 #yiv7195070304ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7195070304 #yiv7195070304ygrp-mlmsg select, #yiv7195070304 input, #yiv7195070304 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7195070304 #yiv7195070304ygrp-mlmsg pre, #yiv7195070304 code {font:115% monospace;}#yiv7195070304 #yiv7195070304ygrp-mlmsg * {line-height:1.22em;}#yiv7195070304 #yiv7195070304ygrp-mlmsg #yiv7195070304logo {padding-bottom:10px;}#yiv7195070304 #yiv7195070304ygrp-msg p a {font-family:Verdana;}#yiv7195070304 #yiv7195070304ygrp-msg p#yiv7195070304attach-count span {color:#1E66AE;font-weight:700;}#yiv7195070304 #yiv7195070304ygrp-reco #yiv7195070304reco-head {color:#ff7900;font-weight:700;}#yiv7195070304 #yiv7195070304ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7195070304 #yiv7195070304ygrp-sponsor #yiv7195070304ov li a {font-size:130%;text-decoration:none;}#yiv7195070304 #yiv7195070304ygrp-sponsor #yiv7195070304ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7195070304 #yiv7195070304ygrp-sponsor #yiv7195070304ov ul {margin:0;padding:0 0 0 8px;}#yiv7195070304 #yiv7195070304ygrp-text {font-family:Georgia;}#yiv7195070304 #yiv7195070304ygrp-text p {margin:0 0 1em 0;}#yiv7195070304 #yiv7195070304ygrp-text tt {font-size:120%;}#yiv7195070304 #yiv7195070304ygrp-vital ul li:last-child {border-right:none !important;}#yiv7195070304

Wed Dec 23, 2015 1:48 am (PST) . Posted by:

rwanto78

Kepada yth
Bp. HK
Mohon kiranya diinvite email saya..pengen belajar macro VBA.
rwanto78@yahoo.com

Terimakasih sebelumnya

Salam hormat
Ruswanto
Powered by Telkomsel BlackBerry®

-----Original Message-----
From: "wahyu abdi wahyu71@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Sender: belajar-excel@yahoogroups.com
Date: Wed, 23 Dec 2015 04:43:41
To: <belajar-excel@yahoogroups.com>
Reply-To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA

Dear Pak HK,
Saya juga mau dong.
Regards,Wahyu





On Tuesday, December 22, 2015 5:16 PM, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:



  Hallo Pak Hendrik, Pak, mohon juga di invite email saya, karena mau belajar Makro dan VBA.   Terima kasih.  
| Email :tio.adjie@ptssb.co.id | |
| | | |
| | | | |


    From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, December 22, 2015 10:38 PM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Belajar Makro & VBA     Hai Haris, Sdh saya invite.   Salam, HK     Sent from Samsung Mobile   -------- Original message -------- From: "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]" Date:22/12/2015 5:26 PM (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] Belajar Makro VBA     saya juga mau belajar Makro & VBA sungguh :)   Pada Selasa, 22 Desember 2015 13:56, "ris hahar1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:     Dear Pak Hendrik   Saya juga ingein belajar menggunakan makro.har1sn.excel@yahoo.com   salam Haris   On Tuesday, December 22, 2015 12:51 PM, "rudhiedhie@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:     Dear Pak Hendrik   Bolehkan di invited email Saya ? Saya juga ingein belajar menggunakan makro.   Wassalam     #yiv3883108968 -- #yiv3883108968ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3883108968 #yiv3883108968ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3883108968 #yiv3883108968ygrp-mkp #yiv3883108968hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3883108968 #yiv3883108968ygrp-mkp #yiv3883108968ads {margin-bottom:10px;}#yiv3883108968 #yiv3883108968ygrp-mkp .yiv3883108968ad {padding:0 0;}#yiv3883108968 #yiv3883108968ygrp-mkp .yiv3883108968ad p {margin:0;}#yiv3883108968 #yiv3883108968ygrp-mkp .yiv3883108968ad a {color:#0000ff;text-decoration:none;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ygrp-lc {font-family:Arial;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ygrp-lc #yiv3883108968hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ygrp-lc .yiv3883108968ad {margin-bottom:10px;padding:0 0;}#yiv3883108968 #yiv3883108968actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3883108968 #yiv3883108968activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3883108968 #yiv3883108968activity span {font-weight:700;}#yiv3883108968 #yiv3883108968activity span:first-child {text-transform:uppercase;}#yiv3883108968 #yiv3883108968activity span a {color:#5085b6;text-decoration:none;}#yiv3883108968 #yiv3883108968activity span span {color:#ff7900;}#yiv3883108968 #yiv3883108968activity span .yiv3883108968underline {text-decoration:underline;}#yiv3883108968 .yiv3883108968attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3883108968 .yiv3883108968attach div a {text-decoration:none;}#yiv3883108968 .yiv3883108968attach img {border:none;padding-right:5px;}#yiv3883108968 .yiv3883108968attach label {display:block;margin-bottom:5px;}#yiv3883108968 .yiv3883108968attach label a {text-decoration:none;}#yiv3883108968 blockquote {margin:0 0 0 4px;}#yiv3883108968 .yiv3883108968bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3883108968 .yiv3883108968bold a {text-decoration:none;}#yiv3883108968 dd.yiv3883108968last p a {font-family:Verdana;font-weight:700;}#yiv3883108968 dd.yiv3883108968last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3883108968 dd.yiv3883108968last p span.yiv3883108968yshortcuts {margin-right:0;}#yiv3883108968 div.yiv3883108968attach-table div div a {text-decoration:none;}#yiv3883108968 div.yiv3883108968attach-table {width:400px;}#yiv3883108968 div.yiv3883108968file-title a, #yiv3883108968 div.yiv3883108968file-title a:active, #yiv3883108968 div.yiv3883108968file-title a:hover, #yiv3883108968 div.yiv3883108968file-title a:visited {text-decoration:none;}#yiv3883108968 div.yiv3883108968photo-title a, #yiv3883108968 div.yiv3883108968photo-title a:active, #yiv3883108968 div.yiv3883108968photo-title a:hover, #yiv3883108968 div.yiv3883108968photo-title a:visited {text-decoration:none;}#yiv3883108968 div#yiv3883108968ygrp-mlmsg #yiv3883108968ygrp-msg p a span.yiv3883108968yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3883108968 .yiv3883108968green {color:#628c2a;}#yiv3883108968 .yiv3883108968MsoNormal {margin:0 0 0 0;}#yiv3883108968 o {font-size:0;}#yiv3883108968 #yiv3883108968photos div {float:left;width:72px;}#yiv3883108968 #yiv3883108968photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3883108968 #yiv3883108968photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3883108968 #yiv3883108968reco-category {font-size:77%;}#yiv3883108968 #yiv3883108968reco-desc {font-size:77%;}#yiv3883108968 .yiv3883108968replbq {margin:4px;}#yiv3883108968 #yiv3883108968ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3883108968 #yiv3883108968ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3883108968 #yiv3883108968ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3883108968 #yiv3883108968ygrp-mlmsg select, #yiv3883108968 input, #yiv3883108968 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3883108968 #yiv3883108968ygrp-mlmsg pre, #yiv3883108968 code {font:115% monospace;}#yiv3883108968 #yiv3883108968ygrp-mlmsg * {line-height:1.22em;}#yiv3883108968 #yiv3883108968ygrp-mlmsg #yiv3883108968logo {padding-bottom:10px;}#yiv3883108968 #yiv3883108968ygrp-msg p a {font-family:Verdana;}#yiv3883108968 #yiv3883108968ygrp-msg p#yiv3883108968attach-count span {color:#1E66AE;font-weight:700;}#yiv3883108968 #yiv3883108968ygrp-reco #yiv3883108968reco-head {color:#ff7900;font-weight:700;}#yiv3883108968 #yiv3883108968ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ov li a {font-size:130%;text-decoration:none;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3883108968 #yiv3883108968ygrp-sponsor #yiv3883108968ov ul {margin:0;padding:0 0 0 8px;}#yiv3883108968 #yiv3883108968ygrp-text {font-family:Georgia;}#yiv3883108968 #yiv3883108968ygrp-text p {margin:0 0 1em 0;}#yiv3883108968 #yiv3883108968ygrp-text tt {font-size:120%;}#yiv3883108968 #yiv3883108968ygrp-vital ul li:last-child {border-right:none !important;}#yiv3883108968



Tue Dec 22, 2015 9:48 pm (PST) . Posted by:

"HAIRUL ALAM"

Assalamualaikum
Yth. Para Milis Excel
Saya memiliki masalah Close aplikasi Excel yang menggunakan VBA, berpengaruh pada file Excel Lain yang sedang aktif
Bagaimana mengatasinya agar file excel yang memiliki VBA tersebut bekerja sendiri dan bila di close file excel yang lain tidak berpengaruh
Terimakasih Banyak
WassalamualaikumHairul Alam

Wed Dec 23, 2015 1:48 am (PST) . Posted by:

"HAIRUL ALAM"

Maaf Para Milis Excel
Lampirannya Ketinggalan

Pada Rabu, 23 Desember 2015 12:48, "HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Assalamualaikum
Yth. Para Milis Excel
Saya memiliki masalah Close aplikasi Excel yang menggunakan VBA, berpengaruh pada file Excel Lain yang sedang aktif
Bagaimana mengatasinya agar file excel yang memiliki VBA tersebut bekerja sendiri dan bila di close file excel yang lain tidak berpengaruh
Terimakasih Banyak
WassalamualaikumHairul Alam #yiv3332296247 #yiv3332296247 -- #yiv3332296247ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3332296247 #yiv3332296247ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3332296247 #yiv3332296247ygrp-mkp #yiv3332296247hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3332296247 #yiv3332296247ygrp-mkp #yiv3332296247ads {margin-bottom:10px;}#yiv3332296247 #yiv3332296247ygrp-mkp .yiv3332296247ad {padding:0 0;}#yiv3332296247 #yiv3332296247ygrp-mkp .yiv3332296247ad p {margin:0;}#yiv3332296247 #yiv3332296247ygrp-mkp .yiv3332296247ad a {color:#0000ff;text-decoration:none;}#yiv3332296247 #yiv3332296247ygrp-sponsor #yiv3332296247ygrp-lc {font-family:Arial;}#yiv3332296247 #yiv3332296247ygrp-sponsor #yiv3332296247ygrp-lc #yiv3332296247hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3332296247 #yiv3332296247ygrp-sponsor #yiv3332296247ygrp-lc .yiv3332296247ad {margin-bottom:10px;padding:0 0;}#yiv3332296247 #yiv3332296247actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3332296247 #yiv3332296247activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3332296247 #yiv3332296247activity span {font-weight:700;}#yiv3332296247 #yiv3332296247activity span:first-child {text-transform:uppercase;}#yiv3332296247 #yiv3332296247activity span a {color:#5085b6;text-decoration:none;}#yiv3332296247 #yiv3332296247activity span span {color:#ff7900;}#yiv3332296247 #yiv3332296247activity span .yiv3332296247underline {text-decoration:underline;}#yiv3332296247 .yiv3332296247attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3332296247 .yiv3332296247attach div a {text-decoration:none;}#yiv3332296247 .yiv3332296247attach img {border:none;padding-right:5px;}#yiv3332296247 .yiv3332296247attach label {display:block;margin-bottom:5px;}#yiv3332296247 .yiv3332296247attach label a {text-decoration:none;}#yiv3332296247 blockquote {margin:0 0 0 4px;}#yiv3332296247 .yiv3332296247bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3332296247 .yiv3332296247bold a {text-decoration:none;}#yiv3332296247 dd.yiv3332296247last p a {font-family:Verdana;font-weight:700;}#yiv3332296247 dd.yiv3332296247last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3332296247 dd.yiv3332296247last p span.yiv3332296247yshortcuts {margin-right:0;}#yiv3332296247 div.yiv3332296247attach-table div div a {text-decoration:none;}#yiv3332296247 div.yiv3332296247attach-table {width:400px;}#yiv3332296247 div.yiv3332296247file-title a, #yiv3332296247 div.yiv3332296247file-title a:active, #yiv3332296247 div.yiv3332296247file-title a:hover, #yiv3332296247 div.yiv3332296247file-title a:visited {text-decoration:none;}#yiv3332296247 div.yiv3332296247photo-title a, #yiv3332296247 div.yiv3332296247photo-title a:active, #yiv3332296247 div.yiv3332296247photo-title a:hover, #yiv3332296247 div.yiv3332296247photo-title a:visited {text-decoration:none;}#yiv3332296247 div#yiv3332296247ygrp-mlmsg #yiv3332296247ygrp-msg p a span.yiv3332296247yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3332296247 .yiv3332296247green {color:#628c2a;}#yiv3332296247 .yiv3332296247MsoNormal {margin:0 0 0 0;}#yiv3332296247 o {font-size:0;}#yiv3332296247 #yiv3332296247photos div {float:left;width:72px;}#yiv3332296247 #yiv3332296247photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3332296247 #yiv3332296247photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3332296247 #yiv3332296247reco-category {font-size:77%;}#yiv3332296247 #yiv3332296247reco-desc {font-size:77%;}#yiv3332296247 .yiv3332296247replbq {margin:4px;}#yiv3332296247 #yiv3332296247ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3332296247 #yiv3332296247ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3332296247 #yiv3332296247ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3332296247 #yiv3332296247ygrp-mlmsg select, #yiv3332296247 input, #yiv3332296247 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3332296247 #yiv3332296247ygrp-mlmsg pre, #yiv3332296247 code {font:115% monospace;}#yiv3332296247 #yiv3332296247ygrp-mlmsg * {line-height:1.22em;}#yiv3332296247 #yiv3332296247ygrp-mlmsg #yiv3332296247logo {padding-bottom:10px;}#yiv3332296247 #yiv3332296247ygrp-msg p a {font-family:Verdana;}#yiv3332296247 #yiv3332296247ygrp-msg p#yiv3332296247attach-count span {color:#1E66AE;font-weight:700;}#yiv3332296247 #yiv3332296247ygrp-reco #yiv3332296247reco-head {color:#ff7900;font-weight:700;}#yiv3332296247 #yiv3332296247ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3332296247 #yiv3332296247ygrp-sponsor #yiv3332296247ov li a {font-size:130%;text-decoration:none;}#yiv3332296247 #yiv3332296247ygrp-sponsor #yiv3332296247ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3332296247 #yiv3332296247ygrp-sponsor #yiv3332296247ov ul {margin:0;padding:0 0 0 8px;}#yiv3332296247 #yiv3332296247ygrp-text {font-family:Georgia;}#yiv3332296247 #yiv3332296247ygrp-text p {margin:0 0 1em 0;}#yiv3332296247 #yiv3332296247ygrp-text tt {font-size:120%;}#yiv3332296247 #yiv3332296247ygrp-vital ul li:last-child {border-right:none !important;}#yiv3332296247

Tue Dec 22, 2015 9:49 pm (PST) . Posted by:

"Rian Sutarsa" riansutarsa

salam pagi BExceller mohon penerangannya di pagi mendung ini.saya punya gambaran permasalahan.di beberapa kelas ada pendaftaran beberapa perlombaan (MTQ, Kaligrafi, Dakwah, Qiro'at) nah dari beberapa siswa dari masing-masing kelas terdapat macam-macam pilihan siswa (Minimal 2 Pilihan).dalam rekapan saya (sheet 1 : Pendaftaran) saya masukkan secara acak tanpa penyusunan per-kelas & per-nama.saya mohon di sheet 2 Rekapan perlombaan Kelas untuk menyusunkan nama nama siswa tergantung perlombaan pilihannya masing-masing termasuk

Wed Dec 23, 2015 1:09 am (PST) . Posted by:

"odong nando"

yoo rian,
pada sheet pendaftaran bisa di siapkan header
NAMA | KELAS | JENIS LOMBA
ketik nama kelas dan jenis lomba pada setiap barisnya, bila akan memilih 2 maka masukan lagi nama kelas dan jenis lomba (yang ke2). setelah itu blok semua data termasuk header klik ribon insert pilih pivot table, pilih new worksheet -> OK.pada sheet yang terdapat pivot table nya drak n drop fields JENIS LOMBA, KELAS, NAMA secara berurutan pada row labels. atau klik kanan pada masing2 fields pilih row labels secara berurutan. maka akan tersusun seperti yang diinginkan.
br,

odong nando

Pada Rabu, 23 Desember 2015 12:49, "Rian Sutarsa riansutarsa@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  salam pagi BExceller mohon penerangannya di pagi mendung ini.saya punya gambaran permasalahan.di beberapa kelas ada pendaftaran beberapa perlombaan (MTQ, Kaligrafi, Dakwah, Qiro'at) nah dari beberapa siswa dari masing-masing kelas terdapat macam-macam pilihan siswa (Minimal 2 Pilihan).dalam rekapan saya (sheet 1 : Pendaftaran) saya masukkan secara acak tanpa penyusunan per-kelas & per-nama.saya mohon di sheet 2 Rekapan perlombaan Kelas untuk menyusunkan nama nama siswa tergantung perlombaan pilihannya masing-masing termasuk
#yiv3519373974 -- #yiv3519373974ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3519373974 #yiv3519373974ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3519373974 #yiv3519373974ygrp-mkp #yiv3519373974hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3519373974 #yiv3519373974ygrp-mkp #yiv3519373974ads {margin-bottom:10px;}#yiv3519373974 #yiv3519373974ygrp-mkp .yiv3519373974ad {padding:0 0;}#yiv3519373974 #yiv3519373974ygrp-mkp .yiv3519373974ad p {margin:0;}#yiv3519373974 #yiv3519373974ygrp-mkp .yiv3519373974ad a {color:#0000ff;text-decoration:none;}#yiv3519373974 #yiv3519373974ygrp-sponsor #yiv3519373974ygrp-lc {font-family:Arial;}#yiv3519373974 #yiv3519373974ygrp-sponsor #yiv3519373974ygrp-lc #yiv3519373974hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3519373974 #yiv3519373974ygrp-sponsor #yiv3519373974ygrp-lc .yiv3519373974ad {margin-bottom:10px;padding:0 0;}#yiv3519373974 #yiv3519373974actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3519373974 #yiv3519373974activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3519373974 #yiv3519373974activity span {font-weight:700;}#yiv3519373974 #yiv3519373974activity span:first-child {text-transform:uppercase;}#yiv3519373974 #yiv3519373974activity span a {color:#5085b6;text-decoration:none;}#yiv3519373974 #yiv3519373974activity span span {color:#ff7900;}#yiv3519373974 #yiv3519373974activity span .yiv3519373974underline {text-decoration:underline;}#yiv3519373974 .yiv3519373974attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3519373974 .yiv3519373974attach div a {text-decoration:none;}#yiv3519373974 .yiv3519373974attach img {border:none;padding-right:5px;}#yiv3519373974 .yiv3519373974attach label {display:block;margin-bottom:5px;}#yiv3519373974 .yiv3519373974attach label a {text-decoration:none;}#yiv3519373974 blockquote {margin:0 0 0 4px;}#yiv3519373974 .yiv3519373974bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3519373974 .yiv3519373974bold a {text-decoration:none;}#yiv3519373974 dd.yiv3519373974last p a {font-family:Verdana;font-weight:700;}#yiv3519373974 dd.yiv3519373974last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3519373974 dd.yiv3519373974last p span.yiv3519373974yshortcuts {margin-right:0;}#yiv3519373974 div.yiv3519373974attach-table div div a {text-decoration:none;}#yiv3519373974 div.yiv3519373974attach-table {width:400px;}#yiv3519373974 div.yiv3519373974file-title a, #yiv3519373974 div.yiv3519373974file-title a:active, #yiv3519373974 div.yiv3519373974file-title a:hover, #yiv3519373974 div.yiv3519373974file-title a:visited {text-decoration:none;}#yiv3519373974 div.yiv3519373974photo-title a, #yiv3519373974 div.yiv3519373974photo-title a:active, #yiv3519373974 div.yiv3519373974photo-title a:hover, #yiv3519373974 div.yiv3519373974photo-title a:visited {text-decoration:none;}#yiv3519373974 div#yiv3519373974ygrp-mlmsg #yiv3519373974ygrp-msg p a span.yiv3519373974yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3519373974 .yiv3519373974green {color:#628c2a;}#yiv3519373974 .yiv3519373974MsoNormal {margin:0 0 0 0;}#yiv3519373974 o {font-size:0;}#yiv3519373974 #yiv3519373974photos div {float:left;width:72px;}#yiv3519373974 #yiv3519373974photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3519373974 #yiv3519373974photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3519373974 #yiv3519373974reco-category {font-size:77%;}#yiv3519373974 #yiv3519373974reco-desc {font-size:77%;}#yiv3519373974 .yiv3519373974replbq {margin:4px;}#yiv3519373974 #yiv3519373974ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3519373974 #yiv3519373974ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3519373974 #yiv3519373974ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3519373974 #yiv3519373974ygrp-mlmsg select, #yiv3519373974 input, #yiv3519373974 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3519373974 #yiv3519373974ygrp-mlmsg pre, #yiv3519373974 code {font:115% monospace;}#yiv3519373974 #yiv3519373974ygrp-mlmsg * {line-height:1.22em;}#yiv3519373974 #yiv3519373974ygrp-mlmsg #yiv3519373974logo {padding-bottom:10px;}#yiv3519373974 #yiv3519373974ygrp-msg p a {font-family:Verdana;}#yiv3519373974 #yiv3519373974ygrp-msg p#yiv3519373974attach-count span {color:#1E66AE;font-weight:700;}#yiv3519373974 #yiv3519373974ygrp-reco #yiv3519373974reco-head {color:#ff7900;font-weight:700;}#yiv3519373974 #yiv3519373974ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3519373974 #yiv3519373974ygrp-sponsor #yiv3519373974ov li a {font-size:130%;text-decoration:none;}#yiv3519373974 #yiv3519373974ygrp-sponsor #yiv3519373974ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3519373974 #yiv3519373974ygrp-sponsor #yiv3519373974ov ul {margin:0;padding:0 0 0 8px;}#yiv3519373974 #yiv3519373974ygrp-text {font-family:Georgia;}#yiv3519373974 #yiv3519373974ygrp-text p {margin:0 0 1em 0;}#yiv3519373974 #yiv3519373974ygrp-text tt {font-size:120%;}#yiv3519373974 #yiv3519373974ygrp-vital ul li:last-child {border-right:none !important;}#yiv3519373974

Tue Dec 22, 2015 11:07 pm (PST) . Posted by:

"Praztmath" praztmath

And juga ikutan mr.hendrik, Mau nambah ilmu juga pads Para mater tentang macro&vba

-----Pesan Asli-----
Dari: "Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Terkirim: ‎22/‎12/‎2015 23:42
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Subjek: Re: [belajar-excel] Belajar Makro & VBA

Hai rudhiedhie,
Saya sdh invite.

Salam,
HK

Sent from Samsung Mobile

-------- Original message --------
From: "rudhiedhie@yahoo.com [belajar-excel]"
Date:22/12/2015 11:35 AM (GMT+07:00)
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Belajar Makro VBA

Dear Pak Hendrik

Bolehkan di invited email Saya ?
Saya juga ingein belajar menggunakan makro.

Wassalam

Tue Dec 22, 2015 11:43 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sdh saya invite.
Salam,HK


From: "Praztmath praztmath@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 23 December 2015, 14:07
Subject: BLS: [belajar-excel] Belajar Makro & VBA

  And juga ikutan mr.hendrik, Mau nambah ilmu juga pads Para mater tentang macro&vbaDari: Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]
Terkirim: ‎22/‎12/‎2015 23:42
Kepada: belajar-excel@yahoogroups.com
Subjek: Re: [belajar-excel] Belajar Makro & VBA

  Hai rudhiedhie,Saya sdh invite.
Salam,HK
Sent from Samsung Mobile

-------- Original message --------From: "rudhiedhie@yahoo.com [belajar-excel]" Date:22/12/2015 11:35 AM (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Re: [belajar-excel] Belajar Makro VBA
  Dear Pak Hendrik
Bolehkan di invited email Saya ?Saya juga ingein belajar menggunakan makro.
Wassalam #yiv8435034775 #yiv8435034775 -- #yiv8435034775ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8435034775 #yiv8435034775ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8435034775 #yiv8435034775ygrp-mkp #yiv8435034775hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8435034775 #yiv8435034775ygrp-mkp #yiv8435034775ads {margin-bottom:10px;}#yiv8435034775 #yiv8435034775ygrp-mkp .yiv8435034775ad {padding:0 0;}#yiv8435034775 #yiv8435034775ygrp-mkp .yiv8435034775ad p {margin:0;}#yiv8435034775 #yiv8435034775ygrp-mkp .yiv8435034775ad a {color:#0000ff;text-decoration:none;}#yiv8435034775 #yiv8435034775ygrp-sponsor #yiv8435034775ygrp-lc {font-family:Arial;}#yiv8435034775 #yiv8435034775ygrp-sponsor #yiv8435034775ygrp-lc #yiv8435034775hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8435034775 #yiv8435034775ygrp-sponsor #yiv8435034775ygrp-lc .yiv8435034775ad {margin-bottom:10px;padding:0 0;}#yiv8435034775 #yiv8435034775actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8435034775 #yiv8435034775activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8435034775 #yiv8435034775activity span {font-weight:700;}#yiv8435034775 #yiv8435034775activity span:first-child {text-transform:uppercase;}#yiv8435034775 #yiv8435034775activity span a {color:#5085b6;text-decoration:none;}#yiv8435034775 #yiv8435034775activity span span {color:#ff7900;}#yiv8435034775 #yiv8435034775activity span .yiv8435034775underline {text-decoration:underline;}#yiv8435034775 .yiv8435034775attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8435034775 .yiv8435034775attach div a {text-decoration:none;}#yiv8435034775 .yiv8435034775attach img {border:none;padding-right:5px;}#yiv8435034775 .yiv8435034775attach label {display:block;margin-bottom:5px;}#yiv8435034775 .yiv8435034775attach label a {text-decoration:none;}#yiv8435034775 blockquote {margin:0 0 0 4px;}#yiv8435034775 .yiv8435034775bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8435034775 .yiv8435034775bold a {text-decoration:none;}#yiv8435034775 dd.yiv8435034775last p a {font-family:Verdana;font-weight:700;}#yiv8435034775 dd.yiv8435034775last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8435034775 dd.yiv8435034775last p span.yiv8435034775yshortcuts {margin-right:0;}#yiv8435034775 div.yiv8435034775attach-table div div a {text-decoration:none;}#yiv8435034775 div.yiv8435034775attach-table {width:400px;}#yiv8435034775 div.yiv8435034775file-title a, #yiv8435034775 div.yiv8435034775file-title a:active, #yiv8435034775 div.yiv8435034775file-title a:hover, #yiv8435034775 div.yiv8435034775file-title a:visited {text-decoration:none;}#yiv8435034775 div.yiv8435034775photo-title a, #yiv8435034775 div.yiv8435034775photo-title a:active, #yiv8435034775 div.yiv8435034775photo-title a:hover, #yiv8435034775 div.yiv8435034775photo-title a:visited {text-decoration:none;}#yiv8435034775 div#yiv8435034775ygrp-mlmsg #yiv8435034775ygrp-msg p a span.yiv8435034775yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8435034775 .yiv8435034775green {color:#628c2a;}#yiv8435034775 .yiv8435034775MsoNormal {margin:0 0 0 0;}#yiv8435034775 o {font-size:0;}#yiv8435034775 #yiv8435034775photos div {float:left;width:72px;}#yiv8435034775 #yiv8435034775photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8435034775 #yiv8435034775photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8435034775 #yiv8435034775reco-category {font-size:77%;}#yiv8435034775 #yiv8435034775reco-desc {font-size:77%;}#yiv8435034775 .yiv8435034775replbq {margin:4px;}#yiv8435034775 #yiv8435034775ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8435034775 #yiv8435034775ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8435034775 #yiv8435034775ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8435034775 #yiv8435034775ygrp-mlmsg select, #yiv8435034775 input, #yiv8435034775 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8435034775 #yiv8435034775ygrp-mlmsg pre, #yiv8435034775 code {font:115% monospace;}#yiv8435034775 #yiv8435034775ygrp-mlmsg * {line-height:1.22em;}#yiv8435034775 #yiv8435034775ygrp-mlmsg #yiv8435034775logo {padding-bottom:10px;}#yiv8435034775 #yiv8435034775ygrp-msg p a {font-family:Verdana;}#yiv8435034775 #yiv8435034775ygrp-msg p#yiv8435034775attach-count span {color:#1E66AE;font-weight:700;}#yiv8435034775 #yiv8435034775ygrp-reco #yiv8435034775reco-head {color:#ff7900;font-weight:700;}#yiv8435034775 #yiv8435034775ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8435034775 #yiv8435034775ygrp-sponsor #yiv8435034775ov li a {font-size:130%;text-decoration:none;}#yiv8435034775 #yiv8435034775ygrp-sponsor #yiv8435034775ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8435034775 #yiv8435034775ygrp-sponsor #yiv8435034775ov ul {margin:0;padding:0 0 0 8px;}#yiv8435034775 #yiv8435034775ygrp-text {font-family:Georgia;}#yiv8435034775 #yiv8435034775ygrp-text p {margin:0 0 1em 0;}#yiv8435034775 #yiv8435034775ygrp-text tt {font-size:120%;}#yiv8435034775 #yiv8435034775ygrp-vital ul li:last-child {border-right:none !important;}#yiv8435034775

Wed Dec 23, 2015 1:48 am (PST) . Posted by:

"Armia Abbas" armiaabbas

Dear BeExceller,

Kasus ini adalah menyaring data berdasarkan suatu kriteria tertentu ke sheet lain. Kriteria filter diubah dengan sebuah spin button. Hasil filter kemudian dicetak.

Pada file terlampir, formula untuk mengambil data terfilter sesuai kriteria masih menghasilkan error value.
Proses mencetaknya juga belum dibuat.

Mohon bantuan rekan BeExceller tentang langkah perbaikannya.

Terimakasih atas bantuannya.

Atas nama penanya,
Tim Moderator Belajar-Excel

--- Mods ---
Dimohon, untuk memberi subject email dengan kalimat singkat yang mewakili kasus yang diutarakan.
Dimohon juga, untuk menuliskan beberapa kalimat penjelasan singkat tentang kasus yang diutarakan di dalam body email, sebagai bagian dari kewajaran dan kesantunan dalam surat menyurat.
---------------







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