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