+ Reply to Thread
Results 1 to 4 of 4

How to automatically exclude a row from a nested group once populated

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question How to automatically exclude a row from a nested group once populated

    Hi All,

    I have a worksheet that contains the same 50 rows pasted several times down the sheet and each bank of rows contains a new piece of data. The reason that each new type of data can't be stored in columns is because we use columns to track performance over time

    For a brief idea:

    NET INCOME Month 1 Month 2 Month 3.... etc.
    Property A
    Property B
    Property C
    ...
    Dummy Property
    Dummy Property
    Dummy Property


    OCCUPANCY Month 1 Month 2 Month 3.... etc.
    Property A
    Property B
    Property C
    ...
    Dummy Property
    Dummy Property
    Dummy Property



    We are keeping several rows free for the future when new properties may be added to the portfolio. But for the time being, they don't have names, and visually they're getting in the way. I've been using 'groups' to hide the unwanted dummy property rows, but when the day comes that we add a new property to the portfolio, I don't want to have to manually resize all the groups to the fewer number of rows. That is to say, I want to see data when the row is populated, but I want to hide (by means of a group) all the excess rows when they're blank.

    Can you think of a way that, when we give one of the dummy property lines a new name and some data, it will remove it from the group and keep it visible with the rest of the existing properties?

    Any advice would be greatly appreciated!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,915

    Re: How to automatically exclude a row from a nested group once populated

    Hi, welcome to the forum

    Have you considered using filters instead? You could filter out all the blank rows, and it is pretty quick/easy to undo and reapply
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Thumbs up Re: How to automatically exclude a row from a nested group once populated

    Brilliant! Thank you Ford!

    I'm kicking myself...this is a classic case of "Why didn't I think of that?"

    Simple, easy and does exactly what I need it to do. For anyone else this may help in the future, I've applied a simple text filter to exclude anything containing the string 'Dummy Property'. But there are a few other filters I could apply to achieve the same thing.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,915

    Re: How to automatically exclude a row from a nested group once populated

    Always work on the KISS principal

+ 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] Automatically populated according to time intervals
    By andregon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2015, 05:05 AM
  2. How to add auto number and date automatically when new row populated
    By naylak in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2014, 08:49 AM
  3. [SOLVED] Exclude Zero's from Min Function nested inside an index+Match... all within CELL funtion
    By clemsoncooz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2014, 05:16 PM
  4. Moving cells down when row above is automatically populated.
    By M144HAD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2013, 11:55 AM
  5. Can I exclude the first populated value in a row in a pivot table
    By robertt364 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-12-2013, 05:41 PM
  6. How do I keep a range automatically populated with a formula?
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2010, 03:11 PM
  7. [SOLVED] Having data automatically populated in a different sheet
    By Nicki in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-13-2006, 08:30 PM

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