Ok I tried doing this on my end, tried looking it up, tried other posts on this site and can't find what I need...so coming to you!
I have a data table that has slicers. When I select the Client and category in the slicer I am after, my equation in cell AW9 automatically updates. This data table has the details of all clients and all projects. After I click on my Client slicer, I narrow this down to a single client. This changes the value in Cell AW9 to TRUE. As soon as my data table is showing more than one Client's name, AW9 changes to FALSE.
This data table then is linked to a condensed summary table. In column A I have an equation that once again shows either TRUE or FALSE. If any Cell in the range A10:A1000 shows TRUE, I need the entire row to show (unhide). If any cell in Column A from A10:A1000 shows FALSE, I need that entire row to be hidden.
This macro needs to run every time AW9 changes.
Quick Recap - auto run macro when AW9 changes. if AW9 is.....
AW9 = TRUE --> unhide each row between 10:1000 where the value in column A is TRUE
AW9 = FALSE --> unhide all rows between 10:1000
THANK YOU SO MUCH IN ADVANCE
I have a data table that has slicers. When I select the Client and category in the slicer I am after, my equation in cell AW9 automatically updates. This data table has the details of all clients and all projects. After I click on my Client slicer, I narrow this down to a single client. This changes the value in Cell AW9 to TRUE. As soon as my data table is showing more than one Client's name, AW9 changes to FALSE.
This data table then is linked to a condensed summary table. In column A I have an equation that once again shows either TRUE or FALSE. If any Cell in the range A10:A1000 shows TRUE, I need the entire row to show (unhide). If any cell in Column A from A10:A1000 shows FALSE, I need that entire row to be hidden.
This macro needs to run every time AW9 changes.
Quick Recap - auto run macro when AW9 changes. if AW9 is.....
AW9 = TRUE --> unhide each row between 10:1000 where the value in column A is TRUE
AW9 = FALSE --> unhide all rows between 10:1000
THANK YOU SO MUCH IN ADVANCE