lookingforananswer
New Member
- Joined
- Aug 13, 2015
- Messages
- 2
Hello everyone,
I´m trying to analyze several measurements in one excel Worksheet.
Attached you find the xls sheet and a picture showing the folder structure where the measurement data is stored.
https://www.dropbox.com/s/7dvmtv458cpumb4/Capture.JPG?dl=0
https://www.dropbox.com/s/xvk6fdjt9cb091w/Example.xlsx?dl=0
For several sections I always did the same measurements of different types (A,B,C).
For each section exists one worksheet.
On the worksheet "overview" I want to use different diagrams which take the data
out of the worksheets for the different sections.
If I want to compare measurements of type "A" for all sections then I have to manually
drag and drop e.g.
"A.txt" from the corresponding folder "D:\Textfiles\Section A\1\A.txt" in the worksheet "Section A - 1"
as well as
"A.txt" from the corresponding folder "D:\Textfiles\Section A\2\A.txt" in the worksheet "Section A - 2"
and so on, for all worksheets.
I want to automatize that process.
My idea is, that i have the names of the worksheets with the measurements (e.g. "Section A - 1") in a column (e.g. column A) on the overview page
and in one of the columns next to it (e.g. cloumn G), I write the paths to the .txt files of the corresponding measurements (D:\Textfiles\Section A\1\A.txt).
Excel should then automatically load the .txt file under that file path in the corresponding worksheet.
How can I realize that?
Thank you already in advance for your help.
I´m trying to analyze several measurements in one excel Worksheet.
Attached you find the xls sheet and a picture showing the folder structure where the measurement data is stored.
https://www.dropbox.com/s/7dvmtv458cpumb4/Capture.JPG?dl=0
https://www.dropbox.com/s/xvk6fdjt9cb091w/Example.xlsx?dl=0
For several sections I always did the same measurements of different types (A,B,C).
For each section exists one worksheet.
On the worksheet "overview" I want to use different diagrams which take the data
out of the worksheets for the different sections.
If I want to compare measurements of type "A" for all sections then I have to manually
drag and drop e.g.
"A.txt" from the corresponding folder "D:\Textfiles\Section A\1\A.txt" in the worksheet "Section A - 1"
as well as
"A.txt" from the corresponding folder "D:\Textfiles\Section A\2\A.txt" in the worksheet "Section A - 2"
and so on, for all worksheets.
I want to automatize that process.
My idea is, that i have the names of the worksheets with the measurements (e.g. "Section A - 1") in a column (e.g. column A) on the overview page
and in one of the columns next to it (e.g. cloumn G), I write the paths to the .txt files of the corresponding measurements (D:\Textfiles\Section A\1\A.txt).
Excel should then automatically load the .txt file under that file path in the corresponding worksheet.
How can I realize that?
Thank you already in advance for your help.
