tomy_d
12-10-2008, 02:39 AM
Hi All,
I'm new to the forum and although i've had a look through many of the posts and searched I couldn't seem to find a solution which did what I believe I need.
The situation is that I have a directory structure with a top level directory and multiple sub-folders 1 level below this.
Within each of the sub folders is 1 .xls workbook.
Within each work book is a worksheet called "Test Info"
This worksheet has a header A1:Z3.
Beneath the header can be unlimited number of rows, however there is a footer record with the delimiter "*** END ***" in column A always at the end of the data, potentially there may be blank rows above this which I do not wish to copy.
I wish to be able to take all of the populated rows from the children worksheets and consolidate them onto 1 worksheet in the master spreadsheet, the header will always remain the same as will the number of columns.Any help on this will be much appreciated - if you need more information please let me know.
Thanks in advance!
I'm new to the forum and although i've had a look through many of the posts and searched I couldn't seem to find a solution which did what I believe I need.
The situation is that I have a directory structure with a top level directory and multiple sub-folders 1 level below this.
Within each of the sub folders is 1 .xls workbook.
Within each work book is a worksheet called "Test Info"
This worksheet has a header A1:Z3.
Beneath the header can be unlimited number of rows, however there is a footer record with the delimiter "*** END ***" in column A always at the end of the data, potentially there may be blank rows above this which I do not wish to copy.
I wish to be able to take all of the populated rows from the children worksheets and consolidate them onto 1 worksheet in the master spreadsheet, the header will always remain the same as will the number of columns.Any help on this will be much appreciated - if you need more information please let me know.
Thanks in advance!