+ Reply to Thread
Results 1 to 2 of 2

Modify Subtotals to apply to 3 columns in dynamic, filtered table

  1. #1
    Registered User
    Join Date
    02-03-2017
    Location
    SE Texas
    MS-Off Ver
    2013
    Posts
    98

    Modify Subtotals to apply to 3 columns in dynamic, filtered table

    Below (hopefully showing as an attachment??) is my starting point to show subtotals (for cells in columns C, D and E that may or may not contain a letter "X") on changes in column A in a table that is run from another worksheet. The following code has been my starting point but no matter what parameters I change, I don't seem to impact the resulting table very much or get caught in an endless loop.

    Any ideas are appreciated. (Apologies if the "attached" is not showing up that way as I am new to forums such as this.)

    Please Login or Register  to view this content.
    Last edited by JoeVanGeaux; 02-09-2017 at 06:40 PM. Reason: Another attempt to properly display/attach code

  2. #2
    Registered User
    Join Date
    02-03-2017
    Location
    SE Texas
    MS-Off Ver
    2013
    Posts
    98

    Re: Modify Subtotals to apply to 3 columns in dynamic, filtered table

    UPDATE: I did make some progress by disabling a Private Sub that was restricting only one cell under columns C,D and E in any given row to contain a value. (I'd even appreciate a little help with posting this code like it should be. I managed to muffed that up as well!)

    If the above code can be made to SubTotal columns C,D and E, on changes in Col. A, that would be great!

+ 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] Limit columns to be filtered in a table
    By digita in forum Excel General
    Replies: 2
    Last Post: 08-09-2016, 08:43 PM
  2. VBA code to hide filtered columns (simple table 5 rows / 6 columns wide)
    By e2010 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 02:41 PM
  3. Replies: 1
    Last Post: 10-04-2013, 05:54 PM
  4. [SOLVED] Dynamic Table Range, Dynamic Columns
    By bimo in forum Excel General
    Replies: 6
    Last Post: 06-24-2013, 08:16 AM
  5. Replies: 4
    Last Post: 11-19-2012, 09:16 AM
  6. Apply color code to only 3 columns of filtered range
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2009, 11:10 AM
  7. Apply RANK formula to dynamic table
    By saabman in forum Excel General
    Replies: 2
    Last Post: 09-19-2007, 02:21 AM

Tags for this Thread

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