View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Versace77 Versace77 is offline
external usenet poster
 
Posts: 29
Default 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.