Hi,

I have quite a few excel files, all containing the exact same table though with different values. I am trying to combine these files into one masterfile. I would like all the information in one sheet preferably.

I have tried using some VBA Coding, though without luck.

http://www.thespreadsheetguru.com/th...a-given-folder


Any input is greatly appreciated, as I am a noob to advanced excel usage.

Many thanks!

/ Nina