GinoSanPascual
New Member
- Joined
- Jun 5, 2013
- Messages
- 1
Hello,
I have tried the search engine and I don't think I have worded my issue correctly. Pardon my English as it is not my first language.
I'll explain what I have and what I need.
What I have.
1. I have a workbook where it contains several sheets.
2. The first sheet will contain results from all the other sheets. Let's call the first sheet as the ReportPage*
3. Lets say the remaining sheets besides the ReportPage* are called Sprint1, Sprint2, Sprint3 and so on.
4. The ReportPage is a dynamic table.
5. The Sprint1 , Sprint2..etc, will contain 2 important Columns Lets name these Columns as Data* - Column A and Results* - Column B
Note : The Data and Results column are related to each other . so Data == Results.
6. The Sprint1, Sprint2..etc sheets, will have a cell that has the name of the sheet. Example : Cell A1 = Sprint 1.
What I need, badly.
1. The ReportPage* should contain the following.
Example
ReportPage
<tbody>
</tbody>
Sprint 1 sheet
Cell A1 = Sprint 1
<tbody>
</tbody>
Sprint 2 sheet
Cell A1 = Sprint 2
<tbody>
</tbody>
Is there a way to do this?
Thank you for the help!
-Gino
P.S Sorry if my question is unclear.
<tbody>
</tbody>
I have tried the search engine and I don't think I have worded my issue correctly. Pardon my English as it is not my first language.
I'll explain what I have and what I need.
What I have.
1. I have a workbook where it contains several sheets.
2. The first sheet will contain results from all the other sheets. Let's call the first sheet as the ReportPage*
3. Lets say the remaining sheets besides the ReportPage* are called Sprint1, Sprint2, Sprint3 and so on.
4. The ReportPage is a dynamic table.
5. The Sprint1 , Sprint2..etc, will contain 2 important Columns Lets name these Columns as Data* - Column A and Results* - Column B
Note : The Data and Results column are related to each other . so Data == Results.
6. The Sprint1, Sprint2..etc sheets, will have a cell that has the name of the sheet. Example : Cell A1 = Sprint 1.
What I need, badly.
1. The ReportPage* should contain the following.
- A Column that will contain the Data
- Columns for every Sprint*(Sprint 1, Sprint 2 sheets. this Sprint Sheets can go upto 20 or more) - In this issue, we can use the Cell A1 = Sprint
- Here's the kicker, For the Column Data* the information should be collected from the Sprint* Sheets, and every Data* this will show the Results on the Sprint* Columns
Example
ReportPage
Data | Sprint 1 (these are the sheets) | Sprint 2 (these are the sheets) |
Example Data 1 | Results 1 | Results 1 |
Example Data 2 | Results 2 |
<tbody>
</tbody>
Sprint 1 sheet
Cell A1 = Sprint 1
Data | Results | Notes: |
Example Data 1 | Results 1 | blah blah |
Example Data 3 | Results 3 |
<tbody>
</tbody>
Sprint 2 sheet
Cell A1 = Sprint 2
Data | Results | Notes: |
Example Data 2 | Results 2 | blah blah |
<tbody>
</tbody>
Is there a way to do this?
Thank you for the help!
-Gino
P.S Sorry if my question is unclear.
<tbody>
</tbody>