I have an Excel file which contains details of all the school students from A to Z. Out of it, in a separate sheet created
FEES DUE FORM for each class that contains only
NAME from APR '14 through MAR '16 in each column to put check mark if a student has paid fees for particular month.
I have to print form for each class separately. I want it to be in the below format -
SCHOOL NAME FEES DUE LIST 2015-16 CLASS : [Here I want to update automatically the class which I filtered.] ROLL NO. Name Apr 15 May 15 Jun 15 ... Mar 16
The rest comes easily in filtering, how to do it?