*** Copy sub section total value to main section***
I have a data in which there are number of section and sub section values are given.
Requirement is values of sub section need to be added with (main) Section to arrive grand total.
Example in the attached data Column B is Section A and Column C is Sub section A. Total value of subsection A (C14) to be copied to Section A (B15) and then Grand total to be calculated.
Points to be considered
• Need to find out sub section column is available or not against section
• If available total of sub section to be copied to section column (in row 15)
• Grand total to be calculated.
• If no subsection, Sub value (row 15) will became “0”
Plz help with VBA code, in case of any query revert back.