+ Reply to Thread
Results 1 to 2 of 2

*** Copy sub section total value to main section***

  1. #1
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    Thumbs up *** Copy sub section total value to main section***

    Hi All,


    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.
    Attached Files Attached Files

  2. #2
    Spammer
    Join Date
    06-27-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    183

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] sort a section if cells in section contains certain values
    By vitaudi in forum Excel General
    Replies: 9
    Last Post: 10-08-2014, 03:15 AM
  2. Hide a section based on the click of a box in the beginning of the section
    By schmidt1962 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 04:51 PM
  3. Checkbox in one section triggers NA in other section
    By dickep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2014, 04:06 AM
  4. Replies: 1
    Last Post: 06-16-2013, 07:36 AM
  5. Deleting Row Section without Disrupting Formula Range Outside of Deleted Section
    By JeffNYG23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2013, 09:10 AM
  6. Moving section headings from below section to above section..
    By Fayebaline in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-24-2011, 06:58 AM
  7. move that Row From the Waiting section to the completed section automaticly
    By jjsaw5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2007, 06:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1