I have about 30 rows that I would like to conditionally format such that only rows that are populated with values appear. The items in these rows change dynamically as you select different categories contained in a drop down box.
More specifically,
I want to hide those rows from row 54 to row 83 that do not contain a value in column F (F54:F83) on my worksheet called Summary.
I have never created a VBA macro. Any help?
Thx!!!
Bookmarks