Log In
Register
Home
December 5, 2016
Offline
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 ?
April 25, 2020
Offline
Probably, or in Power Query.
But without seeing your data it is impossible to say for sure.
December 5, 2016
Offline
Attached please find the workbook sample data.
April 25, 2020
Offline
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.
December 5, 2016
Offline
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
1 Guest(s)
