I have a tab in an excel file that is an out report with multiple sections (vertically stacked). Each of these sections have several blank rows at the bottom of it (just a function of needing space for my index match to pull in new information into the appropriate section as the detailed database is updated.
Currently I need to group and hid these blank rows at the bottom of each section manually so that the report is presentable without a bunch of blank space. I am hoping to automate this so that excel know which rows to automatically group or ungroup based on the condition of having info in the cell (really would be len>0 since these rows do have fomulas in them but just no text). Regardless, any ideas of how to use auto outline or any other functionality that I am unaware of would be super helpful!
Bookmarks