Aggregating Data in Fifteen Unopened Spreadsheets into Single

I have a series of 15 spreadsheets, all having the same column
structure. They all have the same filename barring first two letters
which refer to a persons initials. The 15 files are stored in the
same directory. In that directory I'd like to create a sixteenth file
which consolidates much of the data in the 15 files. I want to use
that consolidated data in a pivot table. I know that the top-left-
hand-corner of the range I want within each of the 15 spreadsheet
files is the Cell A10. I cannot be so precise with the bottom right
hand corner (BRHC) as the number of rows is variable in each of the
fifteen sheets. I know that the BRHC is in column S (if that
helps). Additionally, within each of the 15 files there is around 25
rows of data below the BRHC which I do not want to insert into the
consolidated file.

Can anyone give me pointers as to the easiest way that I can create
the sixteenth file, without having any blank rows in that consolidated
file.

Ideally without the hassle of having to open the 15 files.

Thanks.

Roger
Thu May 08 01:51:28 CDT 2008

Hi

Ron de Bruin has lots of code examples, and an Addin for carrying out this
type of operation.
Take a look at
http://www.rondebruin.nl/tips.htm

--
Regards
Roger Govier

"Gerry" <gmccaffrey@acutus.co.uk> wrote in message
news:239044e1-5ab9-4371-ab56-cafe4afa5706@l64g2000hse.googlegroups.com...
> I have a series of 15 spreadsheets, all having the same column
> structure. They all have the same filename barring first two letters
> which refer to a persons initials. The 15 files are stored in the
> same directory. In that directory I'd like to create a sixteenth file
> which consolidates much of the data in the 15 files. I want to use
> that consolidated data in a pivot table. I know that the top-left-
> hand-corner of the range I want within each of the 15 spreadsheet
> files is the Cell A10. I cannot be so precise with the bottom right
> hand corner (BRHC) as the number of rows is variable in each of the
> fifteen sheets. I know that the BRHC is in column S (if that
> helps). Additionally, within each of the 15 files there is around 25
> rows of data below the BRHC which I do not want to insert into the
> consolidated file.
>
> Can anyone give me pointers as to the easiest way that I can create
> the sixteenth file, without having any blank rows in that consolidated
> file.
>
> Ideally without the hassle of having to open the 15 files.
>
> Thanks.