I have the following challenge, which I'm quite sure it's possible, but I've no idea how...
In a certain directory on a pc are several partnumber files stored. I've attached 2 examples ("B661-6230" and "B661-6234"). These files will have a date in the filename as well, but the partnumber section remains unchanged. So the final filename should look something like "B661-6230 16072013" for a file from today. Tomorrow it reads something like "B661-6230 17072013" etc.
There is a sheet in these files (can have variable names) in which various data is scanned / calculated.
There is also a masterfile, for the whole familycode. In this example, familycode N94. This masterfile is also attached (file "N94"). In this masterfile you see various sheets for each partnumber, proceeded by the familycode. So you have e.g. "N94 B661-6230" and "N94 B661-6234".
There is already a macro in the masterfile which pulls all the data from these individual sheets into the "Overall sheet" in the masterfile.
What I'm missing now, is a macro which looks into a certain directory, opens all these several partnumber files and fills these individual sheets of the masterfile.
The data itself is a simple copy / paste of the first 11 columns of each partnumber file.
I hope that the below is a bit clear... in case you need further clarification / examples, please let me know.
As always, many thanks for your time and effort to help me out here..!!!