IN excel it search should move in both direction like first if it is found text 1 then go from that location then it goes to find say text 25, it copy from that position and if text 12 comes it moves up to search first and then find and copy..... also the data in excel could be limited to 100 or 150.

(this is just for reference as from the link you provided for some other macro support)