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