Lisa Harris
New Member
- Joined
- Sep 19, 2016
- Messages
- 17
Hi, hoping someone can help as I cannot find a solution at all.
I have a workbook with two sheets. One is the active data sheet (sheet 1), the other is a reference / list (sheet 2).
Sheet 2 details across the columns (C:E) the 'Types', and below each type, lists the Tasks for that type (used letters for this example):
<tbody>
</tbody>
<tbody>
</tbody>
Sheet 1 is the data entry sheet. In column F, a 'type' will be selected from a drop down list. When this happens, I need the relevant list for that type on sheet 2, to be pasted in column H on the row of the 'Type' and subsequent rows needed to fit the list. Once this has been done, I would also like the Type cell (column F) to be merged and centered to reach the number of rows the list is, and the same for the title (column G) - please see below (unable to show the merged cells as it sent my table all off - apologies)
<tbody>
</tbody>
Many thanks in advance for any help you can offer
Lisa
I have a workbook with two sheets. One is the active data sheet (sheet 1), the other is a reference / list (sheet 2).
Sheet 2 details across the columns (C:E) the 'Types', and below each type, lists the Tasks for that type (used letters for this example):
1 | 2 | 3 |
a | a | a |
b | b | c |
c | c | d |
d | d | |
e |
<tbody>
</tbody>
<tbody>
</tbody>
Sheet 1 is the data entry sheet. In column F, a 'type' will be selected from a drop down list. When this happens, I need the relevant list for that type on sheet 2, to be pasted in column H on the row of the 'Type' and subsequent rows needed to fit the list. Once this has been done, I would also like the Type cell (column F) to be merged and centered to reach the number of rows the list is, and the same for the title (column G) - please see below (unable to show the merged cells as it sent my table all off - apologies)
column | F | G | H | I | J |
Type | Title | Tasks | |||
1 | title 1 | a | |||
b | |||||
c | |||||
d | |||||
e | |||||
2 | title 2 | a | |||
b | |||||
c | |||||
d | |||||
3 | title 3 | a | |||
c | |||||
d | |||||
1 | title 4 | a | |||
b | |||||
c | |||||
d | |||||
e | |||||
1 | title 5 | a | |||
b | |||||
c | |||||
d | |||||
e |
<tbody>
</tbody>
Many thanks in advance for any help you can offer
Lisa