| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to copy and match data from one workbook to another workbook | Excel Worksheet Functions | |||
| copy data for match word from one file to another file | Excel Worksheet Functions | |||
| Find match between cells and copy data | Excel Worksheet Functions | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| how to copy old price data onto new stock list if match exists? | Excel Discussion (Misc queries) | |||
![new_to_vba[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
