I need some help cleaning up an imported document. Right now, each employee
appears numerous times, and I need to condense it to one row per employee.
All of the information - barring one piece - already appears on one row.

Here is what I know:

Column A: contains the employee name (already sorted)

Column B: determines the validity of the row. A lot of gibberish (left
over from headers, page breaks, etc) is included in this report, but the one
thing that I can rely on is that if "Bldg. A", "Bldg. B", OR "Bldg. C"
appears in column B, then this is the row that contains most of the employee
data and must not be deleted. I'll call this "MySaveRow".

Column E: the problem child - may or may not include data that must be
saved. For each employee in column A, if column E of MySave row is Null,
then I can quit looking and go to the next employee. If E is not Null, then
I need to see if it contains "FUL", "PR4", "MGR", OR "CON" . If one of
those is found, I would like column F of MySaveRow to be written to. For
example, if "FUL" is found, I would like column F of MySaveRow to say:
"Full time", if "CON" then "Consultant". If E is not Null but does not
contain "FUL", "PR4", "MGR", OR "CON", then I need to keep checking for
those in each row until I get to the next employee. They won't
necessarily be found.

Once I capture any required information from Column E and place the text
remark in column F of MySaveRow, then anything that is not MySaveRow should
be deleted.

Any help *greatly* appreciated!

Patti