Re: ]] XL-mania [[ klasifikasi jenis kelamin ke sheet yang berbeda sekaligus sort by date

 



Dear Pak Aji,

 

salah satu cara penyelesaian..

tinggal di modif, pakai offset+counta, biar data bisa fleksibel.

 

sudah sorted ascending by date

 

blessings,

tomz

 

----- Original Message -----

From: sajjad aji

To: XL-mania@yahoogroups.com

Sent: Thursday, January 27, 2011 7:46 PM

Subject: ]] XL-mania [[ klasifikasi jenis kelamin ke sheet yang berbeda sekaligus sort by date

 

Selamat sore para master excell, mohon pencerahannya untuk mengklasifikasikan jenis kelamin dari sheet master ke sheet yang berbeda, sekaligus nanti hasilnya di sort by date... Terima kasih atas pencerahannya... Aji (aji_special@yahoo.com)

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 94

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| "if you are the most valuable assets, you will show up on the     |
| balance sheet..." - oNo Wiqe                                      |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___

]] XL-mania [[ penjumlahan mencapai ribuan drawing

 

Dear All XL-Mania,

 

Mohon bantuan dan pencerahan, maaf apabila hal ini udah pernah ditanyakan.

Untuk persoalan seperti terlampir.

Terima kasih.

 

Salam EXCEL

 

 

*********************************

Baju Chris Darmanto

Engineering and Construction Division

Web  : http://www.poeser.com

Email : baju@poeser.com

Telp. : 021-7209664

Fax.  : 021-7209670

*********************************

 

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 94

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| "if you are the most valuable assets, you will show up on the     |
| balance sheet..." - oNo Wiqe                                      |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

---

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___

]] XL-mania [[ Macro dari bawah ke atas...

 

Dear Master exel....

Saya agak sedikit bingung nie bor/ sist....

biasanya dalam bekerja saya pakai macro exel yang ada di
attachment
berikut untuk mengcopy tulisan dari atas ke bawah.

nah sekarang jika copyannya dari bawah ke atas menggunakan macro
berikut ada ga yah?

Terima kasih.

Mohon bantuannya yah master... :)

--
Best regards,
Dewanto mailto:dewanto@falcon.co.id

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic ()

Recent Activity:

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| "if you are the most valuable assets, you will show up on the     |
| balance sheet..." - oNo Wiqe                                      |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___