dubber
06-22-2010, 12:33 AM
Hello
I'm trying to use this macro to copy multiple sheets from multiple files. I have the files sales2010.xls, sales 2009.xls, sales 2008.xls. each contianing the sheet "sales". I would like to copy them into a new files with sheet names sales09, sales10,...
any sugestions?
thanks!
Admin edit: Moved from thread, referenced here: http://www.vbaexpress.com/forum/showthread.php?t=7003
I'm trying to use this macro to copy multiple sheets from multiple files. I have the files sales2010.xls, sales 2009.xls, sales 2008.xls. each contianing the sheet "sales". I would like to copy them into a new files with sheet names sales09, sales10,...
any sugestions?
thanks!
Admin edit: Moved from thread, referenced here: http://www.vbaexpress.com/forum/showthread.php?t=7003