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
Bookmarks