0

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 ROLL NO., 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?

G-Man Says 'Reinstate Monica'
  • 8,029
Benjamin
  • 1

1 Answers1

0

I would combine all your separate Class sheets into a single Table on a single sheet, with an added column for Class.

Then you can use the table filter buttons to filter by class.

The single table also makes it easy to generate other reports eg by student, or by any other available column.

Mike Honey
  • 2,632