i need to copy a row of cells from one file to another file in a particular WorkSheet,
for example, i have 17 files and 17 worksheets from the 17 files, i need to copy the particular rows from the 17 files to another file 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.