J
juergenkemeter
Hi!
I have a folder containing about 300 Excel workbooks. These contain th
same Sheet names. ('Sequence Data' and 'Sequence Analysis')
Each Sheet is divided into several sectors, i.e. rows, with differen
headings.
I enclosed two examples.
I must collect all data, written in these different sectors of th
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 thi
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 ne
target worksheets.
My problem is to process many workbooks, and write their output into
corresponding target sheet,.
Perhaps there is a way to combine the two code examples, from thi
Link:
http://tinyurl.com/5ouc4
The first and the second approach (loop and manual selection of sourc
ranges).
Aem...Merry Christmas By the Way!!
Cheers
Juerge
+-------------------------------------------------------------------
|Filename: Gene_Examples.zip
|Download: http://www.excelforum.com/attachment.php?postid=4147
+-------------------------------------------------------------------
I have a folder containing about 300 Excel workbooks. These contain th
same Sheet names. ('Sequence Data' and 'Sequence Analysis')
Each Sheet is divided into several sectors, i.e. rows, with differen
headings.
I enclosed two examples.
I must collect all data, written in these different sectors of th
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 thi
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 ne
target worksheets.
My problem is to process many workbooks, and write their output into
corresponding target sheet,.
Perhaps there is a way to combine the two code examples, from thi
Link:
http://tinyurl.com/5ouc4
The first and the second approach (loop and manual selection of sourc
ranges).
Aem...Merry Christmas By the Way!!
Cheers
Juerge
+-------------------------------------------------------------------
|Filename: Gene_Examples.zip
|Download: http://www.excelforum.com/attachment.php?postid=4147
+-------------------------------------------------------------------