I have an autofilter applied to a table. The table headers are
Ename Ecode Division Date Project Hours Ccode
I would like a code which would search under all headers and filter out all rows which have either an error condition like NA, REF, VALUE or have a blank cell. The objective is to get rid of all such conditions so it would be just fine if it filters out only the first set of such items. Once corrected, it can look for the next set.
I am uploading a file for ease of testing.