I am working with a large data sample that is in a horrible format. It
includes a lot of rows of data that I do not need, and is in a format that no
simple sorting or filtering will not work to give me just the data I want.

Can anyone help me with some code to delete all rows that do not have "Agt"
or "Agent" in column A? If this is possible I would look for this to happen
in rows 6 through 5000.

Thank you in advance for your help!

Ken