ChuckRobert
Board Regular
- Joined
- Feb 26, 2009
- Messages
- 64
I have a worksheet containing 500 rows of potential data. Data validation list drop-down boxes are used to select assignments which are then referenced by Index & Match to automatically display in other parts of the worksheet as required. Up to 70% of the worksheet contains blank rows, waiting for assignments that may be infrequently assigned.
I need to auto-hide all rows in which the cells in columns D:P each contain "0" or blank "". If a new assignment is set with data validation that puts an assignment in a previously hidden row, I need that row to automatically un-hide.
I looked at Private Sub Worksheet_SelectionChange(ByVal Target As Range) to run a macro process to un-hide rows, but need to consider that many other macros reference/paste to this worksheet when processes are run.
I tried the autofilter which, works great for a particular date (filtering name & assignment - column D:E for Monday), but that hides other assignments that may be set on other days of the week.
I need to auto-hide all rows in which the cells in columns D:P each contain "0" or blank "". If a new assignment is set with data validation that puts an assignment in a previously hidden row, I need that row to automatically un-hide.
I looked at Private Sub Worksheet_SelectionChange(ByVal Target As Range) to run a macro process to un-hide rows, but need to consider that many other macros reference/paste to this worksheet when processes are run.
I tried the autofilter which, works great for a particular date (filtering name & assignment - column D:E for Monday), but that hides other assignments that may be set on other days of the week.