making a Archive workbook

[bamaisgreat]

Does anyone no were some post are describing and showing some code examples of how to make a Archive Book ?
I have about 15 workbooks that are opened everyday with a material Inventory list. I would like to possibly have a maro that will copy all data and copy it to a main workbook(archive Book) and then open another and copy all of it to the same workbook but to the next empty row.. Thanks

 

[JLGWhiz]

Does anyone no were some post are describing and showing some code examples of how to make a Archive Book ?
I have about 15 workbooks that are opened everyday with a material Inventory list. I would like to possibly have a maro that will copy all data and copy it to a main workbook(archive Book) and then open another and copy all of it to the same workbook but to the next empty row.. Thanks

Take a look at this post.

http://www.mrexcel.com/forum/showth...t-to-a-single-workbook-of-multiple-worksheets