copy data when enter the file name
 

i have 6 files in One Folder, Resource, Pt1, Pt2, Pt3, Pt4, Pt5.

i need to copy the specific data from the 5 files Pt1,Pt2, Pt3, Pt4,
Pt5 when i enter the containing text of the FileName into the file
Resource,
example entering Pt in the spaces provided under the file Resource, and
it will copy all the data from the 5 files (Pt1, Pt2, Pt3, Pt4, Pt5)
into Resource.

this seems impossible..i 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=509263