Hi, Here is a Utility that i have been using, it copies from specified files and ranges in closed workbooks to a range specified in another closed workbook. cheers kanti