What is the full path to where the workbooks are stored? c:/test
What is the sheetname that you want to copy from in all the workbooks? big is the summing workbook
What is the range, in the above sheetname, of the information you want to copy? a1:n100
What is the workbook name, and sheetname, where you want to copy the information to? i have some workbooks tat i want to copy to "big" , the name are : book1 , book2 , book3 .
the name of the sheetname is "7.07" in all of the workbooks
many many thanks