beetle_cca
New Member
- Joined
- Aug 11, 2014
- Messages
- 6
Hi,
Very new to excel and not sure how to accomplish what I need.
I have a multiple sheets with different names that look similar to the following:
<tbody>
</tbody><colgroup><col><col span="7"></colgroup>
What I need to do is the tranpose the data in the top 4 rows into a Summary sheet with the following headings:
Day Time Who What
If possible I would like this to happen automitically when new data is enter into the next column of the source sheets.
I hope someone can help.
TIA
Very new to excel and not sure how to accomplish what I need.
I have a multiple sheets with different names that look similar to the following:
A | B | C | D | E | F | ...... | |
1 | Day | 00 - Daily | 00 - Daily | 01 - Monday | 02 - Tuesday | 05 - Friday | |
2 | Time | 7:30 | 8:30 | 7:45 | 8:15 | 9:00 | |
3 | Who | Sales | Sales | Parts | Parts | Sales | |
4 | What | Rubbish | Rubbish | Rubbish | Rubbish | Rubbish | |
5 | Instructions | 1 | 8 | 9 | 1 | ||
6 | 2 | 5 | 5 | 6 | 2 | ||
7 | 3 | 4 | 2 | 3 | 3 | ||
8 | 4 | 6 | 3 | 8 | 9 | ||
9 | 5 | 9 | 6 | 5 | 8 | ||
10 | 6 | 10 | 9 | 2 | 7 | ||
11 | 7 | 1 | 5 | ||||
...... | 4 | 6 |
<tbody>
</tbody><colgroup><col><col span="7"></colgroup>
What I need to do is the tranpose the data in the top 4 rows into a Summary sheet with the following headings:
Day Time Who What
If possible I would like this to happen automitically when new data is enter into the next column of the source sheets.
I hope someone can help.
TIA