+ Reply to Thread
Results 1 to 3 of 3

Add formulae to a subtotal line

  1. #1
    Registered User
    Join Date
    06-30-2009
    Location
    Southern California, Earth
    MS-Off Ver
    Excel 2010
    Posts
    72

    Wink Add formulae to a subtotal line

    I have VBA code that sorts and subtotals some data on my worksheet, and now I want to add formulas to some of the columns that do not have the subtotal function in them. This would be an offset formula to show the cell above, so when it is collapsed you can see the last entry that it is subtotaling without expanding.

    Here is my subtotal code:

    Please Login or Register  to view this content.
    So it sums column B and C on the sheet, and I would like to add my own formula to some of the other columns. Any ideas?


    Thanks in advance!

    Hoffey

  2. #2
    Registered User
    Join Date
    06-30-2009
    Location
    Southern California, Earth
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Add formulae to a subtotal line

    After thinking about it, I suppose I could make a loop that looks at column C and if the formula is equal to SUBTOTAL then paste the appropriate formulas on the adjacent cells. I will work on that for now and see if there are better solutions...

  3. #3
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Add formulae to a subtotal line

    Hi hoffe

    A sample file of what you have (including code) and what you'd like it to be would be helpful.

    What formulas where?
    I would like to add my own formula to some of the other columns
    John
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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