Hiding Row when column is completed

Vivecat:

I suggest setting up a macro to "refresh" your filtered list whenver you close the workbook. I used the following:

Please Login or Register  to view this content.

Right-click on any tab and choose "view code"
Right-click on the filename for your spreadsheet and choose insert-module.
Paste in the above code

NOTE - My filtered list was in A:B. Column B was the one where I wanted it to filter everything that wasn't (blank). You will need to modify the above code slightly to fit your situation

NOTE2 - Because the macro is called "Auto_Close" it will, by default, run when you close Excel.