filter non-blanks before closing

[Kevin_apprentice]

hello!

could anyone help me with my problem?
the case is, I want to auto filter the non-blanks of a column (i.e. "A3")
and save it before I close the file....

thanks in advance for your assistance.

 

[Dave Peterson]

I'd start by recording a macro (show all data first????) when I did it manually.

But instead of running the macro before the workbook closes, I'd put it in the
Auto_Open procedure.

Then instead of having to figure out what to do (what happens if the user
doesn't want to save the changes???), the workbook will open nicely.

Record that macro and rename the macro to Auto_open

Then save, close and reopen to test.