In the attached there's a table which lists only the disallowed entries with their respective H0004 entry. Blank dates have been completely ignored since there's no way of knowing whether they're in the seven day limit or not.
Currently it only returns disallowed entries after the H0004 dates, but I can tweak it to include within seven days either side if you want.
All you need to do is refresh (right-click and choose Refresh) the table at cell L1 each time the data in Table1 changes.
|