Reading data arrays from multiple data files in excel

H

Hankjam

Hello

Hope someone can help me with this. Been thinking about how to do it
for sometime and getting nowhere pretty fast.

I have, lets say 200 data files of which I want to extract an 8 by 12
data set with a range B128:M135. These files have a numbering
convention of 05_feb08_0001, 05_feb08_0002 and so on.

What I would like to do is just type in the filename and a template 8
by 12 would be filled with the data from the named file...

Hope I 've explained that okay.

Many thanks for your time

Andrew j
 
Top