Exporting Data from Multiple Workbooks to a Master List

[bck]

Hi there,

I'm looking for help coding a specific macro multiple workbook task. Here's what I'm trying to do:

I have a folder, titled "Analysis". Inside it there is a "MasterList.xls" workbook and a "Data" folder.
Inside the "Data" folder are all my source workbooks.
The source workbooks are for two variables ('Word' or 'Image'), two conditions each ('6'--which is 'bigger', and '7'--which is 'smaller'), so there are 4 types of workbooks:
"6word_XXXX.xls"
"7word_XXXX.xls"
"6image_XXXX.xls"
"7image_XXXX.xls"
where XXXX is the subject number; there are about 150 subjects, so its 600 files, give or take.
In the each workbook, there is only ONE worksheet per workbook.
In the 'word' workbooks, I need to 'grab' 24 specific data points to export to the MasterList.xls
In the 'image' workbooks, I need to 'grab' 48 specific data points to export to the MasterList.xls
The MasterList.xls workbook has 5 worksheet tabs, only two of which are relevant: "Words" and "Images".

I want the Macro to:

Please Login or Register  to view this content.

Hope this is clear. Thanks in advance for all the help!

-bck

[royUK]

Here's an example that I posted for someone else recently. It combines data from several workbooks