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? -- 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 |
match and copy data
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 |
match and copy data
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 |
match and copy data
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 |
All times are GMT +1. The time now is 10:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com