Customers now have such demand, excel is used to implement automatic display column values, and then according to the different total value computed columns and rows,
Specific as follows:
Given two time points, a cell memory start time: 3/20/2015, a cell memory over time: 12/15/2016, August every year is a fiscal year, so according to this date range, generate excel is as follows:
Mar - 15 Apr - 15 May to 15 Jun - 15 Jul - 15 total 15 Aug to 15 Sep 15 Oct 15 Nov - Dec - Jan 15-16 Feb 15-16 Mar - Apr 16 - May 16-16 Jun 16 Jul - 16 - Aug - 16 total of 16 Sep - 16... Dec - 16

Generated as the column, the left and some fixed line, for each row after the input, the total column value automatically calculate and,

CodePudding user response:

Oneself the top, because no vba, so not sure if this can use vba, customers are not sure, hope will can guide the vba classmates, thank you!!!!!!!!!!!!!!!!!!!

CodePudding user response:

I can only say: can do, whether vba yourself or vb...

CodePudding user response:

B: yes, you can
Don't use the SUM is ok