Is there anyway to automatically filter out blank rows, without having to click the drop down arrow and select "Non-Blank", but still will automatically unhide the rows as information is added to previously emtpy rows, through formulas pulling from other sheets.