Excel files as one Master Excel file

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

can you give us an example of your sheet? Than its a lot easier to help you.
If you have tried the code you linked what was the problem with it?

Greets
Loki