+ Reply to Thread
Results 1 to 3 of 3

Sort and Hide Unused Array Values

  1. #1
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Sort and Hide Unused Array Values

    I have an input page: Machine Spec and an output page: Summary which when someone types lines into the Machine Spec page, it is sent to the summary page for easy viewing.

    I have the Summary page simply setup to = cells in the input page and conditional formatting to hide cells that aren't used. When this happens, there appears to be random blank cells (to the person viewing the Summary).

    What I thought of doing is taking these two ranges - Electrical Summary and Mechanical Summary - and sort them based on whether or not the cell is blank. If it's blank, it will be sent to the bottom of the list to be hidden (hide the entire row if it's blank), otherwise, it will be sent back to its original place in the array.

    I know that these cells are merged and they can be un-merged for the sake of sorting the array.

    Does anyone have an idea as to how to accomplish this task (or is there perhaps an even better method to use than what I'm thinking of)?

    The yellow cells on the summary are what I'm calling my 'Array'. They are mostly driven by cells in the input sheet as well as some cells in the Formulae sheet.

    Thanks!

    SummarySheet.xlsm
    Nothing is absolute - a paradox in itself.

    Indirect Dynamic Data Validation (scroll to the bottom of the page)

  2. #2
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Sort and Hide Unused Array Values

    I'm still at a loss on this one.

  3. #3
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Sort and Hide Unused Array Values

    Is no one sure on how to do this or is it so simple that it's not worth mentioning?
    I've tried to use Excel's built in Sort command, but when I do it messes up my formulas and named ranges somehow. Is this an isolated issue?
    If I can get Excel to sort the columns for me, I could then simply hide the blank rows at the bottom of the array and it would be done.

    After doing that, I'd like to be able to prioritize certain cells in some way to always be in a specific order (based on the item in the cell). I thought about adding a numerical value in front of the word and making it white, but the upkeep on that would be atrocious if I ever planned to change the order on any given cell.

+ 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