p45cal,

Thank you very much, it worked beautifully. Is it possible to get the filtered records (not allowed) in a separate sheet by itself? If not, what you provided is suffice.
Also, at this time no need to filter out 7 days before the H code.

Thank you for the resource links for the power query as I'm not familiar with it before.


Regards,