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 -

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?

  • Can you rewrite what you want more clearly? You may use screenshot or upload an example file for easier understanding – Bilo Jun 26 '15 at 3:22
  • If you can’t post screenshots, type in representations of your sheets, as was done here and here. – Scott Jun 26 '15 at 8:50
  • What would be helpful would be representations of the input data and the output data, not just the headers.  You don't need to post actual sensitive data — in fact, please don't — just make up fake data, like Andy, Barbara, Charlie, Debbie, etc. – Scott Jun 26 '15 at 9:15

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.