Hello,
I'm working on a Excel document that automatically inserts formulas. In the attachment you can find an explanation (click here). I just started using VBA-codes and I can't find any solution for my problem.
I already found some VBA-codes that automatically insert the SUM formula at the end of a column, but I don't know if it's possible to insert multiply SUM formules in the same collum.
So my question is:
"Is it possible to create a VBA-code that inserts multiply SUM formulas in the same column with a dynamic range? I already have seen this solution but that only inserts a SUM formula at the end of the cells."
(If it's possible):
(1) Insert SUM formula to calculate the total of all subtotals;
(2) Insert multiply SUM formulas to calculate the subtotals;
(3) Insert an formula to calculate the total of one activity.
Keep in mind that the location of each cell in the column changes every time.
Thank you in advance!
I'm working on a Excel document that automatically inserts formulas. In the attachment you can find an explanation (click here). I just started using VBA-codes and I can't find any solution for my problem.
I already found some VBA-codes that automatically insert the SUM formula at the end of a column, but I don't know if it's possible to insert multiply SUM formules in the same collum.
So my question is:
"Is it possible to create a VBA-code that inserts multiply SUM formulas in the same column with a dynamic range? I already have seen this solution but that only inserts a SUM formula at the end of the cells."
(If it's possible):
(1) Insert SUM formula to calculate the total of all subtotals;
(2) Insert multiply SUM formulas to calculate the subtotals;
(3) Insert an formula to calculate the total of one activity.
Keep in mind that the location of each cell in the column changes every time.
Thank you in advance!
