I have 3 worksheets within my Excel file. Missing (25,000 rows), Valid (18,000 rows), and Matched (blank).
I need to compare the values in column D of Missing and Valid and copy all the rows of all the matches to the Matched sheet.
If I can somehow do a wildcard search with this that would be nice too, for example a way for ABBOTT LABORATORIES to match ABBOTT LAB. If that isn't possible, then if there is a way to highlight the rows that have been matched so I can manually find the wildcard matches would be very appreciated.
Bookmarks