PDA

View Full Version : vba-match and copy data



noob
02-08-2006, 10:13 PM
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?

CCkfm2000
02-08-2006, 10:56 PM
hi noob,

why don't you just link the 2 spreadsheets together?

regards

cckfm2000

noob
02-08-2006, 10:59 PM
it is 2 different files..and i'm required to copy the data from one file to another..

noob
02-08-2006, 11:45 PM
anyone able to help me on it?