Search between sheets and create reports

[Konexcelmath]

Hello, in the attached file is my question.

The problem? I have a workbook with months of a year. The months starts from September until next August. The sheets names are 09_14, 10_14 .... 08_15
In every month sheet i have the same template as you will see.
What i want is 3 types of reports:
1. Search between months (start - end) a specific name, and the result should go to a sheet named report.
2. In every sheet some names have a specific grade (AA, BB). Search for all AA or BB between months (start - end) and the result should go to a sheet named report.
3. I have a sheet Year. That add every month the sums of every month sheet. I want to Search between months (start - end) and the result should go to a sheet named report.

Maybe the attached file will help you.
I appreciate for every help.

Thanks a lot for your time

[oeldere]

I ran the macro below to get all data on 1 sheet.

After that a pivot table (an example)

See the attached file.

Please reply.

Please Login or Register  to view this content.

[Konexcelmath]

Thanks for the reply and for the time you spent to create the macro.
What i have in mind dose not use a pivot table.
As you see in the attach file, i would prefer a specific type of reports, using input boxes.
Can be change to use input boxes and create 3 separate reports as in the attach file.

[oeldere]

Please Login or Register  to view this content.

as always I am curious why such a report (and not a pivot table)?

[Konexcelmath]

I need this kind of report because it is easier for the people that i need it to understand it.
So please for your help!!

[oeldere]

Please Login or Register  to view this content.

I understand.

In that case I think a pivot table is more reliable (and easier to change) than "complex" formula.

One day you will be glad I pointed you on using a pivot table.

So try it, and if you get in trouble with it, let me know.

If you want a formula, I let it to other forummembers.

[Konexcelmath]

Please any help????