Copy data when enter text containing the filename
 

i have 6 files in One Folder, Resource, Pt123, Pt234, TD123, TD456,
AC789.

i need to copy the specific data into Resource.xls when i enter the
containing text from the 5 files Pt123, Pt234, TD123, TD456, AC789

lets say when i enter the containing text of the FileName "Pt",
it will copy the specific row of data (A1:C1) from all the files
containing the text "Pt" into Resource .xls

this seems impossible..i have tired but have no 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=509618