ada gak mbak misalkan dibikin macro yang sudah lunas bisa langsung ter cut-paste ke workbook khusus data lunas
mtur nuwun Pada 4 Agustus 2011 14:44, Haps <[email protected]> menulis: > ** > > > Siapkan workbook . sheet baru yg strukturnya sama dengan workbook data anda > mungkin perlu diberinama BackupDataLunas > > Jika di workbook lama belum ada kolom untuk membedakan status RECORD sudah > LUNAS > /BELUM, buatlah kolom baru, diisi rumus yg berkemungkinan menghasilkan > hanya dua data > ( FALSE dan TRUE, atau (blank) dan LUNAS) > > Berdasarkan kolom tsb Tabel disort (dengan maksud agar RECORDS (baris-baris > data) > yg sudah berstatus LUNAS "mengelompok / tidak terpecar, gampang > diSelect/Diblok > > Baris-baris yg berstatus lunas di-CUT lalu di- PASTEkan ke workbook baru > (BackUpDataLunas) > > > > > Reply to > sender<[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20WTA%3B%20mengeluarkan%20data%20tertentu%20supaya%20tidak%20ikut%20ke%20bulan%20berikutnya>| > Reply > to > group<[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20WTA%3B%20mengeluarkan%20data%20tertentu%20supaya%20tidak%20ikut%20ke%20bulan%20berikutnya>| > Reply > via web > post<http://groups.yahoo.com/group/belajar-excel/post;_ylc=X3oDMTJycmoyODdjBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMxMjMxNwRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMTI0NDM4OTE-?act=reply&messageNum=12317>| > Start > a New > Topic<http://groups.yahoo.com/group/belajar-excel/post;_ylc=X3oDMTJmYjFob2lyBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzEzMTI0NDM4OTE-> > Messages in this > topic<http://groups.yahoo.com/group/belajar-excel/message/12286;_ylc=X3oDMTM3a2p2ZjJxBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAMxMjMxNwRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMTI0NDM4OTEEdHBjSWQDMTIyODY->( > 2) > Recent Activity: > > - New > Members<http://groups.yahoo.com/group/belajar-excel/members;_ylc=X3oDMTJnOGZiZWNuBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxMzEyNDQzODkw?o=6> > 15 > > Visit Your > Group<http://groups.yahoo.com/group/belajar-excel;_ylc=X3oDMTJmbWlodnF1BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEzMTI0NDM4OTA-> > --------------------------------------------------------------------- > 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] > --------------------------------------------------------------------- > [image: Yahoo! > Groups]<http://groups.yahoo.com/;_ylc=X3oDMTJlYjhrYzc4BF9TAzk3NDc2NTkwBGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTMxMjQ0Mzg5MQ--> > Switch to: > Text-Only<[email protected]?subject=Change+Delivery+Format:+Traditional>, > Daily > Digest<[email protected]?subject=Email+Delivery:+Digest>• > Unsubscribe<[email protected]?subject=Unsubscribe>• > Terms > of Use <http://docs.yahoo.com/info/terms/> > . > > >
