Hello All,

I was wondering if it was possible to read a text input file and compare
that list to see if it exists in excel. If it does, can we highlight the
entire row. This way, I can delete the un-lighted rows. The row that we
want to compare or match is in Column A.

Example:

Text Input file:
---------------
OR-MyTestfile
OR-StateofUnion
OR-WhereAreYouFrom

Excel Spreadsheet
--------------------
A B C
D
1 OR-MyTestFile FileName Location Size
2 OR-YourNameIs FirstName EastWing 10mb
3 OR-StateofUnion WhichState City Zipcode
4 OR-HowOldAreYou Age DOD Year
5 OR-WhereAreYouFrom Born Date Time

With the above example, the following ENTIRE ROW if possible, would be
highlighted (1,3,5)

Side note:
The Input text file is created by manually extracting those names from
muttilple sources.

End Results:
Only keep those rows that are highlighted

Any and all help in this matter is greatly appreciated.