-
vba-match and copy data
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?
-
hi noob,
why don't you just link the 2 spreadsheets together?
regards
cckfm2000
-
it is 2 different files..and i'm required to copy the data from one file to another..
-
anyone able to help me on it?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules