Copy a specific of data of texts containing "IT"

  • Thread starter Thread starter new_to_vba
  • Start date Start date
N

new_to_vba

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!
 
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,
Record a macro whilst you use the Edit>Find menu option.
Combine this with a Copy/Paste and "Offset" or "VLookUp".
See what you get.

NickHK
 
i have no idea how to do that?
able to help me?
i am really weak in this programming...:(
 
i have no idea how to do that?
able to help me?
i am really weak in this programming...:(
 
new_to_vba,
Tools>Macro>Record 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match and copy data 3
look up a set of values,copy a range of data into 2nd file 1
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Macro that deletes and pastes filterd rows and then some 2
Find cells that contain text 5
Find a value in a sheet and replace it with another value if it matches 8
Copy hyperlinks 6
Copy Range of data using VBA 0

Back
Top