| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a specific of data of texts containing "IT"
i have 2 files, Information.xls & 822.xls, i need to copy the specific set of data under the row that contain the texts "IT" in 822.xls, it will first search for all the columns or rows that contain any texts with "IT", example "IT1122", "IT2312" after finding the rows with the text "IT" it will then copy the all data under "Facility" and "Remarks" of the row of "IT" and copy the data into another file called Information with the same texts containing "IT" under the same row that has the texts "Facility" and "Remarks". it has to match, as in, when it copy the data from the text "IT1122" from 822.xls and it will paste onto "IT1122" in Information.xls. this seems impossible, i tried my best but i still can't get it done..it's too complicated and too many matching of data has to be done in the function.. need advise! -- 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=509622 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a specific of data of texts containing "IT"
need advise!!! -- 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=509622 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a specific of data of texts containing "IT"
Mod--------Descrip------------------------------Facility----Time-----Day IT1122-----Object Oriented Programming----------LTQ-9-----9.00am--Wed IT2233-----Excel Programming--------------------LTQ-6-----1.00pm---Tues whereby the prgram 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" it sounds complicated..i wonder is this possible.. -- 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=509622 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a specific of data of texts containing "IT"
new_to_vba,
Record a macro whilst you use the EditFind menu option. Combine this with a Copy/Paste and "Offset" or "VLookUp". See what you get. NickHK "new_to_vba" wrote in message ... Mod--------Descrip------------------------------Facility----Time-----Day IT1122-----Object Oriented Programming----------LTQ-9-----9.00am--Wed IT2233-----Excel Programming--------------------LTQ-6-----1.00pm---Tues whereby the prgram 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" it sounds complicated..i wonder is this possible.. -- 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=509622 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a specific of data of texts containing "IT"
i have no idea how to do that? able to help me? i am really weak in this programming...:( -- 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=509622 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a specific of data of texts containing "IT"
i have no idea how to do that? able to help me? i am really weak in this programming...:( -- 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=509622 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a specific of data of texts containing "IT"
new_to_vba,
ToolsMacroRecord New Macro, accept the default Macro name, then perform your actions. Look at the code that is generated. Whilst this is not usually the most efficient code, it will give a good start to understand the process and learn how VBA works. NickHK "new_to_vba" wrote in message ... i have no idea how to do that? able to help me? i am really weak in this programming...:( -- 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=509622 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SORT a column of Texts to follow another "EXACT" order | Excel Discussion (Misc queries) | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| copy specific rows using "IF" to another sheet | Excel Worksheet Functions | |||
| Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
![new_to_vba[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
