Copy rows from one file to another file
 

i need to copy a row of cells from one file to another file in
particular WorkSheet,
for example, i have 17 files and 17 worksheets from the 17 files,
need to copy the particular rows from the 17 files to another fil
which has 1 WorkSheet, named "Sheet1".
this seems impossible to done it, i have no idea how to work on this.
really apreciate anyone who is able to help

--
new_to_vb
-----------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...fo&userid=3013
View this thread: http://www.excelforum.com/showthread.php?threadid=50153