+ Reply to Thread
Results 1 to 2 of 2

Show/Hide rows

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 365
    Posts
    295

    Show/Hide rows

    I have searched the archives here, but not found what I'm looking for.
    I am working on a CPM (Critical Path Management) project.

    The sheet will consist of many tasks and many more subtasks. I would like to be able to show/hide the subtasks at will just as in Windows Explorer.
    I would also need to be able to add and delete both tasks and subtasks and still have it work.
    Ideally, it would have the plus/minus sign that everyone is used to at each main task.
    I have looked at Data Groups but I think that will be too confusing for some of the users.

    Column A is where I would put this. I could change the format in the ID column if that would make a difference.

    Thanks,

    Len Silva

    I feel like someone must have already done this as it would be a very useful app, but I haven't found it.cpmtest.xlsm

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Show/Hide rows

    I believe the app you are looking for is Microsoft Project. It will look at a project's tasks and identify the critical path. It has the +/- expansion. It 'works' when tasks are added and removed. While Project has its complexities, trust me, spend the money and buy the correct tool. I have seen too many people (including myself) trying to shoehorn Excel into this type of role. It never quite works except for the most simplistic of models. You could also google 'MS Project Alternatives' and look at some free trials (such as LiquidPlanner), but I have never used them.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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. Hide and show rows
    By etunges in forum Excel General
    Replies: 2
    Last Post: 07-13-2011, 09:19 AM
  2. Hide Rows/Show Rows - Check box
    By Audsmom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2011, 03:02 AM
  3. Dropdown to hide/show rows
    By paxile2k in forum Excel General
    Replies: 8
    Last Post: 01-07-2010, 01:27 PM
  4. Hide Rows - copy and paste only rows that show
    By Access101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2006, 08:50 PM
  5. [SOLVED] Hide and show Rows
    By Duane in forum Excel General
    Replies: 2
    Last Post: 04-19-2005, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1