Hai Cliff, Kelihatannya pake PivotTable lebih fleksible - kolom tanggal diberi judul kolom "Tanggal" - Buat kolom bantu untuk kelompok A dan kelompok B (pake judul kolom) - Buat report dengan PivotTable (rangenya termasuk judul kolom).
Jika belum berhasil coba kirim hasil uji cobanya. Salam, HK ________________________________ From: Cliff <cliff.su...@gmail.com> To: belajar-excel@yahoogroups.com Sent: Tuesday, 25 June 2013, 0:13 Subject: [belajar-excel] Laporan Dear Masters/B-excelers,**** ** ** Mohon bantuannya, seperti terlampir, saya sering buat laporan �Total Produk 1&2� dan laporan gabungan secara manual.**** Kira2 ada gk cara yang lebih mudah?**** ** ** Saya juga mau kaos b-excelers J, ada Bank mandiri kah?**** Materi KOPDAR#1 juga, CD-nya bisa dapat dimana? Mudah2an bisa ikut KOPDAR edisi #2 ;)**** ** ** Makasih banyak. Sukses terus untuk para master.**** ** ** Salam,**** Cliff**** ** ** ** ** ------------------------------ DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please let us know by email reply and delete it from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Konkola Copper Mines plc. Finally, the recipient should check this email and any attachments for the presence of viruses. Konkola Copper Mines plc accepts no liability for any damage caused by any virus transmitted by this email.
