Thread: 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?

there's so many experts here..
yet no 1 able to help?

Hi,
You could use Data==>Filter ==>Autofilter from Excel toolbar.

Select the columns, and for "Mod" column, click on the arrow, select
"Custom" and in the next message box, in "Show rows where" box value is
"Begins with" and value in the ajoining box is "IT" (no quotes required).
Click OK.

Then copy and paste these selected rows to your new worksheet.

HTH

"new_to_vba" wrote:

>
> there's so many experts here..
> yet no 1 able to help?
>
>
> --
> 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
>
>

Hi
You should use the vlookup function. All you need to do is put Vlookup
formulas in 822.xls for each of Facility----Time-----Day.

How to write Vlookup formulas... You can get many posts on this
topic...
Here is one:

http://groups.google.co.in/group/Exc...8a897b9278e048

Karthik Bhat