Compiling data from several files into one

**Coaster** · 07-06-2010, 02:42 PM

Hi,

I'm trying to develop a way to gather information from several excel files into one that will analyse all the data. I want to collect, for ex, named ranges A, B and C from files 1, 2 and 3 and then display that data in file 4, where I will display that data in form of a chart (i'm guessing pivot tables here are essential).

What's the best way to accomplish this? Writing VBA code to copy data from those 1, 2 and 3 files to file nº4?

I'm sorry if it's confusing..

**JBeaucaire** · 07-06-2010, 08:18 PM

'WORKBOOKS TO 1 SHEET
I have a macro that may be pretty close to "ready to use" for collecting data all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.

**Coaster** · 07-13-2010, 10:57 AM

thanks JBeaucaire but this is not exactly what I want...I want something more simple

I would like to compile into one file a determined amount of data, in this case, some 15-20 named ranges from other files. The other files work as a template, they are all similar, except for the input data.

I would then like for excel to collect those named ranges from those files (which are located in a folder) into the "master" file which will contain all the data.

how can this be achieved?

thank you