Autofilter when data changes

[Bigmal70]

In the example spreadsheet below, I will be completing the VAT return against row 12 today. When I put todays date in cell E12, row 18 will populate with the details of the next return.

What I want to happen is for the spreadsheet to filter to only show any cells in column B that have a value but I would like this filter to refresh automatically as soon as the values are entered in column E.

Is this possible and if so how?

[bmouse]

Don't think that is possible with autofilter, your best bet is to tick Blanks on and off in filter options to refresh it manually.