+ Reply to Thread
Results 1 to 22 of 22

Dynamic Expanding/Contrasting Groups of Rows?

Hybrid View

  1. 04-10-2025, 06:47 PM #1
    Stasis
    Stasis is offline
    Registered User
    Join Date
    02-24-2014
    Location
    USA
    MS-Off Ver
    365
    Posts
    18

    Re: Dynamic Expanding/Contrasting Groups of Rows?

    Quote Originally Posted by MarvinP View Post
    Hi Stasis,

    I'm added a column A to each of your Groups and changed the formula a bit. In M
    Formula: copy to clipboard 
    =IFERROR(VSTACK(Group1!A2:.K50,Group2!A3:.K50,Group3!A3:.L50,Group4!A3:.K50),"-")

    See if this works for you now..
    With this one, if I change anything on the group sheets the table on the Total page changes to just "-".
    Reply With QuoteRegister To Reply
  2. 04-10-2025, 07:21 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,388

    Re: Dynamic Expanding/Contrasting Groups of Rows?

    Hi Stasis,

    Did you make those "K50"s enough rows to include your real data? Like perhaps "K3000"s?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 04-10-2025, 09:23 PM #3
    Stasis
    Stasis is offline
    Registered User
    Join Date
    02-24-2014
    Location
    USA
    MS-Off Ver
    365
    Posts
    18

    Re: Dynamic Expanding/Contrasting Groups of Rows?

    Yes I did, I went with K1000.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic Array (FILTER) & expanding formulas
    By Red Barracuda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2023, 11:44 PM
  2. Question about pivot data: refresh data without expanding groups
    By marek327 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-10-2022, 03:11 AM
  3. [SOLVED] Dynamic Expanding Table From Another Sheet
    By BillySpivy in forum Excel General
    Replies: 7
    Last Post: 09-09-2021, 08:45 PM
  4. shortcut for expanding/collapsing groups
    By BorisS in forum Excel General
    Replies: 5
    Last Post: 01-11-2017, 11:02 AM
  5. Is there a way to allow for Expanding Groups on a protected sheet
    By Shivaraj3027 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2013, 01:02 AM
  6. [SOLVED] Creating a Dynamic Range that allows for expanding and contracting
    By Mattstudent in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2012, 04:22 PM
  7. Event Macro for expanding/contracting groups not working
    By orktoss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 02:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1