Pulling the same cell(s) from a number of different files

[dbn]

Sorry - bit of an amatuer question.

If I have to pull some data (always in the same cells) from a number of different excel files (>50) to collate them in one workbork - what's the easiest way of achieving this?

I assume VBA code of some sort?

Many thanks

 

[Andrew Poulsom]

You could use formulas, but if you want a macro solution look here:

http://www.rondebruin.nl/copy3.htm

 

[dbn]

v.useful! thanks.