| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy active worksheet to new workbook | Excel Discussion (Misc queries) | |||
| VB macro to load/copy/paste multiple files into one spreadsheet. | Excel Programming | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| How do I edit a worksheet and copy to multiple files? | Excel Discussion (Misc queries) | |||
| Copy worksheet from multiple files in one DIR to another DIR & rename | Excel Programming | |||
Threaded Mode
