RE: ]] XL-mania [[ nama jurnal

[hisjam]

Di sheet daftar perkiraan dibuatkan 1.       block A4 s/d b11 di sheet daftar perkiraan 2.       bernama dengan melakukan insert name define. Contoh : COA 3.       buat rumus vlookup di sheet jurnal. Contoh cell C5. =VLOOKUP(C5,COA,2)   Kendalanya : 1.       Jika ada penambahan harus di urutkan kembali 2.       Di blok ulang 3.       lakukan insert name define kembali   Mungkin XL Mania ada yang punya cara yang lebih mudah     -----Original Message----- From: XL-mania@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of putri patricia Sent: Thursday, May 25, 2006 10:59 AM To: XL-mania@yahoogroups.com Subject: ]] XL-mania [[ nama jurnal   Mohon bantuan buat para xl mania,   gimana caranya kalo kita ketik kode perkiraan, maka otomatis nama perkiraan akan langsung muncul?   Tolong dibantu yah, ini saya lampirkan contoh datanya                           --------------------------------- Apakah Anda Yahoo!? Kunjungi halaman depan Yahoo! Indonesia yang baru!   ------------------------ Yahoo! Groups Sponsor --------------------~--> You can search right from your browser? It's easy and it's free.  See how. http://us.click.yahoo.com/_7bhrC/NGxNAA/yQLSAA/FJp0lB/TM --------------------------------------------------------------------~->   +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | 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  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ Yahoo! Groups Links   <*> To visit your group on the web, go to:     http://groups.yahoo.com/group/XL-mania/   <*> To unsubscribe from this group, send an email to:     [EMAIL PROTECTED]   <*> Your use of Yahoo! Groups is subject to:     http://docs.yahoo.com/info/terms/   +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | 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  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ SPONSORED LINKS Microsoft excel Microsoft business solution Microsoft excel help Microsoft small business manager Microsoft excel training YAHOO! GROUPS LINKS  Visit your group "XL-mania" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.