G
Gerry
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.
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.