I cannot upload the file. Can you modify the macro coding so that I can copy data from all workbook in folder range A2:AS2 to end of the row.(copy the data without header)


You can upload the workbooks by clicking 'Go Advanced' and then 'manage attachments'[/QUOTE]