Macro to copy active worksheet from multiple Excel files into 1 fi
Good evening,
This may be on the forums already but i must be searching for it wrong if it
is.
A daily Excel file is placed into a folder. I'd like to have the worksheet
from all the files within that folder to be copy/pasted into a new workbook.
Example, each file has a worksheet named ABCcurrent date. I want the new
file/workbook to contain it all, ABC092208, ABC092308, ABC092408, etc. This
would save alot of manual labor.
Thank you for any support you can provide.
|