Could somebody help me with the code for copying values from 10 similar workbooks/worksheets to one central workbook/worksheet.
The 10 workbooks are named data1.xls, data2.xls ..... data10.xls. There are 2 worksheets in these workbooks - the one containing the values is named Data.
The values pasted must be entered in to the first available row in the central worksheet.
Thanks,
Lars