juergenkemeter
Programmer
Hi!
I have a folder containing about 300 Excel workbooks. These contain the same Sheet names. ('Sequence Data' and 'Sequence Analysis')
Each Sheet is divided into several sectors, i.e. rows, with different headings.
I must collect all data, written in these different sectors of the sheets, and write them in a workbook.
My idea is to loop through the Folder, and open each workbook.
Then look into their sheets, export available data written in sectors.
Taking the worksheet 'Sequence Data' as an example:
It contains the data sectors 'Primary Sequences', 'Derived Sequences', and 'Electronic Sequences' as you can see in the enclosed files to this thread.
- The source data in 'Primary Sequences' is written in Range(B6:M9)
- 'Derived Sequences' - Range(B11:M14)
- 'Electronic Sequences' - Range(B16:M20)
Now I want to collect all data written in these sectors, into three new target worksheets.
My problem is to process many workbooks, and write their output into a corresponding target sheet,.
Perhaps there is a way to combine the two code examples, from this Link:
The first and the second approach (loop and manual selection of source ranges).
I can send example workbooks for better explanation.
Aem...Merry Christmas By the Way!!
Cheers
Juergen
I have a folder containing about 300 Excel workbooks. These contain the same Sheet names. ('Sequence Data' and 'Sequence Analysis')
Each Sheet is divided into several sectors, i.e. rows, with different headings.
I must collect all data, written in these different sectors of the sheets, and write them in a workbook.
My idea is to loop through the Folder, and open each workbook.
Then look into their sheets, export available data written in sectors.
Taking the worksheet 'Sequence Data' as an example:
It contains the data sectors 'Primary Sequences', 'Derived Sequences', and 'Electronic Sequences' as you can see in the enclosed files to this thread.
- The source data in 'Primary Sequences' is written in Range(B6:M9)
- 'Derived Sequences' - Range(B11:M14)
- 'Electronic Sequences' - Range(B16:M20)
Now I want to collect all data written in these sectors, into three new target worksheets.
My problem is to process many workbooks, and write their output into a corresponding target sheet,.
Perhaps there is a way to combine the two code examples, from this Link:
The first and the second approach (loop and manual selection of source ranges).
I can send example workbooks for better explanation.
Aem...Merry Christmas By the Way!!
Cheers
Juergen
