Results 1 to 12 of 12

Macro for multiple subtotals

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2015
    Location
    Florida
    MS-Off Ver
    Office 2007
    Posts
    25

    Macro for multiple subtotals

    Hello, i'm in need of some VBA help for an excel macro. I have a macro that takes data from one sheet and moves the relevant/needed data to a second sheet within the same workbook. Once the data is moved to a new sheet, the macro then separates the data based on the date by putting two lines in between each set of data as shown in the attached picture. What I would like to be able to do is subtotal each little group (generally anywhere between 1 and 3 lines) under the hours which is column J and that's where i'm stuck. I have everything else working properly except I am stumped on how to get column J subtotals for each little group to work. Any help would be greatly appreciated!

    sample.JPG
    Attached Images Attached Images
    Last edited by orlex; 10-26-2015 at 04:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add Multiple Subtotals
    By pociners in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-25-2014, 05:12 AM
  2. [SOLVED] subtotals with multiple layers
    By plamb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2013, 02:20 PM
  3. Macro to apply subtotals to multiple sheets
    By Scotbot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2012, 09:10 AM
  4. [SOLVED] Subtotals multiple columns
    By john liem in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] Subtotals multiple columns
    By Gary L Brown in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. Subtotals multiple columns
    By john liem in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. Subtotals multiple columns
    By john liem in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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