Terima kasih Pak, Saya akan belajar satu persatu macronya. Nanti saya kabarkan hasilnya.
kalau ada masalah akan saya tanyakan lagi. Regards. _Mansor ============================================== mods note: Footers & Quoted mail terlalu banyak/panjang, jadi di-edit /cut oleh moderator.. jika pembaca ingin melihatnya kan bisa membaca posting sebelumnya Mengenai Footer & quoted mail ada peraturannya di milis ini (mohon buka lagi peraturan milis) (=diharapkan diquote di bagian yg penting saja) =============================================== 2011/12/2 jkssxls Sudarsono <[email protected]> > coba gunakan koding ini : > Option Base 1 > Sub testing() > End Sub > > Sub hilangkantambahan(MyArray, posisikey) > End Sub > > Sub TambahanZZ(MyArray, posisikey) > End Sub > > Sub SimpanKetujuan(MyArray, Tujuan As Range) > End Sub > > hasilnya : > > No Transaction Date(yyyymmdd) Doc Type Reference No. Posting Key (PK) Acct > No Amount (USD) Remarks 20111118 MM 2011/250 25 140,273 TOTAL > for 18/11/2011 20111118 2011/250 31 2,850 DEPOSIT > BRANCH ABC NOT POSTED 16/11/2011 20111118 2011/250 31 5,294 > DEPOSIT BRANCH BBB NOT POSTED 10/11/2011 20111118 2011/250 31 > 132,129 NORMAL TRANSACTION 18/11/2011 20111118 ZZ 2011/250 25 > 140,273 TOTAL for 18/11/2011 20111118 2011/250 50 140,273 TOTAL >--- dst --- ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
