Make a simple report with VBA

[Rayman]

A formula can be used. In cell C2 of Report, insert this formula and then copy it down.


This formula is explained in great detail by XLD in the sub-forum SUMPRODUCT formula.

On second thoughts: You can use Pivot Table also.

Thanks for reply, but the attached file is only an example.
In my working workbook i have several sheet, with variable name from wich take the data. The user also can delete or add new sheet with new variable name to my workbook....

Good evening