i have 2 files, Information.xls & 822.xls,
i need to copy the specific set of data under the row that contain the
texts "IT" in 822.xls, it will first search for all the columns or
rows that contain any texts with "IT", example "IT1122", "IT2312"
after finding the rows with the text "IT" it will then copy the all
data under "Facility" and "Remarks" of the row of "IT" and
copy the data into another file called Information with the same texts
containing "IT" under the same row that has the texts "Facility" and
"Remarks". it has to match, as in, when it copy the data from the text
"IT1122" from 822.xls and it will paste onto "IT1122" in
Information.xls.

this seems impossible, i tried my best but i still can't get it
done..it's too complicated and too many matching of data has to be done
in the function..
need advise!


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=509622