+ Reply to Thread
Results 1 to 4 of 4

Add subtotal to rows based on the format of cells.

  1. #1
    Registered User
    Join Date
    02-19-2004
    Posts
    57

    Add subtotal to rows based on the format of cells.

    HI,

    I have a system generated report.
    Where the subtotal formula should be added, it is in values but bold.
    So using this criteria, I need to add a subtotal formula for each group of data and if possible group the data by rows.

    Please see the attached file to understand what I mean...
    Attached Files Attached Files
    Any help is greatly appreciated

    Josnah

  2. #2
    Forum Contributor
    Join Date
    02-23-2006
    Location
    Near London, England
    MS-Off Ver
    Office 2003
    Posts
    770
    I'm unclear, are the bold rows already there, or do they need to be created and the subtotal forumula added? Both your 'From' and 'To' sheets seem to already have the subtotals?

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello josnah,

    I have added the macro below to your workbook which is attached to this post. The macro does not reset any previous formatting that may exist on the sheet. It simply adds the outlines and subtotals to the existing format.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-19-2004
    Posts
    57
    Hi Leith,

    Its exactly what I needed!
    Thanks a million....

    Josnah

+ 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. Replies: 0
    Last Post: 06-13-2008, 02:19 PM
  2. Copy\Paste multiple criteria based rows to new sheet
    By namz in forum Excel Programming / VBA / Macros
    Replies: 46
    Last Post: 06-06-2008, 08:08 AM
  3. using VBA to hide columns and rows that do not have cells with a specific format
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2008, 05:47 PM
  4. Selecting Cells by the format type
    By kgkev in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2007, 12:19 PM
  5. How do you use a macro to format subtotal rows?
    By Sudheerp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2007, 11:14 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