Gather data from multiple excel files in mutiple folders

G

Guest

Hello,

I need some help to generate a macro that will gather data from mutiple
excel files (all named the same) that are all located in their own
subdirectory.

More explanation:

I want the user to be able to select one main directory for the month, it
contains daily subdirectories that each have an excel file named: "QC
Production Sheet". Within this file, they each have a worksheet named:
"Gqf44"

I would like the macro to gather all the information on these sheets (after
the user selects the main monthly directory) in each daily subdirectory and
copy it the the master excel file that will perform the overall summary.
Basically have it copy each worksheet into the master and name these
worksheets with the date that is entered in cell "C5" from the worksheets
that are being pulled.

Any help on this item is greatly appreciated.

Thanks in advance...
 

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 Table of Contents 3
Macro to Combine Data from Multiple Sheets with Cell References 4
Excel 2013 Merge Data 2
Copy 1 file from multiple subdirectories to another directory 8
Gather data from multiple excel files into one master excel file 18
Template Folder with Excel Macros in Sub-Folders?? 0
open excel file and copy data to another file 4
Copying cells and formula from closed workbook to all sheets in open workbook 0

Top