|re: "containing similar alpha numeric codes"|
Containing simlilar alpha numeric codes or containing matching alpha numeric codes?
Those are 2 very different things.
re: "either extract or highlight the whole row in spreadsheet 1"
Do you really want to highlight the "whole row"? All 256 cells in the row?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.