terima kasih, sdh ada 2 pilihan hehehe...
----- Original Message -----
From: ghozi alkatiri
To: belajar-excel@yahoogroups.com
Sent: Wednesday, October 24, 2012 12:30 PM
Subject: Bls: [belajar-excel] cetak laporan peserta...
formula pertama ditulis di A2
=IF(OR(MOD(ROW(1:1);6)=0;MOD(COLUMN();3)=0;TRUNC((COLUMN()-1)/COLUMNS($A:$C))+1+3*TRUNC((ROW(1:1)-1)/ROWS($A$2:$A$7))+$B$1-1>MAX('Data
Awal'!$A$4:$A$53));"";IF(MOD(COLUMN();COLUMNS($A:$C))=1;INDEX('Data
Awal'!$A$3:$F$3;MOD(ROW(1:1)-1;ROWS($A$2:$A$7))+1);IF(MOD(COLUMN();COLUMNS($A:$C))=2;INDEX('Data
Awal'!$A$4:$E$53;TRUNC((COLUMN()-1)/COLUMNS($A:$C))+1+3*TRUNC((ROW(1:1)-1)/ROWS($A$2:$A$7))+$B$1-1;MOD(ROW(1:1);ROWS($A$2:$A$7))))))
copy ke kanan dan ke bawah.
pemberian border menggunakan conditional formating (bisa dilihat di attachment
page setup tergantung computer dan printer dari masing masing pemakai.
wassalam
Ghozi Alkatiri
------------------------------------------------------------------------------
Dari: rey <personalia_manado@ag. co.id>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 23 Oktober 2012 11:06
Judul: [belajar-excel] cetak laporan peserta...
hai, master....
Mohon bantuannya...
di sheet data awal ada kolom kategory mewarnai dan menggambar ( aku coba pake
=IF(D4<3;"MEWARNAI";"MENGGAMBAR") ternyata TK sama PAUD ngga masuk....
disheet cetak.....maunya aku cetak sekalian dalam 1 halaman ada 30
nama....setelah dicetak aku panggil lagi nama yang ke 31 dan seterusnya...bisa
ngga?
mohon bantuannya...
tq
Rey
PT. BANK ARTHA GRAHA INTERNASIONAL TBK. 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 notify
the system manager. This message contains confidential information
and is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on
the contents of this information is strictly prohibited.
PT. BANK ARTHA GRAHA INTERNASIONAL TBK. 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 notify
the system manager. This message contains confidential information
and is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake and delete this e-mail from your
system. If you are not the intended recipient you are notified that
disclosing, copying, distributing or taking any action in reliance on
the contents of this information is strictly prohibited.
