*** 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.
Re: *** Copy sub section total value to main section***
One more information.
Number of section may increase or Decrease hence it is not only limited to 4 section.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By vitaudi in forum Excel General
Last Post: 10-08-2014, 03:15 AM
By schmidt1962 in forum Word Programming / VBA / Macros
Last Post: 09-25-2014, 04:51 PM
By dickep in forum Excel Programming / VBA / Macros
Last Post: 06-04-2014, 04:06 AM
By jlt01 in forum Excel Charting & Pivots
Last Post: 06-16-2013, 07:36 AM
By JeffNYG23 in forum Excel Programming / VBA / Macros
Last Post: 03-14-2013, 09:10 AM
By Fayebaline in forum Excel Programming / VBA / Macros
Last Post: 02-24-2011, 06:58 AM
By jjsaw5 in forum Excel Programming / VBA / Macros
Last Post: 06-21-2007, 06:50 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1