Macro to copy active worksheet from multiple Excel files into 1 fi

  • Thread starter Thread starter Versace77
  • Start date Start date
V

Versace77

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.
 
Mark, thanks for the quick reply.

After looking at the link you provided I think it's focusing on something
different. The link shows how to 'create a workbook from every sheet in your
workbook'.

I'm looking at having the active sheet from many many workbooks located in
one folder copied into a new workbook so that i now have one workbook
containing all the sheets that were located, separately in the other folder.

Example: Folder C:\Data contained 50 Excel files. Each excel file contains
1 worksheet title ABCcurrentdate. I'm looking for a macro to open or copy
each of the 50 worksheets from the 50 files and place them into 1 new
workbook so that this new work book now contains 50 sheets.

Again, thanks Mark for your reply.

Many thank to anyone that can assist.
 
Hi Versace !! :)
You can open all the daily Excel files in your
folder, if you know the file names.The rest of the solution is rather simple.
You can copy-move the particular sheets fromall the files to your new
workbook. This is done by checking all the sheets in the daily Excel file to
find the sheet to copy.

I hope this will help you !

Vijay
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet copying in Excel 2007 3
Excel 2011 Mac - Import Worksheets into a Single File 0
Macro for all Excel Workbooks to print to PDF 2
Copying and pasting a worksheet to a different excel workbook 3
Run macro on all files in a specific folder 3
Macro to open file and copy information from worksheet 1
Copying worksheet from hidden instance of Excel 1

Back
Top