Can we use Macro to create each Calculation Table base on Power consumption voltage for each Factory then summarize the Power consumption costs into a summary Table ?
Probably, or in Power Query.
But without seeing your data it is impossible to say for sure.
Attached please find the workbook sample data.
Sorry, but based on the mass of data scattered all over the place for each Factory and your explanation in your opening post I cannot work out what it is you want.
So I will pass on this.
Hopefully, somebody else will understand what it is you want to do and will be able to help you.
Simply I want to put the result [ after calculation] for each factory into a Summary Report by Macro.
i.e put $6,900 and $7,675 into a summary report
Factory 1
50,000 @ 10% 5,000
25,000 @ 7.5% 1,875
1,000 @2.5% 25
Total costs $6,900
Factory 2
50,000 @ 10% 5,000
35,000 @ 7.5% 2,625
2,000 @2.5% 50
Total costs $7,675
