Data Merging

[MIMITW]

Hello,
I receive approx 50 excel files a day, I'm looking for some suggestions on how to extract certain data ranges from them into one master workbook. Is access a better fix for this? I'm looking for an idea that would basically allow me to drag and drop the files into the master taking only the data that I need.


added: all of the 50+ workbooks are formatted exactly the same way however, the files are saved differently. Basically the workbooks are used as a type of form that is filled out by my employees and then emailed to me to compile the data.

Thank you, Wes

[teylyn]

Hi MIMITW,

this:

certain data ranges

and this

the files are saved differently.

would certainly require some more detail. Can you upload some samples? Maybe prepare a zip file and then add some more explanation about what you need and explain the logic?

[MIMITW]

The actual files are sensitive, but these workbooks show the intent. I receive dozens of the files labeled Source 1, 2 ect. I'm looking to extract the data in the fields labeled Data 1, 2 ect. to the Master workbook in correct fields. Since I get so many of the Source files a day I'm looking for suggestions on how to automate this process. If someone can help me with the correct code, I can tailor it to fit the needs of the actual workbooks i'm using. Also, the data that will need to be extracted will not necessarily be in a range....can i reference absolute values in the code?

[royUK]

I doubt if you can drag & drop the data from Excel. Your Source workbooks are not laid out very well for copying from. Can you control the layout at all?

[MIMITW]

I the actual source file lay-out is unchangeable, it resembles a form. Is there code that I can open one (or more) of the source files from the master and import the data I need? I can update the starter code to include the absolute values for the specific data cells that i need.