i have 2 files, Information.xls & 822.xls,
below are the sample data of the following 2 files,

-----------------------822.xls----------------------------
Mod--------Descrip------------------------------Facility----Time-----Day

IT1122-----Object Oriented Programming----------LTQ-9-----9.00am--Wed

IT2233-----Excel Programming--------------------LTQ-6-----1.00pm--Tues



----------------------Information.xls----------------------
Mod--------Descrip------------------------------Facility----Time-----Day

IT1122

IT2233


the program will look for all the Mod that contains the text "IT" and
then it will copy all the data under the Column "Facility", "Time",
"Day" which are "LTQ-9", "9.00am", "Wed" and paste into Information.xls
under the same "IT1122" under the Column "Facility", "Time", "Day"

any idea how to get it done?


--
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=510440