| 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 |
| 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)
Threaded Mode
