I'm quite new to VBA so bare with me...

I'm looking for a macro that will find a piece of text (A1234) in another .xls file, call it "FILE2". I want the macro to check just the A column in "FILE2" and when "A1234" is found to copy the whole row to the file with the macro, "FILE1".

Can someone help me get it working?