Within your macro you could set up a filter on column E, choose the
criteria, then Edit | Delete Row and remove the filter. You could
record a macro while you do this manually (to get the syntax), then
copy it over to your other macro.

Hope this helps.

Pete